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, 1450🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...