Collections:
Inserting Rows with a SELECT Statement in MySQL
How To Insert Multiple Rows with a SELECT Statement in MySQL?
✍: 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 MySQL
⇐ Fixing INSERT Command Denied Error in MySQL
2017-09-20, 1302🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...