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 a SELECT Statement
How To Insert Multiple Rows with a SELECT Statement? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts
✍: FYIcenter.com
If want to insert rows into a table based on data rows from other tables, you can use a sub-query inside the INSERT statement as shown in the following script example:
<?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_links" . " SELECT id+1000, url, notes, counts, time" . " FROM fyi_links"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
2 rows inserted.
2007-05-10, 6255👍, 0💬
Popular Posts:
How To Write a Query with a Right Outer Join? - Oracle DBA FAQ - Understanding SQL SELECT Query Stat...
If cookies are not enabled at browser end does form Authentication work? No, it does not work.
How will you freeze the requirement in this case? What will be your requirement satisfaction criteri...
What are the different storage classes in C? C has three types of storage: automatic, static and all...
WHat will be the result of the following code? #define TRUE 0 // some code while (TRUE) { // some co...