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, 1968🔥, 0💬
Popular Posts:
What is the Azure AD v1.0 OpenID Metadata Document? Azure AD v1.0 OpenID Metadata Document is an onl...
How to use the urllib.request.Request object to build more complex HTTP request? The urllib.request....
How to add images to my EPUB books Images can be added into book content using the XHTML "img" eleme...
How to register and get an application ID from Azure AD? The first step to use Azure AD is to regist...
How to use the Atom Online Validator at w3.org? w3.org feed validation service is provided at http:/...