How to check MySQL data in htpc database
Process to execute MySQL Queries
Saurav Das
Last Update 2 years ago
Follow these steps to open MySQL Workbench.
1. Search ‘MySQL Workbench’ in windows search area.
2. Open and navigate to MySQL Connection localhosts:3306. And double click on it.
3. A prompt may appear for password. Enter ‘root’ as password.
4. A screen will appear where you can write down queries and the check data
Navigate to query page. It should be already open with some pre run queries as shown below.
5. Write there “Select * from plc_data.htpc_raw_data order by 1 desc;” then select the query and then press execute button. Change the query as required and press execute button to check.
The common practice is to check the DateAndTime Column the in htpc_raw_data, table and MIS PC time. The column should have last pushed data.
For example if MIS PC date is 1-Jan-2025 then the DateAndTime column will have value for same date, if carousel is running.
Kindly write the query carefully as small extra or no space will lead to Error while executing query.
Query for getting latest data
Copy query from here.
Query for getting data between datetime
Query for getting few columns
Query using multiple conditions
As F22=1 is Category 1 and F12 is deviation. Find all column details from Default Mapping article by visiting below link
Query to take back up of htpc_raw_data
First run alter table query. Then Run the Create Table Query
Step 1: Rename the existing table to backup
Step 2: Create a new table named htpc_raw_data