USE hitcounter; ALTER TABLE info DROP count; Hope this helps Roger
-----Original Message----- From: Wileynet [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 8: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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]