How To Insert Multiple Rows with a SELECT Statement

Q

How To Insert Multiple Rows with a SELECT Statement? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts

✍: FYIcenter.com

A

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.

2007-05-10, 6255👍, 0💬

How To Break Output into Pages
How To Break Output into Pages? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you have a query that returns hundreds of rows, and you don't want to present all of them to your users on a single page. You can break output into multiple pages, and only present 10 rows per page... 2007-05-10, 5644👍, 0💬

How To Update Existing Rows in a Table
How To Update Existing Rows in a Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: <?php in... 2007-05-11, 5495👍, 0💬

How To Query Tables and Loop through the Returning Rows
How To Query Tables and Loop through the Returning Rows? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts The best way to query tables and loop through the returning rows is to run the SELECT statement with the mysql_query() function, catch the returning object as a result set, an... 2007-05-11, 5291👍, 0💬

How To Delete Existing Rows in a Table
How To Delete Existing Rows in a Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: <?php include "mysql_con... 2007-05-11, 5149👍, 0💬

How To Get the Number of Rows Selected or Affected by a SQL Statement
How To Get the Number of Rows Selected or Affected by a SQL Statement? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts There are two functions you can use the get the number of rows selected or affected by a SQL statement: mysql_num_rows($res) - Returns the number of rows selecte... 2007-05-10, 4951👍, 0💬

How To Fix the INSERT Command Denied Error
How To Fix the INSERT Command Denied Error? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts The reason for getting the "1142: INSERT command denied" error is that your user accound does not have the INSERT privilege on the table or database. To resolve this error, you need to ask... 2007-05-10, 4888👍, 0💬

What Is a Result Set Object
What Is a Result Set Object? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in t... 2007-05-10, 4804👍, 0💬

How To Insert Data into an Existing Table
How To Insert Data into an Existing Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: <?php include "mysql_connection.php"; $sql ... 2007-05-10, 4703👍, 0💬

How To Run a SQL Statement
How To Run a SQL Statement? - MySQL FAQs - PHP Connections and Query Execution You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status: Returning FA... 2007-05-10, 4585👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.