DML Commands Supported in MySQL

Q

How Many SQL DML Commands Are Supported by "mysql" in MySQL?

✍: FYIcenter.com

A

There are 4 SQL Data Manipulation Language (DML) commands that are supported by "mysql". They are listed below with short descriptions:

  • "INSERT INTO tableName ..." - Inserts new data rows into the specified table.
  • "DELETE FROM tableName ..." - Deletes existing data rows from the specified table.
  • "UPDATE tableName SET ..." - Updates existing data rows in the specified table.
  • "SELECT expressionList FROM ..." - Selects rows from tables and returns rows of values resulted from the specified expression list.

Here is a tutorial exercise of how to use DML commands to insert and select data rows:

>cd \mysql\bin
>mysql -u root test

mysql> CREATE TABLE links (id INTEGER, name VARCHAR(80));
Query OK, 0 rows affected (0.10 sec)

mysql> INSERT INTO links VALUES (1, 'dba.fyicenter.com');
Query OK, 1 row affected (0.02 sec)

mysql> SELECT * FROM links;
+------+-------------------+
| id   | name              |
+------+-------------------+
|    1 | dba.fyicenter.com |
+------+-------------------+
1 row in set (0.04 sec)

 

Command-Line End User Interface 'mysql'

⇒⇒MySQL Database Tutorials

2016-10-16, 177👍, 0💬