Friends who need to learn can be downloaded via the Web: http://tadown.com/fs/8yi6be9nsehu9e921/
Content Profile ...
MySQL must know MySQL is one of the most popular database management systems in the world. Starting with the introduction of simple data retrieval, the book gradually delves into complex content, including the use of joins, subqueries, regular expressions, and full-text-based searches, stored procedures, cursors, triggers, table constraints, and so on. By focusing on the chapters, a clear, systematic and concise description of the knowledge that the reader should grasp, so that they inadvertently immediately increase the skill.
Reader's comments:
- Fei Lin Sha 2013-11-17
It is observed that most of the application developer database knowledge is not clear, but the database is almost all the site, including the biggest performance bottleneck of ERP, so this book is still very worthy of everyone to read. The book is very thin and has been read for one or two hours.
- _yuan_ 2011-11-07
Well, just figuring out the group, the connection, the Cartesian product of this thing ... Hard to mend their own weaknesses. It's really a book for getting started.
- Subusi 2012-11-04
Look at the first time only looked at the query, the second look is from beginning to end all read. My threshold is the installation, fortunately there was YY help, statements and logic are very simple things.
- North in the South 2013-06-01
More is the SQL syntax rules, entry-level reading.
Xu San Fat 2013-12-10 23:17:47 For MySQL beginners without any foundation to learn this year, when our company Bootcamp, the DBA recommended us three books: MySQL must know high-performance MySQL (3rd edition) MySQL Technology Insider (4th edition), as well as MySQL's official website. The great God said: "After reading these things, add some rich experience, you can go to the DBA." "There was not much concept of the database at the time, because there was no such thing as a" no ... Expand -4 Responses [logged out] 2010-05-01 15:48:36 Ideal for beginners A book that is very well cared for by beginners is not so much a book as a booklet, less than a 250-page booklet, a very practical, basically no theoretical stack, completely a hands-on guide that teaches you how to operate MySQL with SQL statements. Reading this book is basically a primer. The only drawback is that it's a little expensive.90 back to Knightliao 2011-06-19 15:52:43 Read this book, MySQL is a beginner before the Microsoft Internship, used SQL Server, and more familiar with the. But after all, different products use different ways, now make MySQL still encounter a lot of problems. To get a quick look at MySQL products, we chose this book. It took only 3 hours to finish the book, and then MySQL was a starter. Expand24 Response Statue Person 2011-04-13 02:55:01 It's just the beginning, it's all good to begin this is a book that lays the groundwork. Important surnames of the foundation are always easily overlooked. No, our silver is impetuous nature. But you are a coder, you are an ideal have the desire to program ape, so long solid step by step drop good learn it. Book thin often good digestion, if you can target, grasping big put small, learning people have the sense of accomplishment at the same time will not be erratic, on the reliable. "MySQL ... Expand
Author Profile ...
Ben Forta is a world-renowned technical writer and ad. One of the most well-known experts in the Be technology community, currently serving as an advanced technology extension specialist for Adobe. He has over more than 20 years of experience in the computer industry and has authored more than 10 technical books over the years, many of which are world bestsellers and have been translated into more than 10 languages. In addition to this book, he wrote the "Regular expression must know" will also be published by the People's post and telecommunications press. The reader can http://www through his personal website. Forta COM for more information.
Catalog ...The 1th chapter about SQL
1.1 Database Basics
1.1.1 What is a database
1.1.2 Table
1.1.3 Columns and data types
1.1.4 Line
1.1.5 PRIMARY Key
1.2 What is SQL
1.3 Hands-on practice
1.4 Summary
Chapter 2nd MySQL Introduction
2.1 What is MySQL
2.1.1 Client-Server Software
2.1.2 MySQL Version
2.2 MySQL Tool
2.2.1 MySQL command-line utility
2.2.2 MySQL Administrator
2.2.3 MySQL Query Browser
2.3 Summary
The 3rd chapter uses MySQL
3.1 Connections
3.2 Selecting a Database
3.3 Understanding databases and tables
3.4 Summary
Chapter 4th Retrieving data
4.1 SELECT statement
4.2 Retrieving a single column
4.3 Retrieving multiple columns
4.4 Retrieving all Columns
4.5 Retrieving different rows
4.6 Limiting results
4.7 Using a fully qualified table name
4.8 Summary
The 5th Chapter sort retrieves the data
5.1 Sorting Data
5.2 Sorting by multiple columns
5.3 Specifying the sort direction
5.4 Summary
6th Chapter Filter Data
6.1 Using the WHERE clause
6.2 WHERE clause operator
6.2.1 Checking a single value
6.2.2 mismatch Check
6.2.3 Range Value Check
6.2.4 Null value Check
6.3 Summary
Chapter 7th Data Filtering
7.1 Combining WHERE clauses
7.1.1 and operator
7.1.2 or operator
7.1.3 Calculation Order
7.2 in operator
7.3 Not operator
7.4 Summary
The 8th chapter is filtered with a wildcard character
8.1 Like operator
8.1.100 semicolon (%) wildcard character
8.1.2 underscore (_) wildcard character
8.2 Tips for using wildcard characters
8.3 Summary
The 9th chapter searches with regular expressions
9.1 Introduction to Regular expressions
9.2 using the MySQL regular expression
9.2.1 Basic character Matching
9.2.2 for or matching
9.2.3 matches one of several characters
9.2.4 Matching Range
9.2.5 Match Special characters
9.2.6 matching character class
9.2.7 Matching Multiple instances
9.2.8 Locator
9.3 Summary
10th. Creating a calculated field
10.1 Calculated Fields
10.2 Stitching Fields
10.3 Performing arithmetic calculations
10.4 Summary
The 11th chapter uses the data processing function
11.1 Functions
11.2 Using Functions
11.2.1 Text Processing functions
11.2.2 Date and time processing functions
11.2.3 Numeric processing function
11.3 Summary
12th Chapter Summary Data
12.1 Aggregation Functions
12.1.1 AVG () function
12.1.2 COUNT () function
12.1.3 MAX () function
12.1.4 MIN () function
12.1.5 SUM () function
12.2 Aggregating different values
12.3 Combined aggregation functions
12.4 Summary
Chapter 13th grouping Data
13.1 Data grouping
13.2 Creating groupings
13.3 Filtering grouping
13.4 Grouping and sorting
13.5 SELECT clause Order
13.6 Summary
The 14th chapter uses sub-query
14.1 Sub-query
14.2 Filtering with subqueries
14.3 using subqueries as calculated fields
14.4 Summary
15th Chapter Junction Table
15.1 coupling
15.1.1 Relationship Table
15.1.2 Why to use a junction
15.2 Creating a junction
15.2.1 importance of the WHERE clause
15.2.2 internal Coupling
15.2.3 joins multiple tables
15.3 Summary
16th. Creating an advanced junction
16.1 Using table Aliases
16.2 using different types of junctions
16.2.1 Self-coupling
16.2.2 Natural Coupling
16.2.3 External coupling
16.3 using a junction with aggregation functions
16.4 using junctions and junction conditions
16.5 Summary
17th Chapter Combination Query
17.1 Combination Query
17.2 Creating a combined query
17.2.1 using Union
17.2.2 Union rules
17.2.3 rows that contain or cancel duplicates
17.2.4 sorting the results of a combined query
17.3 Summary
The 18th Chapter Full Text Search
18.1 Understanding Full-Text Search
18.2 using full-text search
18.2.1 enable full-text search support
18.2.2 for full-text search
18.2.3 using Query extensions
18.2.4 Boolean Text Search
18.2.5 How to use full text search
18.3 Summary
Chapter 19th inserting data
19.1 Data Insertion
19.2 inserting the full line
19.3 inserting multiple rows
19.4 inserting the retrieved data
19.5 Summary
20th. Updating and deleting data
20.1 Updating data
20.2 Deleting data
20.3 guidelines for updates and deletions
20.4 Summary
21st chapter creation and manipulation of tables
21.1 Creating a Table
21.1.1 Table Creation Basics
21.1.2 using null values
21.1.3 primary Key re-introduction
21.1.4 using Auto_ INCREMENT
21.1.5 Specifying a default value
21.1.6 Engine Type
21.2 Update table
21.3 Deleting a table
21.4 Renaming a table
21.5 Summary
22nd. Using views
22.1 views
22.1.1 Why use views
Rules and restrictions for 22.1.2 views
22.2 Using views
22.2.1 using views to simplify complex joins
22.2.2 to reformat the retrieved data with a view
22.2.3 using views to filter unwanted data
22.2.4 using views and calculated fields
22.2.5 Update View
22.3 Summary
Chapter 23rd using Stored Procedures
23.1 Stored Procedures
23.2 Why to use stored procedures
23.3 Using Stored Procedures
23.3.1 Executing stored procedures
23.3.2 Creating a stored procedure
23.3.3 Deleting a stored procedure
23.3.4 Using Parameters
23.3.5 Building Intelligent Stored procedures
23.3.6 Checking stored Procedures
23.4 Summary
Chapter 24th using Cursors
24.1 Cursors
24.2 using Cursors
24.2.1 Creating Cursors
24.2.2 Opening and closing cursors
24.2.3 using cursor data
24.3 Summary
The 25th Chapter uses triggers
25.1 triggers
25.2 Creating a Trigger
25.3 Deleting a Trigger
25.4 using triggers
25.4.1 Insert Trigger
25.4.2 Delete Trigger
25.4.3 UPDATE Trigger
25.4.4 further introduction to triggers
25.5 Summary
Chapter 26th Management Affairs Processing
26.1 Transaction Processing
26.2 Control transaction Processing
26.2.1 using rollback
26.2.2 using Commit
26.2.3 using a retention point
26.2.4 changing the default commit behavior
26.3 Summary
Chapter 27th Globalization and Localization
27.1 Character set and collation order
27.2 using character sets and proofing order
27.3 Summary
28th Chapter Safety Management
28.1 access Control
28.2 Managing Users
28.2.1 Creating a user account
28.2.2 Delete user account
28.2.3 Setting access rights
28.2.4 changing passwords
28.3 Summary
29th. Database Maintenance
29.1 Backing up data
29.2 Database Maintenance
29.3 Troubleshooting startup issues
29.4 Viewing log files
29.5 Summary
30th. Improving performance
30.1 Improving performance
30.2 Summary
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
Index
· · · · · · (closed)
MySQL must know PDF full version
