MySQL_script_MySQL

mysql脚本可以放在一个文件里（filename.sql）在mysql执行这个文件就OK
执行命令：/. 文件路径
create database mydata;
use mydata;
--mysql常用数据类型
int，double,char,varchar,datetime,longtext
创建表
use mydata;
create table dept
(
  deptno int primary key,
  dname varchar(14),
  loc varchar(13)
);
create table emp
(
  empno int primary key,
  ename varchar(10),
  job varchar(10),
  mgr int,
  hiredate datetime,
  sal double,
  comm double,
  deptno int,
  foreign key (deptno) references dept(deptno)
);
show databases;
show tables;
desc dept;
insert into dept values (10,'a','a');
insert into dept values (20,'b','b');
insert into dept values (30,'c','c');
insert into dept values (40,'d','d');
insert into dept values (50,'e','e');
commit;
--mysql 分页
select * from dept order by deptno desc limit     3,2;//从第三条往后数两条
--mysql 自增(auto_increment)
create table article
(
  id int primary key auto_increment,
  title varchar(255)
);
insert into article values (null,'a');
insert into article values (null,'b');
insert into article (title) values ('c');

--mysql 日期处理
select now();
select date_format(now(),'%y-%m-%d %h:%i:%s');
insert into emp values    (9999,'test','clerk',7369,'1981-12-23 12:23:23',8000,80,10);