MySQL quick query manual

 

MySQLQuick Reference Manual

 

Prepared by: Ocean:

 

Blog: http://oceanspace.tk

 

I don't need to introduce why MySQL is used. Since you will read this article, you already know it. Let's introduce the quick query manual.

 

When I was learning MySQL, I first found some information on the Internet, and then I borrowed a book to read it. I remember it when I read it. But in the later use process, I often encounter a situation where my head is short-circuited and I suddenly forget my usage. It is not very convenient to read books or Google at this time. It would be so convenient if I had a clear look at something like a table! As a result, this manual has been implemented. Haha ~ The original version of the manual was published on my Sina Weibo in the form of images. I sorted out an image every day, and then I made an electronic archive after finishing a lot of work, in the spirit of open-source sharing to other members of the association (at that time in Wuhan University of Technology open-source Technology Association http://vedaclub.org mixed, now postgraduate ing ). In the subsequent use process, I modified some errors and added some usage that I felt necessary to form the current manual. Due to limited time and technology, there may be errors in the manual, you are welcome to make changes (you can reply directly in the blog or send an email to the opensource.org.cn@gmail.com)

 

I,MySQLEnvironment Configuration

 

The following uses the configuration under ubuntu10.04 as an example:

 

1.InstallMysql

 

Sudo apt-Get install mysql-Server

 

(The installation process will allow you to enter the password of the root user in MySQL)

 

Is it so easy to use Linux? Haha!

 

2. MySQLCharacter Set settings

 

MySQL requires some character set settings to display Chinese characters properly:

 

Alter database name default character set 'utf8 ';

 

Alter database test charset = utf8;

 

You can use show variables like 'character % 'to view the Modified character Set settings.

 

II,Quick Reference Manual

 

(Please download the attachment and read it) mysqlquick Check manual

Or go http://blog.chinaunix.net/space.php? Uid = 26226106 & do = blog & id = 3132208, search for attachment download ~

 

Iii. References

 

"MySQL entry is very simple", edited by Huang luhua, Tsinghua University Press.

 

W3school: http://www.w3school.com.cn/ SQL /index.asp