Collections:
PHP MSSQL - Making Columns to Take NULL
PHP MSSQL - How To Make a Column Nullable?
✍: Guest
Based on the testing result from the previous tutorial you can find out that there is a big difference in the column definition when running CREATE TABLE statement with mssql_query():
Now you have to modify the CREATE TABLE statement to create "fyi_links" again by adding NULL to columns: notes, counts, and time:
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); # dropping an existing table $sql = "DROP TABLE fyi_links"; $res = mssql_query($sql,$con); print("Table fyi_links dropped.\n"); # creating a new table $sql = "CREATE TABLE fyi_links (" . " id INT NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR(1024) NULL" . ", counts INT NULL" . ", time DATETIME NULL" . ")"; $res = mssql_query($sql,$con); print("Table fyi_links created.\n"); mssql_close($con); ?>
If you run this script, "fyi_links" will be dropped and created again with correct column definitions:
Table fyi_links dropped. Table fyi_links created.
⇒ PHP MSSQL - Inserting Data with NULL Values
⇐ PHP MSSQL - Inserting Data into an Existing Table
⇑ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
2024-03-07, 1304🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...