MySQl学习小记
1创建数据库: create database databasename2.打开数据库: 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;"> );
页:
[1]