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, 4701👍, 0💬
Popular Posts:
How to create a thread in a program? You have two ways to do so. First, making your class "extends" ...
How does one iterate through items and records in a specified block? One can use NEXT_FIELD to itera...
How To Use "IN OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and F...
I have 5 questions please give me the answer ,explanation,suggestions if any?? what is PMP(project m...
What is the purpose of finalization? The purpose of finalization is to give an unreachable object th...