
        
        
            
                
                
                    CREATE TABLE professors (
   professor_id INT UNSIGNED AUTO_INCREMENT, 
   fname VARCHAR(30),
   lname VARCHAR(30),
   day_hired DATE,
   age INT,
   username VARCHAR(15),
   PRIMARY KEY (professor_id)
);
INSERT INTO professors (fname, lname, day_hired, age, username) VALUES ('Tom', 'Willox', '2012-11-03', 47, 'twillox1');
INSERT INTO professors (fname, lname, day_hired, age, username) VALUES ('Ralph', 'Skeen', '2009-07-30', 39, 'rskeen2'); 
INSERT INTO professors (fname, lname, day_hired, age, username) VALUES ('Hyun', 'Lee', '2014-02-21', 32, 'hlee3');
INSERT INTO professors (fname, lname, day_hired, age, username) VALUES ('Bryce', 'Miller', '2004-10-01', 53, 'bmiller4');
SELECT * FROM professors;
                
            
            +--------------+-------+--------+------------+------+----------+
| professor_id | fname | lname  | day_hired  | age  | username |
+--------------+-------+--------+------------+------+----------+
|            1 | Tom   | Willox | 2012-11-03 |   47 | twillox1 |
|            2 | Ralph | Skeen  | 2009-07-30 |   39 | rskeen2  |
|            3 | Hyun  | Lee    | 2014-02-21 |   32 | hlee3    |
|            4 | Bryce | Miller | 2004-10-01 |   53 | bmiller4 |
+--------------+-------+--------+------------+------+----------+

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!