Create Database
CREATE database example;
Delete Database
DROP database example;
Select Database
USE example;
View Database list
SHOW databases;
Create Table
CREATE TABLE test (
id int(11) not null auto_increment,
name varchar(10) not null,
email varchar(30),
primary key(id),
index name_index(name(10))
)
View Table list
SHOW tables;
Delete Table
DROP table test;
Check Table Column Information
show columns from 'table name';
show full columns 'table name';
Insert Record
INSERT INTO test (name, email) VALUES("Lee", "seed@gmail.com");
Delete Record
DELETE FROM test WHERE id = 0;
DELETE FROM test # Delete all data in the table
Modify Reocrd
UPDATE test SET email='example@gmail.com' WHERE name='Lee';
Select specific record
SELECT name,email FROM test WHERE name='Lee';