0HsYa1fy

1--CREATE database
2CREATE DATABASE demo;
3SHOW DATABASES;
4USE demo;
5
6--CREATE table
7SHOW TABLES;
8
9CREATE TABLE users (
10  id INT AUTO_INCREMENT NOT NULL,
11  name VARCHAR(255) NOT NULL,
12  password VARCHAR(255) NOT NULL,
13  PRIMARY KEY(id)
14);
15
16--CREATE/INSERT data
17INSERT INTO users (name, password) VALUES ('Mg Mg', MD5/SHA1('12345678'));
18
19--READ
20SELECT * FROM users;
21SELECT name FROM users WHERE password = '12345678';
22
23--UPDATE
24UPDATE users SET name = 'Ma Ma';
25
26--DELETE/DESTROY data/rows
27DELETE FROM users WHERE name = 'Ma Ma';
28DELETE FROM users; --Does not reset auto-increment ID (unless explicitly done)
29TRUNCATE TABLE users; --Resets auto-increment counter to 1 (in most databases)
30
31--DELETE/DESTROY table
32DROP TABLE users;
33
34--DELETE/DESTROY database
35DROP DATABASE demo;