MySQL: enum vs. int, enum vs. varchar - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: MySQL: enum vs. int, enum vs. varchar (/showthread.php?tid=33450)

MySQL: enum vs. int, enum vs. varchar - El Forum - 08-26-2010 [eluser]Peter Dräxler[/eluser] Hi guys. Which of MySQL columns enum or int is faster if I store only numbers 0 or 1? Which of MySQL columns enum or varchar is faster if I store only strings TRUE or FALSE? Thank's MySQL: enum vs. int, enum vs. varchar - El Forum - 08-26-2010 [eluser]danmontgomery[/eluser] All things being equal, storing and retrieving a number is always faster. MySQL: enum vs. int, enum vs. varchar - El Forum - 08-26-2010 [eluser]Peter Dräxler[/eluser] Thank's for reply but I'm sorry, I was posted bad questions. Please reply again. MySQL: enum vs. int, enum vs. varchar - El Forum - 08-26-2010 [eluser]danmontgomery[/eluser] 1) tinyint 2) never do this MySQL: enum vs. int, enum vs. varchar - El Forum - 08-26-2010 [eluser]Peter Dräxler[/eluser] Thank's :-)