修改数据库的内容.pptVIP

修改数据库的内容 INSERT INSERT [ hint ] INTO table_expression_clause [ (column [,…n] ) ] { values_clause | subquery } [,…n] ; DESCRIBE customers 显示表的字段 INSERT INSERT INTO customers (customer_id, first_name,last_name,dob,phone) VALUES (6,Fred,Brown,01-1月-1970,800-555-1215) INSERT INTO customers VALUES (7,’Jane’,’Green’,’01-1月-1970’,’800-555-1216’) INSERT 空值：NULL INSERT INTO customers VALUES (8,Sophie,White,NULL,NULL) INSERT INSERT INTO customers VALUES (9,Kyle,OMally,NULL,NULL) INSERT INTO products (product_id, product_type_id,name,description, price) VALUES (13,1,The “Great” Gatsby,NULL,12.9