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, 4749👍, 0💬
Popular Posts:
Rachel opened her math book and found that the sum of the facing pages was 245. What pages did she o...
What is COCOMO I, COCOMOII and COCOMOIII? In CD we have a complete free PDF tutorial of how to prepa...
If we inherit a class do the private variables also get inherited ? Yes, the variables are inherited...
How To Enter Numeric Values as HEX Numbers? - MySQL FAQs - Introduction to SQL Basics If you want to...
What is shadowing ? When two elements in a program have same name, one of them can hide and shadow t...