Common commands for create table and Common commands for table

Common commands for create table and Common commands for table

Create table students (stuID integer not null, stuname char (30) not null, sex int not null); create table students (stuID integer not null, stuname char (30) not null, sex int not null, primary key (stuID); create table students (stuID integer not null primary key, stuname char (30) not null, sex int not null ); create table score (scoreID integer not null primary key, stuID integer not null, kemuid integer not null, score FLOAT, foreign key SCORE_ID_FK (stuID) REFERENCES students (stuid ), CONSTRAINT CHK_SCORE_ZIP CHECK (SCORE> 0); show tables; insert into students values (1, 'zhang san', 1); SELECT * from students; insert into studentsselect * from students; delete students from studentswhere stuID = 1; drop table students; alter table students add constraint primary key (stuID); alter table students add primary key (stuID );