Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --CREATE database
- SHOW DATABASES;
- CREATE DATABASE demo;
- USE demo;
- --CREATE table
- SHOW TABLES;
- CREATE TABLE users (
- id INT AUTO_INCREMENT NOT NULL,
- name VARCHAR(255) NOT NULL,
- password VARCHAR(255) NOT NULL,
- PRIMARY KEY(id)
- );
- --CREATE/INSERT data
- INSERT INTO users (name, password) VALUES ('Mg Mg', MD5/SHA1('12345678'));
- --READ
- SELECT * FROM users;
- SELECT name FROM users;
- SELECT name FROM users WHERE id = 1;
- SELECT name, password FROM users WHERE id = 1;
- --UPDATE
- UPDATE users SET name = 'Ma Ma' WHERE id = 1;
- UPDATE users SET name = 'Ma Ma', password = '87654321' WHERE id = 1;
- --DELETE/DESTROY data/rows
- DELETE FROM users WHERE id = 1;
- DELETE FROM users; --Does not reset auto-increment ID (unless explicitly done)
- TRUNCATE TABLE users; --Resets auto-increment counter to 1 (in most databases)
- --DELETE/DESTROY table
- DROP TABLE users;
- --DELETE/DESTROY database
- DROP DATABASE demo;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
