SQL SELECT 语句

1. SELECT _column_name_,_column_name_ FROM _table_name_;

   SQL SELECT DISTINCT 语句

   SELECT DISTINCT _column_name_,_column_name_ FROM _table_name_;

   SQL WHERE 子句

   SELECT _column_name_,_column_name_<br />FROM _table_name_<br />WHERE _column_name operator value_;

   SQL AND & OR 运算符

   SQL ORDER BY 关键字

   SELECT _column_name_,_column_name_<br />FROM _table_name_<br />ORDER BY _column_name_,_column_name_ ASC|DESC;

   SQL INSERT INTO 语句

   第一种形式无需指定要插入数据的列名，只需提供被插入的值即可：
   INSERT INTO _table_name_<br />VALUES (_value1_,_value2_,_value3_,...);
   第二种形式需要指定列名及被插入的值：
   INSERT INTO _table_name_ (_column1_,_column2_,_column3_,...)<br />VALUES (_value1_,_value2_,_value3_,...);

   SQL UPDATE 语句

   UPDATE _table_name_<br />SET _column1_=_value1_,_column2_=_value2_,...<br />WHERE _some_column_=_some_value_;

   SQL DELETE 语句

   DELETE FROM _table_name_<br />WHERE _some_column_=_some_value_;