MySQL statement

1. create database

CREATE DATABASE IF NOT EXISTS MYDATAS;

2. use database

USE MYDATABASE;

3. create table

CREATE TABLE IF NOT EXISTS Admins
(
aid     INT PRIMARY KEY AUTO_INCREMENT,
aname   varchar(128) UNIQUE KEY NOT NULL,
passwd   varchar(16) NOT NULL,
mail   varchar(64) NOT NULL
) DEFAULT CHARSET=utf8;

4. rename table

ALTER TABLE suppliers RENAME TO vendors;

5. add column to table

ALTER TABLE supplier ADD supplier_name    varchar2(50);

6. add index to column

ALTER TABLE table_name ADD INDEX (column_name);

7. ALTER 

alert is used to modify or add the table, such as the column name, table name, and index. (see 5, 6)

8. insert

INSERT INTO table_name (col1, col2) VALUES (col1_value, col2_value);

9. select

SELECT *
FROM table_name;

SELECT table1_col1, table2_col2
FROM table1_name, table2_name;

SELECT T1.col1, T2.col1
FROM table1_name AS T1, table2_name AS T2
WHERE T1.col1=T2.col2;

SELECT col1, col2
FROM table1_name AS T1, (SELECT * FROM table2_name AS T2 WHERE T2.col1 > 5 and T2.col1 * 2 = T2.col2) AS T3
WHERE T1.col1, T3.col2;