Tuesday, December 18, 2018 Useful Resources for Industrial Technology Enthusiasts!





  Welcome to the Automation Media's - MySQL made Easy for Engineers
  MySQL - SELECT Examples

 




 
MySQL - SELECT Examples


Query: Show All Data in a Table.

SELECT * FROM [table name];

Query: Show certain selected rows with the value "Pump32"

SELECT * FROM [table name] WHERE [field name] = "Pump32";




Query: Show all records containing the operator name "Paul" AND the Alarms on Node 'SCADA3'

SELECT * FROM [table name] WHERE name = "Paul" AND NodeName = 'SCADA3';





Go Back To MySQL Tutorial


 


........

Site customized for Screen Resolution - 1400 x 1050
Site Map    I    Copyright © 2018 Automation Media. All rights reserved.