Home >Database >Mysql Tutorial >MySQL_script_MySQL

MySQL_script_MySQL

WBOY
WBOYOriginal
2016-06-01 13:12:101736browse

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn