Tools, FAQ, Tutorials:
Inserting Rows Based on SELECT Statement in PHP
How To Insert Rows Based on SELECT Statements in PHP?
✍: 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.
⇒ What Is a Result Set Object in PHP
⇐ Inserting Data into a Table in PHP
2016-10-20, 1834🔥, 0💬
Popular Posts:
How to read Atom validation errors at w3.org? If your Atom feed has errors, the Atom validator at w3...
How To Open Standard Output as a File Handle in PHP? If you want to open the standard output as a fi...
What is the "__init__()" class method? The "__init__()" class method is a special method that will b...
How To Convert a Character to an ASCII Value? If you want to convert characters to ASCII values, you...
How to add request query string Parameters to my Azure API operation 2017 version to make it more us...