SQL语句

INSERT INTO Customer_Data  //插入表
(customer_id,first_name,last_name,phone)  //字段
VALUES (001,"Frank","liu",34312222)       //值

UPDATE Customer_Data
SET first_name="Frank"
WHERE last_name="liu" and customer_id = 001

DELETE FROM Costomer_Data
WHERE customer_id>001

SELECT *   //字段
FROM Customer_data
WHERE customer_id<10

SELECT p.*
FROM Prodection.Prodect P
ORDER BY Name ASC