Collections:
PHP ODBC - Inserting Multiple Rows with a Subquery
PHP ODBC - How To Insert Multiple Rows with a subquery?
✍: Guest
If want to insert rows into a table based on data rows from other tables, you can use a subquery inside the INSERT statement as shown in the following script example:
<?php $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter'); $sql = "INSERT INTO fyi_links" . " SELECT id+1000, REVERSE(url), notes, counts, time" . " FROM fyi_links"; $res = odbc_exec($con, $sql); if (!$res) { print("SQL statement failed with error:\n"); print(odbc_error($con).": ".odbc_errormsg($con)."\n"); } else { print("Multiple rows inserted.\n"); } odbc_close($con);
If you run this script, the table should have 4 rows now. And you will get:
Multiple rows inserted
⇒ PHP ODBC - odbc_num_rows() - Number of Affected Rows
⇐ PHP ODBC - Inserting Data into an Existing Table
⇑ SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
2024-05-29, 1342🔥, 0💬
Popular Posts:
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...