MySQL learning note--1. Basic operations

1. Command line use

F7 View History Commands

\c Exit execution

1064 syntax errors

1046 No Database selected

1366 characters in the data, but no character set

Tee D:/abc.sql to save the input commands into a SQL file

Set names encoding sets the character set (command line default encoding is GBK)

2. Introductory statement

Connect MySQL mysql-uroot-p***

View existing library show databases;

Create library name CharSet UTF8;

Delete the library drop database name;

Select library Use library name;

View tables in the library show tables;

Delete table name of the drop tables table;

Change table name rename table name to new table name;

View table structure desc table name;

@zhnoah
Source: http://www.cnblogs.com/zhnoah/
This article is owned by me and the blog Park, Welcome to reprint, but without the consent of the author must retain this paragraph, and in the article page obvious location to the original
The right to pursue legal liability.

MySQL learning note--1. Basic operations