首页 >数据库 >mysql教程 >MySQL_script_MySQL

MySQL_script_MySQL

WBOY
WBOY原创
2016-06-01 13:12:101730浏览

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

声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn