《mysql必知必会》学习_第19章_20180809_欢
第19章 插入数据
P132
insert into customers VALUES(NULL,'Pep E.Lapew','100 Main Street',,Los Angeles','CA','90046','USA',NULL,NULL); #customers表中刚好有9个维度(一定要对应上),9个值会对应这9个维度,维度的次序由表定义#
insert into customers (cust_name,cust_address,cust_city,cust_state,cust_zip,cust_country,cust_contact,cust_email) VALUES(NULL,'Pep E.Lapew','100 Main Street',,Los Angeles','CA','90046','USA',NULL,NULL); #把维度列出来,按这个顺序对应后面的值填充到新行#
跑出来对应的结果是这样:
insert into customers(cust_name,cust_address,cust_city,cust_state,cust_zip,cust_country) VALUES('Pep E.Lapew','100 Main Street',‘Los Angeles','CA','90046','USA')
insert into customers(cust_name,cust_address,cust_city,cust_state,cust_zip,cust_country) VALUES('Pep E.Lapew1','100 Main Street1',’Los Angeles1','CA1','90045','USA1'); #同时增加两行,维度和值一一对应# #是的我没运行出来,不知道是不是版本的问题,还是语句出错了)
insert into customers(cust_name,cust_address,cust_city,cust_state,cust_zip,cust_country) VALUES('Pep E.Lapew','100 Main Street',‘Los Angeles','CA','90046','USA')
,('Pep E.Lapewo','100 Main Streeto',’Los Angeleso','CAo','90045','USA'); #和上面表达的意思是一样#
insert into customers(cust_id,cust_contact,cust_emails,cust_name,cust_address,cust_city,cust_state,cust_zip,cust_country)
select cust_id,cust_contact,cust_emails,cust_name,cust_address,cust_city,cust_state,cust_zip,cust_country from custnew;
#在custnew里面对应的这些列的数据导入到表customers中,注意这个语句没有了values(‘ ’) #
最新文章
- javascript 容易忽略的小知识点 new到底做了什么?
- 查看/关闭SElinux (原创帖,转载请注明出处)
- ERROR [IM002] [Microsoft][ODBC 驱动程序管理器] 未发现数据源名
- details和summary
- Oracle中";行转列";的实现方式
- val, lazy, def
- HTTPS 概述
- No.003:Longest Substring Without Repeating Characters
- SCCM2007
- 新的HTTP框架:Daraja Framework
- PHP生成压缩文件开发实例
- vijosP1567子串计数
- 暴力拆解CPU
- Map和Set
- mysql 开发进阶篇系列 19 MySQL Server(innodb_flush_log_at_trx_commit与sync_binlog)
- Druid Monitor开启登录界面
- scala sortBy and sortWith
- String例子
- 使用 Headless Chrome 进行页面渲染 - 知乎专栏
- mysql中or和in的效率问题