[SQL] 語法整理

* [date, time comparison時間比較]

Select * From temp where mydate > '2009-06-29 16:00:44';

* [skip, limit] MySQL skip first 10 results

SELECT * FROM foo LIMIT 10, 50

* [增加欄位] ALTER TABLE 敘述句 (SQL ALTER TABLE Statement)

ALTER TABLE table_name
ADD column_name datatype;