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 DML Commands Are Supported by "mysql"
How Many SQL DML Commands Are Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql
✍: FYIcenter.com
There are 4 SQL Data Manipulation Language (DML) commands that are supported by "mysql". They are listed below with short descriptions:
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)
2007-05-10, 4495👍, 0💬
Popular Posts:
What will be printed as the result of the operation below: main() { int x=5; printf("%d,%d,%d\n",x,x. ..
Is XHTML Element Name Case Sensitive? - XHTML Tutorials - Introduction To Tag and Attribute Syntax Y...
Do events have return type ? No, events do not have return type.
How do I use a scriptlet to initialize a newly instantiated bean? A jsp:useBean action may optionall...
How can JavaScript make a Web site easier to use? That is, are there certain JavaScript techniques t...