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? 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 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: 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
Archived
This topic is now archived and is closed to further replies.