字體:小 中 大 |
|
|
|
| 2008/05/25 21:52:19瀏覽609|回應0|推薦0 | |
1. SELECT
SELECT * FROM {表格名} 2. INSERT INTO INSERT INTO {表格名} ( 欄位一, 欄位二, 欄位三 ) VALUES ( '{欄位一的值}', '{欄位二的值}', '{欄位三的值}' ) INSERT INTO {表格名} ( 欄位一, 欄位二, 欄位三 ) SELECT xxx1 AS 欄位一, xxx2 AS 欄位二, xxx3 AS 欄位三 FROM {表格名二} 3. UPDATE UPDATE {表格名} SET {欄位一} = {欄位一的值}, {欄位二} = {欄位二的值} WHERE {過濾條件} 4. DELETE DELETE FROM {表格名} WHERE {過濾條件} |
|
| ( 知識學習|其他 ) |











