Tom程式紀錄分享

 
Select * from table_name //查詢 
 
 
INSERT INTO table_name (column1, column2, column3,···)  //新增 
VALUES (value1, value2, value3,···); 
 
UPDATE table_name                                                            //更新 
SET column1=value1, column2=value2, column3=value3··· 
WHERE column_name operator value; 
 
 
DELETE FROM table_name                                                 //刪除 
WHERE column_name operator value;