mysql 数据插入（备份表，复制表等操作）

数据插入：
方式一：

INSERT INTO Customers(cust_id,
   cust_name,
   cust_address,
   cust_city,
   cust_state,
    cust_zip,
   cust_country,
   cust_contact,
   cust_email)
VALUES(1000000006,
  'Toy Land',
  '123 Any Street',
  'New York',
  'NY',
  '11111',
  'USA',
   NULL,
   NULL);

方式二：

INSERT INTO Customers
VALUES(1000000006, 
 'Toy Land',
 '123 Any Street',
 'New York',
 'NY',
 '11111',
 'USA',
 NULL,
 NULL); 

备份表：

CREATE TABLE CustCopy AS SELECT * FROM Customers;

拷贝另外一个表的数据到目标表：

INSERT INTO Customers(cust_id,
          cust_contact,
         cust_email,
         cust_name,
         cust_address,
          cust_city,
          cust_state,
          cust_zip,
          cust_country)
SELECT
       cust_id,
      cust_contact,
       cust_email,
        cust_name,
       cust_address,
       cust_city,
       cust_state,
       cust_zip,
        cust_country
FROM CustNew;