015.insert.sql

USE `sqlin10mins`;

-- 数据库的增删查改，我们之前一直在学习'查'，现在来学习'增'

-- 请在customers表中增加一行数据,有新的顾客来了!但是它没有提供cust_country,cust_contact和cust_email项

insert into Customers(cust_id ,cust_name,cust_address,   cust_city,     cust_state,cust_zip)
            values( concat(FLOOR(RAND() * 1000000000), ''),       'Toy Land','123 Any Steet','New York',  'NY',       '11111');
            
 -- 插入多行数据：
 -- insert into table_name(col1,col2...) values (col1,col2,...),(col2,col2,...)


-- 插入检索出的数据  --现需要将另一表CustNew中的顾客合并到customers中.
-- insert into Customers(cust_id,cust_city,cust_name,cust_state,cust_address,cust_email,cust_contact) select (cust_id,cust_city,cust_name,cust_state,cust_address,cust_email,cust_contact)from CustNew;

-- 复制表  请复制Customers表，命名为CustCopy
-- TODO 待解决primary key不重复问题
create table CustomersCopy2(id int not null auto_increment, PRIMARY KEY (id)) as select * from Customers;


-- 如果只想复制部分列，可以明确给出列名
-- select cust_city,cust_contact,cust_id into CustCopy from Customers;
-- create table CustCopy_2  as select cust_city,cust_contact,cust_id from Customers;