Well, that's strike one for me! I sent my first post to the list and accidently ONLY sent it to one member of the list (who was kind enough to respond anyway!)
My problem is that I am unable to change data in an existing table. I use the UPDATE function and it continues to tell me that I am using an Unknown Column. When I do a DESCRIBE on the table, I clearly see the column. Since I can see the column in the describe (named 'Field'), I must be doing something else wrong. Any help would be appreciated. (Thanks to Oscar, but his link seems to be for actually changing the format of a table, which is not my goal...yet=) --- Oscar Rylin <[EMAIL PROTECTED]> wrote: > From: "Oscar Rylin" <[EMAIL PROTECTED]> > To: "'Jones Tyler'" <[EMAIL PROTECTED]> > Subject: RE: Newbie With a Question > Date: Wed, 14 Aug 2002 22:36:05 +0200 > > http://www.mysql.com/doc/A/L/ALTER_TABLE.html > > -----Original Message----- > From: Jones Tyler [mailto:[EMAIL PROTECTED]] > Sent: den 14 augusti 2002 22:33 > To: Oscar Rylin > Subject: Newbie With a Question > > Greetings, > > To begin with, if this is an inappropriate question > for this list, let me appologize now. In that case, > if > you could direct me to an appropriate venu for my > question, I would appreciate it. > > The question? > > I downloaded a free program on the internet to have > some fun. After the download, I noticed a problem > that > I subsequently did a search on and found the answer. > The problem is that I am having problems > implementing > the fix. > > The fix is to change the entry in a row of a table > for > a particular horizontal entry (or field, if you > will). > > After I select the dB, I then typed SHOW TABLES and > identified the table in question (HUNT_CONFIG). > Looking at the Table, I then find the The first > column > is FIELD and the table entry I am interested in has > a > FIELD value of regtype. > > I want to change the entry in the third column for > regtype, which is titled VAR. The current value is > enum('0','1','2') and I need this value to be > enum('0','1','2','3') > > So, I typed the following: > > UPDATE HUNT_CONFIG SET VAR='enum('0','1','2','3') > WHERE FIELD='regtype'; > > But, it keeps giving me an error, acting as if there > is not such Column by the name of 'FIELD'. I have > double checked this many times and am certain that > the > name fo the column is FIELD. > > If you have any suggestions, they would be > appreciated. > > > > > __________________________________________________ > Do You Yahoo!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.com > __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
