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

Xiaobian to share with you what mysql ddl refers to, I hope you read this article after the harvest, let us discuss it together!

mysql ddl is the abbreviation of data set language, simply put, it is the language for creating, deleting, modifying, etc. objects inside the database;DDL statements are more used by database administrators, and developers generally rarely use them.

DDL statements

DDL is the abbreviation of Data Definition Language. Simply speaking, it is the language for creating, deleting, modifying and other operations on objects inside the database. The biggest difference between DML and DML is that DML only operates on the internal data of the table, and does not involve the definition of the table, the modification of the structure, and does not involve other objects. DDL statements are used more by database administrators (DBAs) and less by developers.

Here are some examples of how MySQL uses common DDL statements.

1: Creating a database

After starting the MySQL service, connect to the MySQL server by entering the following command:

mysql -uroot -p

The following interface will appear:

In the above command line, mysql stands for the client command,"-u" followed by the connected database user, and "-p" stands for the password to be entered.

If the database is set up correctly and you enter the correct password, you will see the welcome screen above and a "mysql>" prompt. A few parts are explained in the welcome interface.

. The terminator of a command, ending with ";" or "\g."

. The connection ID of the client, which records the number of MySQL connections to date; each new connection is automatically incremented by 1.

The MySQL server version, in this case 5.5.25.

. Use "help" or "\h" command to display help content, use "\c" command to clear command line buffer.

Because all databases are stored in databases, the first command you need to learn is to create a database.

The syntax for creating a database is as follows:

CREATE DATABASE dbname;

After reading this article, I believe you have a certain understanding of what mysql ddl means. If you want to know more about it, welcome to pay attention to the industry information channel. Thank you for reading!

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.