MySQL must know the cloud

Book cover

Directory

The readers of this book are those who:

• He did not learn SQL;
• He had just begun to use MySQL and hoped to succeed in a swoop;
• He wants to learn to use MySQL quickly and as much as possible.
• He wants to learn how to use MySQL in his own application development;
• He hopes to improve productivity quickly and easily by using MySQL, without having to bother others to help.

Directory
The 1th chapter about SQL
Chapter 2nd MySQL Introduction
The 3rd chapter uses MySQL
Chapter 4th Retrieving data
The 5th Chapter sort retrieves the data
6th Chapter Filter Data
Chapter 7th Data Filtering
The 8th chapter is filtered with a wildcard character
The 9th chapter searches with regular expressions
10th. Creating a calculated field
The 11th chapter uses the data processing function
12th Chapter Summary Data
Chapter 13th grouping Data
The 14th chapter uses sub-query
15th Chapter Junction Table
16th. Creating an advanced junction
17th Chapter Combination Query
The 18th Chapter Full Text Search
Chapter 19th inserting data
20th. Updating and deleting data
21st chapter creation and manipulation of tables
22nd. Using views
Chapter 23rd using Stored Procedures
Chapter 24th using Cursors
The 25th Chapter uses triggers
Chapter 26th Management Affairs Processing
Chapter 27th Globalization and Localization
28th Chapter Safety Management
29th. Database Maintenance
30th. Improving performance
Appendix A getting started with MySQL
Appendix B Sample Table
Appendix C syntax for MySQL statements
Appendix D MySQL Data types
Appendix E mysql reserved word

Images

Code

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49

From collectionsImport Counter From ZhonImport Hanzi Import string Import re Import OS Import Matplotlib.pyplotAs Plt Import Jieba From WordcloudImport Wordcloud, Imagecolorgenerator With open (' MySQL must know. txt ',' R ', encoding=' Utf-8 ')As FP: Alltext =". Join (Fp.readlines ()) Alltext = Re.sub ("[%s]+"% hanzi.punctuation,"", Alltext) Alltext = Re.sub ("[%s]+"% string.punctuation,"", Alltext) Seg_list = Jieba.cut (Alltext, cut_all=False) Seg_list = List (seg_list) Counter = Counter (seg_list) top = Counter.most_common (1000) Top_dict = Dict (top) Stopwords_list = [] PWD = Os.path.abspath (‘.‘) For fileIn Os.listdir (Os.path.join (PWD,' Stopwords ')): filename = Os.path.join (pwd,' Stopwords ', file) with open (filename,' R ')As FP: Stopwords_list.extend (Fp.readlines ()) Stopwords_list = List (set (Stopwords_list)) For StopwordIn Stopwords_list: try: except: pass WC = Wordcloud (Background_color= #背景颜色max_ words=2000,# Word cloud Displays the maximum number of words Font_path= ' Simfang.ttf ', Max_font_size=50, Random_state=42) wc.generate_from_ Frequencies (top_dict) plt.imshow (WC) Plt.axis ( ' off ') plt.show ()

MySQL must know cloud image