Common Operations of MySql statements-create a database, select a database, create a table, and garbled Chinese characters in the database;

Create a database

Create database database_name;

Create Database database_name

Select Database

USE database_name;

Select database database_name

Delete Database

Drop database database_name;

Delete database database_name

Create a table

Create table table_name (

ID varchar (4) not null,

NAME varchar (50) NOT NULL

);

Create Table table_name create two field ID names in the table

Fix Chinese garbled characters in Databases

I can set the database encoding.

Set names gb2312;

Insert fields in the table

Alter table 'table _ name' ADD 'wcj 'VARCHAR (30) not null;

Insert a wcj field in table_name