Shulou(Shulou.com)06/01 Report--

The main purpose of this article is to tell you briefly about the statement specifications and command line operation methods of database MySQL. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article on the statement specifications and command line operation methods of database MySQL can bring you some practical help.

Specification of MySQL statement

1. Keywords and function names are all capitalized

2. Database name, table name and field name are all lowercase

3. The SQL statement must end with a semicolon

Operating database with command line in cmd

First, open MySQL-u for account-p for password-prompt\ h means to change the prompt to localhost

Change the prompt to more detailed information

Create a database, view the version and view the existing database tables

Create a database named T2 and set the encoding format to gbk. If you want to modify the encoding of the database later, you do not need to delete and rebuild it, you only need to modify the encoding format, which is also shown in the following figure.

Delete the T1 database and view the existing database to confirm that T1 has been deleted

Database MySQL statement specification and each command line operation methods will first tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.