FROM命令用于指定從哪個表中選擇或刪除數(shù)據(jù)。
以下SQL語句從“Customers”表中選擇“CustomerName”和“City”列:
SELECT CustomerName, City FROM Customers;
以下SQL語句從“Customers”表中選擇所有列:
SELECT * FROM Customers;
以下SQL語句從“Customers”表中刪除客戶“ Alfreds Futterkiste”:
DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';