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, 1237🔥, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...