Gossamer Forum
Home : Products : Gossamer Links : Discussions :

MySQL insert question

Quote Reply
MySQL insert question
Greetings All:

I wasn't sure whether to post this here or in the MySQL Forum - but I am sure someone will know.

I have searched for Forum and tried to decipher the MySQL docs, but am still unsure how to go about this.

When I first setup links some years ago I created 'Yes' 'No' fields within my tables eg. Do you like oranges 'Yes' or 'No' - selected via radio buttons.

I believe a better way to do it now is simply to change these fields to a different type (integer?) so I will be able to have a '1' for Yes and a '0' for No in the database. There are some real reasons I want to do this..... Now for my question.

What MySQL Monitor command will I need to enter to achieve this? In other words, I want every record in my database in the links table xxx.field where it = Yes to be changed to '1' and where it = No to be changed to '0'. (do I need to do the change to 0 or just delete the 'No'?)

Would I then need to change that field to a different type - integer maybe?

Sorry for my ignorance on this - but I would appreciate some advice.


Regards,



Clint.
--------------------------
http://AffiliatesDirectory.com
The Affiliate Programs Directory
Subject Author Views Date
Thread MySQL insert question Clint 1501 Jan 17, 2005, 1:29 AM
Thread Re: [Clint] MySQL insert question
Andy 1444 Jan 17, 2005, 2:04 AM
Thread Re: [Andy] MySQL insert question
Clint 1452 Jan 17, 2005, 2:19 AM
Post Re: [Clint] MySQL insert question
Andy 1463 Jan 17, 2005, 2:26 AM
Thread Re: [Andy] MySQL insert question
Clint 1441 Jan 17, 2005, 3:47 AM
Post Re: [Clint] MySQL insert question
Andy 1459 Jan 17, 2005, 3:53 AM