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





  Welcome to the Automation Media's - MySQL made Easy for Engineers
  MySQL Query - SELECT & FROM

 




 
MySQL Query - SELECT & FROM


Retrieving Data from MySQL

Once you have data in MySQL table then you need to Query data from database.
In MySQL, data is retrieved with the "SELECT" keyword.

Syntax:
SELECT * FROM [table name]





Example
SELECT * FROM Alarms
This query will bring all data from table Alarms.

Show certain selected rows with the value "Pump23"
Syntax:
SELECT * FROM [table name] WHERE [field name] = "Pump23";

Example
SELECT * FROM alarms WHERE [field name] = "Pump23";
This query will bring data from table Alarms with the value Pump23




Go Back To MySQL Tutorial


 


........

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