SQL Statement Basics

It's all written in MySQL.

1. Enquiry

The following sentence can handle most simple SQL queries:

SELECT field from table WHERE field = value ORDER by field 1 ASC, field 2 DESC LIMIT starting point, number of data bars

Total number of query data:

SELECT COUNT (*) as C from table

2. Insert

INSERT into table (field 1, Field 2 ...) Values (value 1, value 2 ...)

3. Update

UPDATE SET field 1= value 1, field 2= value 2 WHERE field = value

4. Delete

DELETE from table WHERE field = value

It is not difficult to see that the most difficult is the query statement, and the database is the most of the operation is actually a query, a variety of conditions overlay can even write a Timbers K SQL statement.

SQL Statement Basics