ALTER TABLE table_name DROP col_name http://www.mysql.com/doc/en/ALTER_TABLE.html
So... mysql> use hitcounter; mysql> ALTER TABLE info DROP count; Assuming info is the table name and count is the column you'd like to drop. -----Original Message----- From: Wileynet [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 5:27 PM To: [EMAIL PROTECTED] Subject: BEGINNER QUESTION. I have looked everywhere online, books. I simply would like to DELETE a FIELD from the command line. I have a database called hitcounter. Inside hitcounter I have one table with 3 fields. I've tried... DELETE FROM info FIELD count; ALTER info DELETE count; DROP count; Can someone please tell me how to do this, OR do you have to DROP the database and start over ???? -thank you in advance Wiley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
