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.
2016-10-20, 1187👍, 0💬
Popular Posts:
Where to find tutorials on RSS specifications? I want to learn it to describe my API services. Here ...
How to use the "send-one-way-request" Policy statement to call an extra web service for an Azure API...
How to view API details on the Publisher Portal of an Azure API Management Service 2017 version? You...
How to access URL template parameters from "context.Request.Matched Parameters"object in Azure API P...
What's Wrong with "while ($c=fgetc($f)) {}" in PHP? If you are using "while ($c=fgetc($f)) {}" to lo...