Thursday, March 22, 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.