Collections:
PHP MSSQL - Creating a New Table
PHP MSSQL - How To Create a New Table?
✍: Guest
If you want to create a table in the SQL Server database, you can run the CREATE TABLE SQL statement using the mssql_query() function, as shown in the following sample script:
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); # creating a new table $sql = "CREATE TABLE fyi_links (" . " id INT NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR(1024)" . ", counts INT" . ", time DATETIME" . ")"; $res = mssql_query($sql,$con); if (!$res) { print("Table creation failed with error:\n"); print(" ".mssql_get_last_message()."\n"); } else { print("Table fyi_links created.\n"); } mssql_close($con); ?>
If you run this script for the first time and there is no existing table called fyi_links in the database, you will get:
Table fyi_links created.
If you run it again, you will get:
Table creation failed with error: There is already an object named 'fyi_links' in the database.
⇒ PHP MSSQL - Dropping an Existing Table
⇐ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
⇑ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
2024-03-07, 1263🔥, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...