MySQL Simple operation

Database: As the name implies is a storage data warehouse, according to the structure of the data to organize the storage and management of data.

Create a database

Create Databese [if not exists]db_name DEFAULT CHARACTER SET charset_name;

Create DATABASE [if not present] database library name character Set character set name

Cases:

Create a database with the name Wo

　　

If the database wo does not exist then create a database named Wo

　　

Creates a database and specifies the character set used by the CREATE database if not exists TA DEFAULT CHARACTER set UTF8;

　　

View current databases Select database ();

　　　

View current server all databases show databases;

　　

to view specific information about a database that has been created show Create Database ni;

　　

Switch database use db_name;

　　

Modify database Alter DB ni CHARACTER SET = UTF8;

　　

Delete database drop databases db_name;

　　

Data sheet: One of the parts of the database

Creating a data table Create tables table_name ();

　　

View Table

Querying the table data table of the current database show tables;

　　

View tables in a specified library show tables from NI;

　　

View data sheet structure show columns from table_name;

　　

Insert Tab1 values (' Tom ', 25,9876.54);

　　

View all contents of a table select * from TAB1;

Write this for the first time, don't mind if you write it well

　　

MySQL Simple operation