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