JZTXT

十、插入数据

发布时间 2023-04-12 18:05:37作者: 5250
10.1插入完整行
>>> insert into customers values(NULL,'Pep E. LaPew','100 Main Street','Los Angels','CA','90046') ;  #给表中的每一列都赋值,该语句当表结构发生变化时会出错
>>> insert into customers(cust_name,cust_address,cust_city,cust_state) values('Pep E. LaPew','100 Main Street','Los Angels','CA');
#给表中的每一列都赋值,该语句指定了列名，所以表结构发生变化时也不会出错

10.2插入多行
>>> insert into customers(cust_name,cust_address,cust_city,cust_state) values('Pep E. LaPew','100 Main Street','Los Angels','CA'),
>>>                                                                          ('Pep E. LaPew','100 Main Street','Los Angels','CA');
10.3插入某些查询结果
>>> insert into customers(cust_name,cust_address,cust_city,cust_state) select cust_name,cust_address,cust_city,cust_state from cust_new;