Sharing examples of mysql database preparation work

This article mainly shares with you examples of mysql database preparation work, including how to start/stop the mysql database service, log in/out of the mysql system, database backup and recovery, etc. I hope it can help you.

1. Start/stop mysql database service

Command line mode: (requires administrator identity)

• Start database ：net start mysql

• Close the database：net start mysql

Service Mode: Control Panel>Administrative Tools>Services>mysql>Start/Stop

2. Log in/quit mysql system

• Login: mysql -h server address -u login name [-P port number] -p

• Exit: quit; or exit; ——Refers to after logging in (entering) mysql.

Note: After logging in to the database system, you need to use "set names encoding name;" to set the "environment encoding name" of the current connection to the database, that is, the one currently dealing with the database. The encoding of the "client" itself. Generally speaking: the cmd client is a fixed gbk encoding, and the php web page is the encoding of the web page file (now the mainstream is utf8).

3. Database backup and recovery:

• Backup: It is to completely "convert" a database into a database that can be "carried and transmitted" at any time. document.

mysqldump -h server address -u login name -p database name> file name

• Restore: It means to completely restore a backed-up database file to a usable database.

mysql -h server address -u login name -p database name< file name

Note:

1. These two commands are used when "not logged in to mysql".

2. The mysqldump command also requires administrator status.

3. Usually, recovery refers to restoring all table data information and other information in the original database, and the database name can be the original name or a new name.

Basic grammar regulations

Comments:

1. Single-line comments: #Comment content

2. Single-line comments: – Comment content (note: there is a space after –)

3. Multi-line comments: /* Comment content*/

Statement line:

• By default, an English semicolon ; ends with a statement! Moreover, in regular operations, "one statement is executed at a time";

• #mysql, you can manually set the statement terminator. The method is as follows: delimiter New terminator , after this line, you can use the new terminator:

case problem;

1. mysql language itself does not Case-sensitive;

2. The execution of certain commands of mysql will generate files (folders), and they may be case-sensitive at this time:
   2.1: In the file (folder) name In case-sensitive systems, these names will also be case-sensitive, such as unix and linux systems;
   2.2: In systems where file (folder) names are not case-sensitive, they are also not case-sensitive, such as window systems .

Naming issue

• The name you can name yourself is called an identifier, including: database name, table name, field name, view name , function name, procedure name, variable name, user name, etc.

• There are more characters that can be used to name identifiers than in regular languages, but it is particularly recommended to use only alphanumeric characters and underscores, and not start with numbers.

• Although unconventional characters or system keywords can be used as identifiers, it is best to wrap them in backticks (the backticked ` on the left side of the number 1), and it is not recommended.

• Database names, table names, and view names are not case-sensitive in the window system, but are case-sensitive in other systems. It is recommended to use all lowercase letters and use underscore separation.

• For other self-named identifiers (field names, function names, procedure names), they are not case-sensitive, but it is recommended to use all lowercase letters and use underscore separation.

Related recommendations:

Details the data types of mysql database

The above is the detailed content of Sharing examples of mysql database preparation work. For more information, please follow other related articles on the PHP Chinese website!