Shulou(Shulou.com)06/01 Report--

1. Insert the complete line

insert into table (

xxx_id,

xxx_name,

……

xxx_address)

valus(

'xxxxxx',

'xxxxxx',

……

'xxxxxx');

Examples:

insert into custnew (

cust_id,

cust_name,

cust_address,

cust_city,

cust_state,

cust_zip,

cust_country,

cust_contact,

cust_email)

values(

'1000000008',

'zhang',

'shitonglu street',

'shijiazhuang',

'sjz',

'3333',

'china',

'sun',

'10110@126.com');

2. Insert retrieved data

insert into table1（

xxx_id,

xxx_name,

……

xxx_address

select

xxx_id,

xxx_name,

……

xxx_address

from table2;

Examples:

insert into customers (

cust_id,

cust_name,

cust_address,

cust_city,

cust_state,

cust_zip,

cust_country,

cust_contact,

cust_email)

select cust_id,

cust_name,

cust_address,

cust_city,

cust_state,

cust_zip,

cust_country,

cust_contact,

cust_email

from custnew

Note: The retrieved data from table 1 and table2 must be inserted into table1, and table2 must be filled first.

2. The retrieved value of table2 cannot exist in table1, otherwise the insertion is unsuccessful.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.