11 lines
275 B
SQL
11 lines
275 B
SQL
CREATE TABLE Students
|
|
(
|
|
studentID INT AUTO_INCREMENT,
|
|
studentName VARCHAR(30) NOT NULL,
|
|
email VARCHAR(40),
|
|
gpa FLOAT DEFAULT 0.0,
|
|
PRIMARY KEY (studentID),
|
|
CONSTRAINT CHECK_GPA
|
|
CHECK (gpa BETWEEN 0 and 4.3)
|
|
);
|
|
ALTER TABLE Students ADD dateOfBirth DATETIME; |