SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: Mysql command
-
Mar 20, 2002, 23:12 #1
- Join Date
- Mar 2002
- Posts
- 20
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Mysql command
I want to add to extra columns to an existing table in the database. What is the command or for doing it. Thanks
-
Mar 21, 2002, 00:02 #2
- Join Date
- Jul 2001
- Location
- Missouri
- Posts
- 3,428
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Code:ALTER TABLE table ADD column_name create_definition [FIRST | AFTER other_column_name]
reference: www.mysql.com/doc/A/L/ALTER_TABLE.html- Matt** Ignore old signature for now... **
Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
"Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR
Bookmarks