matthewblewitt/sql-cheatsheet.md

Last active September 6, 2018 10:12

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/matthewblewitt/1866e0c1b93518b934a82972309aa9c5.js"></script>
Save matthewblewitt/1866e0c1b93518b934a82972309aa9c5 to your computer and use it in GitHub Desktop.

SQL-cheatsheet

Raw

CREATE DATABASE app;
USE app;

CREATE TABLE users (
    id int,
    last_name varchar(255),
    first_name varchar(255)
);

INSERT INTO users ( first_name ) VALUES ( 'Matt' );
INSERT INTO users VALUES ( null, 'Matt', 'Blewitt' );

DROP TABLE users;

SELECT * FROM users;


exit;