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, 1281🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...