Collections:
PHP MSSQL - Inserting Multiple Rows with a Subquery
PHP MSSQL - 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 = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); $sql = "INSERT INTO fyi_links" . " SELECT id+1000, REVERSE(url), notes, counts, time" . " FROM fyi_links"; $res = mssql_query($sql,$con); if (!$res) { print("SQL statement failed with error:\n"); print(" ".mssql_get_last_message()."\n"); } else { print("Multiple rows inserted.\n"); } mssql_close($con);
If you run this script, the table should have 4 rows now. And you will get:
Multiple rows inserted
⇒ PHP MSSQL - mssql_rows_affected() - Number of Affected Rows
⇐ PHP MSSQL - Inserting Data with NULL Values
⇑ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
2024-02-28, 1252🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...