
        
        
            
                
                
                    CREATE TABLE drivers_license (
   student_id INT UNSIGNED AUTO_INCREMENT, 
   full_name VARCHAR(30),
   age INT,
   has_license BOOLEAN,
   PRIMARY KEY (student_id)
);

INSERT INTO drivers_license (full_name, age, has_license) VALUES ('Sky Towner', 17, FALSE);
INSERT INTO drivers_license (full_name, age, has_license) VALUES ('Ben Davis', 19, TRUE); 
INSERT INTO drivers_license (full_name, age, has_license) VALUES ('Travis Apple', 18, FALSE);
INSERT INTO drivers_license (full_name, age, has_license) VALUES ('Arthur David', 16, FALSE);
INSERT INTO drivers_license (full_name, age, has_license) VALUES ('Benjamin Town', 17, TRUE);

SELECT * FROM drivers_license;
                
            
            +------------+---------------+------+-------------+
| student_id | full_name     | age  | has_license |
+------------+---------------+------+-------------+
|          1 | Sky Towner    |   17 |           0 |
|          2 | Ben Davis     |   19 |           1 |
|          3 | Travis Apple  |   18 |           0 |
|          4 | Arthur David  |   16 |           0 |
|          5 | Benjamin Town |   17 |           1 |
+------------+---------------+------+-------------+

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!