WHERE column_name
LIKE pattern
ORDER BY SELECT column_name(s)
FROM table_name
INTO new_table_name
FROM original_table_name
TRUNCATE TABLE
(deletes only the data inside the table) TRUNCATE TABLE table_name
UPDATE UPDATE table_name
SET column_name=new_value
[, column_name=new_value]
WHERE column_
太过于简单了。。拿来看一下结构可以
WHERE column_name LIKE pattern ORDER BY SELECT column_name(s) FROM table_name INTO new_table_name FROM original_table_name TRUNCATE TABLE (deletes only the data inside the table) TRUNCATE TABLE table_name UPDATE UPDATE table_name SET column_name=new_value [, column_name=new_value] WHERE column_