Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Create a New Table
How To Create a New Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts
✍: FYIcenter.com
If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script:
<?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR(1024)" . ", counts INTEGER" . ", time TIMESTAMP DEFAULT CURRENT_TIMESTAMP()" . ")"; if (mysql_query($sql, $con)) { print("Table fyi_links created.\n"); } else { print("Table creation failed with error:\n"); print(mysql_errno($con).": ".mysql_error($con)."\n"); } mysql_close($con); ?>
Remember that mysql_query() returns TRUE/FALSE on CREATE statements. If you run this script, you will get something like this:
Table fyi_links created.
2007-05-10, 4641👍, 0💬
Popular Posts:
What is Service Oriented architecture? “Services” are components which expose well defined interface...
What Happens If One Row Has Missing Columns? - XHTML 1.0 Tutorials - Understanding Tables and Table ...
How do we configure “WebGarden”? “Web garden” can be configured by using process model settings in...
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
Can you explain what is “AutoPostBack” feature in ASP.NET ? If we want the control to automatically ...