I plan in installing the latest MySQL version tomorrow. Does MySQL not support Bool eg
true and false
On 22 May 2013, at 19:05, shawn green <shawn.l.green@stripped> wrote:
> Hello Neil,
> On 5/22/2013 1:05 PM, Neil Tompkins wrote:
>> Hi, Like the link states
>> "For clarity: a TINYINT(1) datatype does NOT ENFORCE a boolean value data
>> entry. For instance, it's still possible to insert a value of "2" (any
>> integer up to the TINYINT max value). I personally don't see the added
>> value of a 'BOOLEAN' synonym type which infact behaves unlike a boolean
>> Has BOOL, BOOLEAN been taken out of MySQL 5.6 ?
>> On Wed, May 22, 2013 at 6:01 PM, Ian Simpson
>>> BOOLEAN is a synonym for TINYINT(1) in MySQL:
>>> On 22 May 2013 17:55, Neil Tompkins <neil.tompkins@stripped>
>>>> I've just created some tables that I designed using the MySQL Workbench
>>>> Model. However, the database type BOOLEAN which was in my models has
>>>> converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5
>>>> Windows 2008 server.
>>>> Any ideas why this has been removed ?
> This is exactly the same behavior that MySQL has had for over a decade. Nothing has
> been added or removed since release 4.1.0 (2003-04-03)
> Also, why are you using a pre-release (milestone) version of 5.6 when the full
> release (GA) versions of 5.6 are available?
> Shawn Green
> MySQL Principal Technical Support Engineer
> Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
> Office: Blountville, TN
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql