mysql语句的创建过程
1–create database mydata7;
ok
use mydata7;
successful
2–create table dept
(
deptno int primary key,
dname varchar(13),
loc varchar(10)
);
successful;
3–create table emp
(
empno int primary key,
ename varchar(14),
ename varchar(2),
job varchar(10),
comm double，
sal double,
deptno int,
foreign key(deptno) references dept(deptno)
);
ok
查看mysql下有那些表用–show databases/show tables;
查看表结构 desc emp
插入数据和oracle一样 insert into dept values(1,’liuwenwne’,’2′);
3–mysql分页
select * from dept order by deptno desc limit 3,2;(从第三条开始往后数2条)。
4–mysql自动递增、
create table article
(
id int primary key auto_increment,
titile varchar(10),
);
insert into article values(null,’a’);
ok
insert into article (title) values(‘c’);
id title
1 a
2 c(注意这里自动添加一个数字2)。这就是mysql的自动递增
mysql日期 select now();
转载请注明原文链接：Mysql话语的创建过程
