Created
April 1, 2021 10:25
-
-
Save bradsi/52a7cf4d08957c02204000f96ddb99b1 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- create db called users | |
| CREATE DATABASE my_app; | |
| -- delete db | |
| DROP DATABASE my_app; | |
| -- use db | |
| USE my_app; | |
| -- create table | |
| CREATE TABLE users ( | |
| id INT NOT NULL AUTO_INCREMENT, | |
| first_name VARCHAR(255) NOT NULL, | |
| last_name VARCHAR(255) NOT NULL, | |
| PRIMARY KEY (id) | |
| ); | |
| -- alter table | |
| ALTER TABLE users | |
| ADD email VARCHAR(255) NOT NULL; | |
| -- drop table | |
| DROP TABLE users; | |
| -- create table with foreign key | |
| CREATE TABLE posts ( | |
| id INT NOT NULL AUTO_INCREMENT, | |
| text VARCHAR(140) NOT NULL, | |
| user_id INT NOT NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY (user_id) REFERENCES users(id) | |
| ); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment