Constraints
Lesson 8Author : 🦒
Last Updated : December, 2017
Code
CREATE TABLE student (
student_id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(40) NOT NULL,
-- name VARCHAR(40) UNIQUE,
major VARCHAR(40) DEFAULT 'undecided',
);
CREATE TABLE student (
student_id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(40) NOT NULL,
-- name VARCHAR(40) UNIQUE,
major VARCHAR(40) DEFAULT 'undecided',
);