MySQl学习小记

LinuxFans

1创建数据库:       create database databasename
2.打开数据库:       use databasename
3.创建表．
create table dept
 (
 deptno int primary key,
 dname varchar(14),
 loc varchar(13),
 d datetime
);
――――――――――
create table emp
 (
 enmpno int primary key,
 ename varchar(10),
 job varchar(10),
 mgr int,
 hirdate datetime,
 sal double,
 deptno int,
 foreign key(deptno) references dept(deptno)
<div style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; padding-bottom: 1pt; border-left: medium none; padding-top: 0cm;"> );