Collections:
DDL Commands Supported in MySQL
How Many SQL DDL Commands Are Supported by "mysql" in MySQL?
✍: FYIcenter.com
There are 4 SQL Data Definition Language (DDL) commands that are supported by "mysql". They are listed below with short descriptions:
Here is a tutorial exercise of how to use DDL commands to create a database and a table:
>cd \mysql\bin >mysql -u root mysql> CREATE DATABASE fyi; Query OK, 1 row affected (0.50 sec) mysql> CREATE TABLE articles (name VARCHAR(80)); Query OK, 0 rows affected (0.25 sec) mysql> DROP DATABASE fyi; Query OK, 0 rows affected (0.41 sec)
⇒ DML Commands Supported in MySQL
⇐ "mysql" Command Line Arguments in MySQL
2018-04-21, 1422🔥, 0💬
Popular Posts:
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...