Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How Many SQL DDL Commands Are Supported by "mysql"
How Many SQL DDL Commands Are Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface 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)
2007-05-08, 5318👍, 0💬
Popular Posts:
Why is it preferred to not use finalize for clean up? Problem with finalize is that garbage collecti...
When should the register modifier be used? Does it really help? The register modifier hints to the c...
What is a measure in OLAP ? Measures are the key performance indicator that you want to evaluate. To...
What is more advisable to create a thread, by implementing a Runnable interface or by extending Thre...
What exactly happens when ASPX page is requested from Browser? Note: - Here the interviewer is expec...