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 To Insert Multiple Rows with One INSERT Statement
How To Insert Multiple Rows with One INSERT Statement? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements
✍: FYIcenter.com
If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The following tutorial exercise gives a good example:
mysql> INSERT INTO fyi_links SELECT id+500, REVERSE(url), notes, counts, created FROM fyi_links; Query OK, 5 rows affected (0.01 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> SELECT id, url, notes, counts, DATE(created) FROM fyi_links; +-----+-------------------+-------+--------+---------------+ | id | url | notes | counts | DATE(created) | +-----+-------------------+-------+--------+---------------+ | 101 | dev.fyicenter.com | NULL | 0 | 2006-04-30 | | 102 | dba.fyicenter.com | NULL | 0 | 2006-08-31 | | 103 | sqa.fyicenter.com | NULL | NULL | 2006-08-31 | | 110 | | NULL | NULL | 2006-08-31 | | 0 | www.fyicenter.com | NULL | NULL | 2006-08-31 | | 601 | moc.retneciyf.ved | NULL | 0 | 2006-04-30 | | 602 | moc.retneciyf.abd | NULL | 0 | 2006-08-31 | | 603 | moc.retneciyf.aqs | NULL | NULL | 2006-08-31 | | 610 | | NULL | NULL | 2006-08-31 | | 500 | moc.retneciyf.www | NULL | NULL | 2006-08-31 | +-----+-------------------+-------+--------+---------------+ 10 rows in set (0.00 sec)
2007-05-11, 4811👍, 0💬
Popular Posts:
How can a servlet refresh automatically if some new data has entered the database? You can use a cli...
An application needs to load a library before it starts to run, how to code? One option is to use a ...
What Is C Language? The C programming language is a standardized programming language developed in t...
How can we know the number of days between two given dates in PHP? Simple arithmetic: <?php $...
What are the two kinds of comments in JSP and what's the difference between them? <%-- JSP Co...