Detailed introduction to the basics of MySQL

Database is a basic tool that software developers must master. The process of running software is the process of operating data. The data in the database is nothing more than a few operations: add-deletion-check-modify.

1. After the Mysql installation is completed, you need to configure the variable environment, find the configuration path path, and then import the bin file in the mysql installation directory.

Then run cmd to enter dos.

After entering dos, enter: mysql -uroot -p password

2. Then you can enter the mysql operating environment. As shown below: After logging in, I executed a:

show databases command to view all libraries.

3. Create a table and then view the data structure of the table

4.Delete a field

5.Add a field

6. Add two pieces of data

7. Data modification successful

8. The data modification failed, but there was no error. Later, I found out that the function to determine whether it is empty is is null instead of =null

9. The modification was successful after changing to is null

10. The field was modified successfully

11. Multiple pieces of data have been added and the table is completed

12. Query the table with id=1

13. Enter the table data with id=1 through the alias

14. Query whether there are teachers whose job is null

15. Query the female teachers on the specified date

16. Multi-condition query

17. Query the id whose name ends with e

18. Query the

#19. Query the name starting with the specified character

with z in it

#20.id flashback arrangement

21.Multi-value sorting

22.Male and female grouping

######### ###23. Query the total number of records######

24.limit paging query

The above is the detailed content of Detailed introduction to the basics of MySQL. For more information, please follow other related articles on the PHP Chinese website!