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();