RIiver's MYSQL NOTE

常用的語法作紀錄：

查詢

SELEST * FROM '表'

查詢不重複 

SELECT DISTINCT `欄位` FROM `表`

大量指定查詢 

SELECT DISTINCT `欄位` FROM `表` WHERE ID =('AAA','BBB')

寫入

INSERT INTO 

INSERT INTO table_name ( field1, field2,...fieldN ) VALUES   ( value1, value2,...valueN )

  

更新

UPDATE

DELETE FROM itread01_tbl WHERE itread01_id=3