MySQL语法模板 SQL语句:常用

MySQL语法模板系列

1. SELECT 查询语句

SELECT col_name,...
  FROM table_name
 WHERE where_condition
 GROUP BY col_name,... 
HAVING where_condition
 ORDER BY col_name,...
 LIMIT offset,row_count

2. INSERT 插入语句

INSERT INTO table_name(col_name,...) values(expr,...)

3. UPDATE 更新语句

UPDATE table_name SET col_name=expr,... WHERE where_condition

4. DELETE 删除语句

DELETE FROM table_name WHERE where_condition 

5. REPLACE INTO 插入数据 如果已存在则删除旧数据插入新数据

REPLACE INTO table_name(col_name,...) values(expr,...)