01

KEYWORDS:

• INSERT INTO <tablename> VALUES
• INSERT INTO student(student_id,name) VALUES(1,'Jack')
• CREATE TABLE student(
  student_id INT,
  name VARCHAR(20) NOT NULL,
  major VARCHAR(20) UNIQUE,
  PRIMARY KEY(student_id)
);
• CREATE TABLE student(
  student_id INT,
  name VARCHAR(20),
  major VARCHAR(20) DEFAULT 'undecided',
  PRIMARY KEY(student_id)
);
• CREATE TABLE student(
  student_id INT AUTO_INCREMENT ,
  name VARCHAR(20),
  major VARCHAR(20) ,
  PRIMARY KEY(student_id)
);