You searched for mysql boolean default value

June 19, 2013

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By Ernie Souhrada 7 Comments

… use the latin1 character set. mysql: CREATE TABLE innodb_ft_list2 ( value VARCHAR(18) NOT NULL DEFAULT ”) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.02 sec) mysql: SET GLOBAL… change slightly. What about a Boolean mode query? The docs tell us that if we use Boolean mode, and we put a…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: Ernie Souhrada, FTS, FullText Search, InnoDB, MyISAM, MySQL 5.6

Post: Efficient Boolean value storage for Innodb Tables

April 23, 2008 By Peter Zaitsev 6 Comments

Sometimes you have the task of storing multiple of boolean values (yes/now or something similar) in the table and if …(0) default NULL, `c8` char(0) default NULL, `c9` char(0) default NULL, `c10` char(0) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 mysql> show table… NULL as one of flag values means you can’t use normal “=” comparison operator with them: mysql> select count(*) from cbool where…