-- 创建数据库(create database 数据库名;)
CREATE DATABASE fuxi;
-- 显示所有数据库
SHOW DATABASES;
-- 建立person表(create table 表名(....);)
CREATE TABLE person(
pid INT PRIMARY KEY,
pname VARCHAR(20),
page INT
);
-- 向person表插入两条数据(insert into 表名 values(....);)
INSERT INTO person VALUES(1,'zhangsan',18);
INSERT INTO person VALUES(2,'lisi',17);
-- 建立联合主键1:(constraint xxx primary key(...);)
CREATE TABLE person2(
pid INT,
pname VARCHAR(20),
page INT,
CONSTRAINT zhujian PRIMARY KEY(pid,pname)
);
-- 建立联合主键2:(alter table 表名 add constraint xxx primary key(...);)
CREATE TABLE person3(
pid INT,
pname VARCHAR(20),
page INT
);
ALTER TABLE person3 ADD CONSTRAINT zhujian PRIMARY KEY(pid,pname);
-- 删除主键(alter table 表名 drop primary key;)
ALTER TABLE person3 DROP PRIMARY KEY;
-- 设置