Mysql
- [ERROR] Native table ‘performance_schema’.’table name’ has the wrong structure
- 为Linux MySQL数据库设置磁盘限额
- mysql 성능테스트 mysqlslap
- Mysql用户与权限管理
- SQL百万级数据库优化方案
- 远程链接MySQL数据库速度很慢
- limit 百万级数据分页优化方法
- Mysql-bind + bind9.5.0rc1
- 备份数据库 并 上传到指定FTP服务器上
- MYSQL同步 Slave_IO_Running: No 或者Slave_SQL_Running: No 解决办法
- mysql-mmm安装无错版
- 关于MySQL 服务器优化技巧手册
- mysql의 쵀대연결수 수정
- mysql+mmm+proxy实现数据库读写分离及高可用HA
- 使用spotlight来监控mysql性能
- mysql缓存参数
- mysqld程序--目录和文件
- 实例优化mysql配置文件my.cnf
- 提高mysql性能的方法
- mysql 컴파일
- 예제
- Mysql Server
- 修改mysql root密码
- 数据库的自动备份与数据库被破坏后的恢复
- DB자동저장 스크립트
- MySql 使用条件语句
- Mysql 性能检测小知识
- 通过分区（Partition）提升MySQL性能
- add Mysql user
- 1
예제
create table orderInfo (
tempId char(6) not null,
orderNum char(6) not null,
id char(30) not null,
goodsDelivery enum('X','Y','N','D','R','C'),
primary key(orderNum)
);
insert into goods (goodsCode,goodsName,goodsPrice,goodsProduction,goodsQuantity) values ('00001','noteBook','1200000','human','20'),
('00002','mp3','100000','samsong','10'),('00003','xbox','1500000','ms','15');
create table members (
uid int(10) not null auto_increment,
id char(30) not null,
name char(30) not null,
addr varchar(100) not null,
email varchar(100) not null,
phone char(15) null,
milage int(8) not null,
primary key(uid)
);
insert into members (id,name,addr,email,phone,milage) values ('apple','kim','seoul','test@daum.net','011-8988-9999','1000'),
('pineapple','lee','suwon','lee@empal.com','010-5036-9994','1000'),('cherry','jo','new york','cherry@aol.com','011-9874-1900','500');
select goods.goodsName from goods,basket,orderInfo
where orderInfo.orderNum='or0001' and
basket.orderNum=orderInfo.orderNum and
basket.goodsCode=goods.goodsCode;
insert into orderInfo (tempId,orderNum,id,goodsDelivery) values ('asas10','or0002','apple','N');
update basket set orderNum='or0002',goodsDelivery='N' where tempId='asas10' and orderNum='X' and goodsDelivery='X';
select goods.goodsName,goods.goodsPrice,basket.goodsAmount,goods.goodsPrice*basket.goodsAmount
-> from goods,basket,orderInfo
-> where orderInfo.orderNum='or0002' and
-> basket.orderNum=orderInfo.orderNum and
-> basket.goodsCode=goods.goodsCode;
select a.goodsCode as gc,a.goodsName as gn,a.goodsPrice as gp,
b.goodsAmount as ga,a.goodsPrice*b.goodsAmount as tp
from goods as a ,basket as b,orderInfo as c
where c.goodsDelivery='N' and b.orderNum=c.orderNum and b.goodsCode=a.goodsCode;
insert into member (id,name) values ('apple','kim');
select id,name from members where id='apple';
select * from members where id='apple';
update members set name='yoon' where id='apple';
update members set id='per',name='park' where id='apple;
delete from members where id='per';