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, 3522🔥, 0💬
Popular Posts:
What Happens to the Current Transaction If a DDL Statement Is Executed in Oracle? If a DDL statement...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Happens to the Current Transaction If a START TRANSACTION Is Executed in MySQL? If you are in a...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...