
        
        
            
                
                
                    CREATE TABLE students (
student_id INT UNSIGNED AUTO_INCREMENT, 
fname VARCHAR(30),
lname VARCHAR(30),
day_enrolled DATE,
age INT,
username VARCHAR(15),
PRIMARY KEY (student_id)
);

INSERT INTO students (fname, lname, day_enrolled, age, username) VALUES ('Sky', 'Towner', '2015-12-03', 17, 'stowner1');
INSERT INTO students (fname, lname, day_enrolled, age, username) VALUES ('Ben', 'Davis', '2016-04-20', 19, 'bdavis2'); 
INSERT INTO students (fname, lname, day_enrolled, age, username) VALUES ('Travis', 'Apple', '2018-08-14', 18, 'tapple3');
INSERT INTO students (fname, lname, day_enrolled, age, username) VALUES ('Arthur', 'David', '2016-04-01', 16, 'adavid4');
INSERT INTO students (fname, lname, day_enrolled, age, username) VALUES ('Benjamin', 'Town', '2014-01-01', 17, 'btown5');

SELECT * FROM students;
                
            
            +------------+----------+--------+--------------+------+----------+
| student_id | fname    | lname  | day_enrolled | age  | username |
+------------+----------+--------+--------------+------+----------+
|          1 | Sky      | Towner | 2015-12-03   |   17 | stowner1 |
|          2 | Ben      | Davis  | 2016-04-20   |   19 | bdavis2  |
|          3 | Travis   | Apple  | 2018-08-14   |   18 | tapple3  |
|          4 | Arthur   | David  | 2016-04-01   |   16 | adavid4  |
|          5 | Benjamin | Town   | 2014-01-01   |   17 | btown5   |
+------------+----------+--------+--------------+------+----------+

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!