Summary of MySQL Basics primer
about the database:
database is a software developer to master the basic tools, the process of software operation is the process of manipulating data, the data in the database is nothing more than a few operations: increase-delete-check-change. after the MySQL installation is complete, you need to configure the variable environment, locate the configuration path, and then import the MySQL installation directory bin file. then run cmd into DOS.
Enter DOS after input: mysql-uroot-p password
MySQL Practical Practice:
You can then enter the operating environment of MySQL. For example: I executed one after logging in:Show Databases command to view all the libraries.
Create a table, and then view the data structure of the table:
Delete a field:
Add a field:
Add two data:
Data modification succeeded:
The data modification failed, but there was no error, and later it was found that it was null to execute and not =null
Change succeeded after change to IS null:
Modify Word Cheng:
I've added more than one piece of data, and the table is complete:
Query the id=1 table:
Enter id=1 table data by alias:
query If there is a teacher with job null:
for female teachers on a specified date:
Multi-Criteria query:
Query the ID at the end of the name for E:
query begins with the specified character:
query with Z in the name:
ID Flashback Arrangement:
multi-valued sorting:
Male and female groups:
total number of records queried:
Limit Paging query:
more Learning Resources and references:MySQL learning ppt with mysql5.5 version of the installation package
http://download.csdn.net/my/uploads
MySQL basic----> Basic commands with 13-way exercises