MySQL Basic operation

• Database operations

Create a database

Create Database character Set UTF8

Deleting a database

Drop  Database name

• Table Operations

CREATE TABLE: (Auto_increment, unique unique)

--Create a new table Create TableT_user (IDbigint Primary Keyauto_increment, usernamevarchar( -)Unique, namevarchar( -), Passwordvarchar( -), Sexvarchar(1) );--Create a new table based on an existing tableCreate TableTab_new likeTab_old

Table itself operation

-- Table Renaming Alter Table Table name rename new table name -- Delete a table Drop  Table Name

Other operations of the table

--Add primary KeyAlter TableTabNameAdd Primary Key(COL)--Delete primary KeyAlter TableTabNameDrop Primary Key(COL)--Create an indexCreate [Unique] IndexIdxname ontabname (col ....)--Delete IndexDrop IndexIdxname--Create a ViewCreate ViewViewName as SelectStatement--Delete a viewDrop ViewViewName

Table Chizang, Delete, change

--AddAlter TableTable1AddIdint  not NullAuto_incrementPrimary Key--Modify a field typeAlter TableTable name Modify field Name field type[whether to allow non-empty];--Modify a field type to be attached to a field nameAlter TableTable name change field original Name field new Name field type[whether to allow non-empty]--Delete a fieldAlter TableMyTableDropField name

• Data manipulation

1. Inserting data

Insert  into Values );

MySQL Basic operation