数据库0511

列一级约束定义

字段名 数据类型 PRIMARU KEY

表一级约束定义

create tables table_name

(column....,

constraint primary key(column_name))

实践

第一步创建数据表使用列一级约束完成primary key

use onlinedb;

drop table newuser;

create table newuser(uid varchar(20) primary key, uname varchar(20);

第二步插入数据

insert into newuser values(10,'王一'）;

insert into newuser values(10,'王一'）;

insert into newuser (uname) values(10,'王一'）;

查看表中数据

select * from newuser;

例如创建购物车信息表SCarInfo

CREATE TABLE SCarInfo

(gdID INT,

uID INT,

scNum INT,

PRIMARY KEY(gdID,uID));

desc SCarInfo;