Mysql之insert,update,delete
来源:互联网 发布:橡皮网组卷 源码 编辑:程序博客网 时间:2024/03/28 17:41
插入语句
a) Insert语句
Insert into <表名> (列名,。。。,列名)values(值1,。。。,值n);
Insert into shohinIns (shohin_id,shohin_mei,shohin_bunrui,banbai_tanka,shiire_tanka,torokubi) values (‘0001’,’T恤’,’衣服’,1000,500,’2009-09-20’);
多行insert
Insert into shohinIns values (‘0002’,’打孔器’,’办公用品’,500,320,’2009-09-11’),
(‘0003’,’运动T恤’,’衣服’,4000,2800,NULL);
b) 列清单的省略
对表进行全列insert时,可以省略表名后的列清单。
Insert into shohin values(‘0005’,’高压锅’,’厨房用具’,6800,5000,’2009-01-15’);
如何不设置列的值,系统会默认设为NULL;
c)从其他表中复制数据
Create table shohincopy
(shohin_id char(4) not NULL,
Shohin_mei varchar(100) not NULL,
Shohin_bunrui varchar(32) not NULL,
Hanbai_tanka integer,
Shiire_tanka integer,
Shiire_tanka date,
Torokubi date,
Primary key (shohin_id)
);
Insert into shohincopy (shohin_id,shohin_mei,shohin_bunrui,hanbai_tnaka,shiire_tanka,torokubi)
Select shohin_id,shohin_mei,shohin_bunrui,hanbai_tanka,shiire_tanka,torokubi from shohin;
d)插入其他表的和值
Insert into shohinbunrui(shohin_bunrui varchar(32) not NULL,
Sum_hanbai_tanka,sum_shiire_tanka) select shohin_bunrui,SUM(hanbai_tanka),SUM(shiire_tanka)from shohin group by shohin_bunrui;
4-2数据删除drop table 和delete语句
Delete + 表名;
Delete from shohin;//格式化
Delete from 表名 where 条件;
Delete from shohin where hanbai_tanka >= 4000;
4-3数据更新(update 语句的使用方法)
Update语法的基本语法
Update 表名 set 列名 = 表达式;
Update shohin set torokubi = ‘2009-10-10’;
----将数据日期全部更新为‘2009-10-10’//包括NULL的数据
---确认更新内容
Select * from shohin order by shohin_id;
--将某种商品的记录单价改为十倍
Update shohin set hanbai_tanka = hanbai_tanka * 10 where shohin_bunrui = ‘厨房用具’;
- Mysql之insert,update,delete
- mysql优化之insert/delete/update
- mysql学习-update, delete,insert
- MYSQL INSERT UPDATE DELETE 语句
- Mjybatis之update,delete,insert
- MySQL数据库之INSERT,REPLACE,UPDATE ,DELETE,TRUNCATE TABLE
- MySQL备忘之数据更新篇(INSERT, UPDATE, DELETE)
- mysql数据库insert、delete、update语句总结
- mysql-insert,update,delete,replace基础
- mysql学习4:select,update,insert,delete
- AngularJS Insert Update Delete Using PHP MySQL
- MySQL表操作 insert-delete-update-select
- mysql字符集,insert,update,delete,select
- mysql中 insert、update、delete锁
- MSSQL2005 INSERT ,UPDATE,DELETE 之OUTPUT子句
- 四、NHibernate之insert、delete、update操作
- MSSQL2005 INSERT ,UPDATE,DELETE 之OUTPUT子句
- mysql的insert/replace/update/delete & insert,update,delete多表操作
- sscanf函数和正则表达式
- 正则化方法/防止过拟合提高泛化能力的方法:L1和L2 regularization、数据集扩增、dropout
- jmeter实现cas单点登录
- Android手机蓝牙开发
- JVM内存分配
- Mysql之insert,update,delete
- POJ 2984 迷宫问题(搜索 路径的还原)
- 专题二 · 1005
- Mongodb创建用户
- 字符串最后一个单词的长度
- WEB-INF文件夹的位置和作用
- [FAQ13934]如何添加Static Library (静态库)到Share Library(共享库)
- HDU 1180 诡异的楼梯
- [!] Pods written in Swift can only be integrated as frameworks; add `use_frameworks!` to your Podfil