Detailed introduction to command line mode

Database backup is completed in command line mode, using the MYSQLDUMP command. This command can be used to store data in the form of text files in the specified folder. Note: To operate the mysql database in command line mode, the computer's environment variables must be set. Right-click "My Computer", select the "Properties" command in the pop-up shortcut menu, select the "Advanced" tab in the pop-up "Properties" dialog box, and then click the "Environment Variables" button in the new pop-up dialog box. Find the variable PATH in the list box of user variables and select it, click the "Edit" button, add the installation path of the bin folder in the mysql database in the variable value text box of the variable PATH, and then add the "OK" button. The path of the bin folder depends on the location where you installed the mysql database. Note: If you use the integrated installation package to configure the PHP development environment, you do not need to perform the above settings because the integrated installation package has already been configured by itself. Complete. However, if mysql is installed independently, the above settings must be made to operate the mysql database in command line mode.

#How to use the recovery operation? Operation example usage

Introduction: Database backup is completed in the command line mode. Use is the MYSQLDUMP command. This command can store data in the form of a text file in the specified folder. Note: To operate the mysql database in command line mode, you must right-click "Me". computer, select the "Properties" command in the pop-up shortcut menu, select the "Advanced" tab in the pop-up "Properties" dialog box, then click the "Environment Variables" button in the new pop-up dialog box, and click on the "User Variables" button. Find the variable PATH in the list box and select it, stand-alone "...

2.

Recommended articles about MYSQL statement operations

Introduction: The database backup is completed in the command line mode, using the MYSQLDUMP command to convert the data into a text file. The form is stored in the specified folder. Note: To operate the mysql database in command line mode, you must set the computer's environment variables. Right-click "My Computer" and select the "Properties" command in the pop-up shortcut menu. Select the "Advanced" tab in the pop-up "Properties" dialog box, then click the "Environment Variables" button in the new pop-up dialog box, find the variable PATH in the list box of user variables and select it, "...

3.

MySQL backup and recovery operation (MYSQL statement operation tutorial 3)

Introduction: To complete the backup of data in command line mode, use the MYSQLDUMP command. This command can store the data in the form of a text file in the specified folder. To operate the mysql database in command line mode, you must set the computer's environment variables. Right-click "My Computer", select the "Properties" command in the pop-up shortcut menu, select the "Advanced" tab in the pop-up "Properties" dialog box, and then click the "Environment Variables" button in the new pop-up dialog box. Find the variable PATH in the list box of user variables and select it, click the "Edit" button, add the installation path of the bin folder in the mysql database in the variable value text box of the variable PATH, and then click the "OK" button

4.

Mysql common basic operation syntax (12)~~common numerical functions [command line mode]

Introduction: Numeric function is one of the commonly used functions, and it is also a must for learning mysql. The commonly used ones are as follows: 1. ceil: returns the smallest integer value greater than a certain number: 2. floor: and the previous one On the contrary, return the largest integer value less than a certain number: 3. Round: Return the rounded value of a certain value: As shown above, the second parameter of round represents the number of decimal places that need to be retained. 4. Truncate: Return to a value after a certain value is cut: Here is different from Round, no matter whether the decimal bit you need to keep it, one is all

# 5. MySQL commonly used basic operation grammar (11) ~~ String function [command line mode]

# : Note: SQL is relatively portable, but functions are not. They are generally unique to database software. For example, mysql has mysql functions, and oracle has oracle functions. 1. Concat connection string: From the figure above, it can be seen that directly using the Select Concat can connect to any two or more string, and can also be used to connect to the query results. Generally, it is also used to connect to query results. It should be noted that if the connected content exists null, the result will only be NULL. 2. Concat _

6. Mysql Common basic operation grammar (10) ~~ Zoom inquiry [command line mode]

# This profile: Although there is a connection query in query in mysql, the performance of the connection query is very poor, so there is a sub -query. 1. In theory, sub -query can appear in any position of the query statement, but mostly appears behind from and where. The subquery results that appear after from are usually multi-row and multi-column, acting as temporary tables; while the subquery results that appear after where are usually single rows and single columns, serving as conditions: 2. The subqueries that are used as conditions after where are mostly the same as "= ", "! =", ">", "in and not in: in means included in

##7.

Mysql common basic operation syntax (9)~~ Outer join query [command line mode]

##Introduction: 1. Left outer join left outer join or left jion, outer can be omitted, and the same is true for the right join and full join below: the left outer join means that the data in the table on the left of the left join is used as the basis, that is, all the data in the table on the left must be displayed. As shown below: In the first query here, the Company table is on the left, so it is based on the Company. Therefore, in addition to the 6 pieces of data with the same DEPART_ID, the other one also shows another one in Company.

##8. Mysql common basic operation syntax (8)~~Multiple table query merge results and inner join query [command line mode]

#Introduction: 1. Use union to merge two query results: select field name from tablename1 union select field name from tablename2; note that this operation must ensure both The fields in the two tables are the same, and the field data types are also the same. Note: The following connection queries involve the concept of Cartesian product, that is, if there are two tables, the number of records in the first table is n, and the number of records in the other table is n. For B, the number of records accumulated by Descartes is n*m bars; if the number of fields of the first table is A, the number of fields of the other is

This 9. mysql Common basic operation grammar (7)-Statistical function and group query [command line mode]

#Introduction: Note: All . . in the text represent multiple. 1. Use count to count the number of items: select count(field name...) from tablename; 2. Use avg to calculate the average value of the field. AVG (field name) from tableename; here can be appropriately expanded, such as adding conditions, renamed, etc. 3. Use SUM to summarize: Select SUM Minimum value: 5. Note

10. Mysql common basic operation syntax (6)--Conditional query for sorting data and limiting the number of results [command line mode]

Introduction: 1. Use order by to sort the query results, asc ascending order, desc descending order: You can also specify multiple field names and sorting methods after order by. Multi-level sorting: 2. Use limit to limit the number of query results: 0 in the above figure represents the starting position of the query, which can also be understood as the number to skip; 2 in the above figure represents the number to be queried. There are 3 pieces of data in this table. Because the number of pieces is limited to 2, the actual result is only two. In addition, the initial position here is 0. In fact, you don’t need to write it. The default is 0: There is another situation here, which is

[Related Q&A recommendations]:

javascript - How to pass parameters into the js script to be executed in command line mode

mysql - php query error Error while sending QUERY packet. PID=xxx

How to switch php running mode from fpm-fcgi to cli

php command line mode under linux

php - How to solve msyql statement link timeout?

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