mysql
#创建
drop database if exists dbbeginning;
create database dbbeginning;
#当前的
use dbbeginning;
create table languages(
lid int primary key auto_increment,#自动增长不能为null: primary key,唯一索引:auto_increment
lname varchar(20)
);
create table content(
cid int primary key auto_increment,
cname varchar(20),
clid int,
foreign key(clid) references languages(lid)
);
insert into languages(lid,lname) values(0,'java');
insert into languages(lid,lname) values(0,'php');
insert into languages(lid,lname) values(0,'C#');
insert into languages(lid,lname) values(0,'c++');
insert into content(cid,cname,clid) values(0,'Application',1);
insert into content(cid,cname,clid) values(0,'applet',1);
insert into content(cid,cname,clid) values(0,'servlet',1);
insert into content(cid,cname,clid) values(0,'php怎么样?',2);
insert into content(cid,cname,clid) values(0,'p