CREATE TABLE Branch (
branchNo CHAR(4),
street VARCHAR(4) NOT NULL,
city VARCHAR(4) NOT NULL,
postcode VARCHAR(4) NOT NULL,
PRIMARY KEY (branchNo)
);
在插入数据的时候发现括号里面的长度应该是45!
语法格式:
alter table table_name modify colume_name varchar(128);
alter table Branch modify street VARCHAR(45) NOT NULL;
alter table Branch modify city VARCHAR(45) NOT NULL;
alter table Branch modify postcode VARCHAR(45) NOT NULL;