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, 2211🔥, 0💬
Popular Posts:
How to run CMD Commands in Dockerfile to change Windows Docker images? When building a new Windows i...
How to use the "return-response" Policy statement to build the response from scratch for an Azure AP...
How to use the "forward-request" Policy Statement to call the backend service for an Azure API servi...
FYIcenter JSON Validator and Formatter is an online tool that checks for syntax errors of JSON text ...
How to install "C++/CLI Support" component in Visual Studio? I need to build my Visual Studio C++/CL...