Conjurer Posted October 20, 2003 Share Posted October 20, 2003 I\'ve used a number of databases going back as far as Rbase; but I am new to MySQL and was just trying to create some fields in a table that would be set to either yes or no. I tried using a type of \"set\" and I got an error back. Do I use \"enum\" instead? Or just text with a size of 1? Quote Link to comment https://forums.phpfreaks.com/topic/1194-how-do-i-create-a-yn-field-in-a-table/ Share on other sites More sharing options...
BinaryStar Posted October 20, 2003 Share Posted October 20, 2003 you can use char with a size of one.....there are probably other ones you could use but that is what i use.. BS Quote Link to comment https://forums.phpfreaks.com/topic/1194-how-do-i-create-a-yn-field-in-a-table/#findComment-4001 Share on other sites More sharing options...
Conjurer Posted October 20, 2003 Author Share Posted October 20, 2003 I finally got the \"set\" type to work. I had to put the default value in without a qoute around it, then it took. Thanks for your help. :wink: Quote Link to comment https://forums.phpfreaks.com/topic/1194-how-do-i-create-a-yn-field-in-a-table/#findComment-4002 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.