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, 1493🔥, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...