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]

Reply via email to