Easy MySQL question...

[lone-nut]

How can one append (add new column) to a mysql table...
or even yet delete the table... ?

[klamath]

To delete the table, use 'DROP TABLE foobar'

To add a column, use 'ALTER TABLE foobar ADD COLUMN [column definition]'

Where foobar is the name of the table.

This can be found easily in the MySQL documentation @ mysql.com

------------------
- Klamath
Get my GnuPG Key Here (http://klamath.dyndns.org/mykey.asc)

[lone-nut]

cool thanks... I know I'm jsut lazy sometimes
going through documentation on websites is an arduous task...

arduous = big word

http://www.linuxnewbie.org/ubb/smile.gif
thanks fer the help klamath

-ln