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, 1266🔥, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...