CREATE TABLE Students (stuid INTEGER not null, Stuname char (+) not null,sex int not null); CREATE TABLE Students (stuid INTEGER not NULL, Stuname char (+) not null,sex int not null,primary KEY ( STUID)); CREATE TABLE Students (stuid INTEGER not null PRIMARY key,stuname char (a) 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 T Ables;insert into students values (1, ' Zhang San ', 1); SELECT * from Students;insert to 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);
CREATE Table Common Commands