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 - Understanding SQL CREATE, ALTER and DROP Statements
✍: FYIcenter.com
If you want to create a new table, you can use the "CREATE TABLE" statement. The following tutorial script shows you how to create a table called "tip":
mysql> CREATE TABLE tip (id INTEGER PRIMARY KEY, subject VARCHAR(80) NOT NULL, description VARCHAR(256) NOT NULL, create_date DATE NULL); Query OK, 0 rows affected (0.08 sec)
This scripts creates a testing table called "tip" with 4 columns in the current database.
2007-05-11, 4702👍, 0💬
Popular Posts:
What’s the difference between Unit testing, Assembly testing and Regression testing? Unit testing is...
Where are cookies actually stored on the hard disk? This depends on the user's browser and OS. In th...
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
What does XmlValidatingReader class do? XmlTextReader class does not validate the contents of an XML...
What Tools to Use to View HTML Documents? The basic tool you need to view HTML documents is any Web ...