How Many SQL DML Commands Are Supported By "mysql"

How Many SQL DML Commands Are Supported By "mysql"


  • 11 Jan, 2012

    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 in>mysql -u root testmysql> CREATE TABLE links (id INTEGER, name VARCHAR(80));Query OK, 0 rows affected (0.10 sec)mysql> INSERT INTO links VALUES (1, 'www.GlobalGuideLine.com');Query OK, 1 row affected (0.02 sec)mysql> SELECT * FROM links;+------+-------------------------+| id | name |+------+-------------------------+| 1 | www.GlobalGuideLine.com |+------+-------------------------+1 row in set (0.04 sec)

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.