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
Hey Neil,
Why not just store it as a TINYINT, that's what I do when I only care
about 0 or 1 values?
On Wed, May 22, 2013 at 2:19 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
Hi Shawn
I plan in installing the latest MySQL version tomorrow. Does MySQL not
support Bool eg true
Hi Shawn
I plan in installing the latest MySQL version tomorrow. Does MySQL not
support Bool eg true and false
Neil
On 22 May 2013, at 19:05, shawn green shawn.l.gr...@oracle.com wrote:
Hello Neil,
On 5/22/2013 1:05 PM, Neil Tompkins wrote:
Hi, Like the link states
For clarity: a
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
Why not use ENUM with True|False or Y|N Only issue is it doesn't throw
and error of you enter an illegal value but I don't think I've ever
flagged the field as NOT NULL.
On Wed, May 22, 2013 11:32, Darryle Steplight wrote:
Hey Neil,
Why not just store it as a TINYINT, that's what I do when I
suspect (without
proof) that it works the same as it has for more than a decade.
-Original Message-
From: Wm Mussatto [mailto:mussa...@csz.com]
Sent: Wednesday, May 22, 2013 1:57 PM
To: mysql@lists.mysql.com
Subject: Re: Version 5.6.2-m5 Boolean Datatype
Why not use ENUM with True
On 05/22/2013 06:55 PM, Neil Tompkins wrote:
Hi,
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 been
converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5 on
Windows 2008 server.
2013/05/22 21:17 +, Rick James
In query syntax, TRUE is the same as 1; FALSE is the same as 0.
and UNKNOWN is NULL. (I actually have used a three-state comparison.)
It has been suggested that one who wants a real two-state field use the type
CHAR(0) NULL.
If you have more 'flags',
--- On Mon, 15/2/10, Prathima Rao prathiman...@vsnl.net wrote:
From: Prathima Rao prathiman...@vsnl.net
Subject: Re: version 5 to 4
To: mysql@lists.mysql.com
Date: Monday, 15 February, 2010, 7:09
hi mysql tem,
i have a version 5 on which i have developed a database
now one
i need this data in version 4
Create the mysqldump script with the --compatible-mysql4 option.
PB
-
Prathima Rao wrote:
hi mysql tem,
i have a version 5 on which i have developed a database
now one of the systmem has 4
i tried to migrate from 5 to 4 it says
THE TABLES HAVE BEEN
hi mysql tem,
i have a version 5 on which i have developed a database
now one of the systmem has 4
i tried to migrate from 5 to 4 it says
THE TABLES HAVE BEEN CREATED IN LATER VERSION
I AM not able to see any table
any solutions for this?
i need this data in version 4
pls help
Thanks
You *should* be using a package manager (perfectly fine RPMs available for
all your needs), but if you must do this, it's a reasonably safe bet to
right-align and zero-pad all your number to 4 digits, at which point you're
free to concatenate them and treat them as a single number.
14.12.5.0.19
, January 14, 2010 09:44 AM
To: tony.chamberl...@lemko.com
Cc: mysql@lists.mysql.com
Subject: Re: version
You *should* be using a package manager (perfectly fine RPMs available for
all your needs), but if you must do this, it's a reasonably safe bet to
right-align and zero-pad all your number to 4
To: tony.chamberl...@lemko.com
Cc: mysql@lists.mysql.com
Subject: Re: version
You *should* be using a package manager (perfectly fine RPMs available for
all your needs), but if you must do this, it's a reasonably safe bet to
right-align and zero-pad all your number to 4 digits, at which point you're
Sort of a chicken/egg problem - no support until you pay, but you
won't pay until your problem is fixed? Have you contacted them to
inquire whether this is a problem they could help you with if you did
pay for support?
Another avenue to pursue might be a support contract with MySQL. We
had one
On 8/8/06, Ben Clewett [EMAIL PROTECTED] wrote:
Dear MySQL,
I posted a problem with 4.1.9 crashing when reading data from a InnodB
HotBackup image, and then encountering a foreign key conflict.
Have you tried another tool to backup and restore?
I can't talk to InnoDB, they make it very
Vittorio ZuccalĂ wrote:
Hello,
i'm installing an open source program based on mysql because i want to
try it.
It controls mysql's version and it wants 4.1.16 but i've 4.1.11...
Is it possible telling to mysql server to give a different number of its
version?
In other words: is there some
MySQL,
After thinking hard on the subject, I realise the server in question was
running a data set from an InnoDB HotBackup. (Which is on trial so I
have no support.)
The source machine is a PowerPC IBM. The crashing server is an Intel
Pentium. The difference being that one is
Hi,
I am replying to my own post to clarify my query. Actually, I have
5.0.22 installed and I want to use the BIT data-type on InnoDB Engine.
Can I do it or do I have to install 5.0.5 version (which is not
stable) ?
--
TIA
Asif
On 6/24/06, Asif Lodhi [EMAIL PROTECTED] wrote:
Hi,
On Saturday 24 June 2006 12:50, Asif Lodhi wrote:
Hi,
Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5.
Is that correct? Or 5.0.5 came first and then came 5.0.22?
After. 5 22.
Major.Minor.Release
--
Scanned by iCritical.
--
MySQL General Mailing List
For list
2006/6/24, Asif Lodhi [EMAIL PROTECTED]:
Hi,
Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5.
mathematically speaking, there no such number like 5.0.5 anyway...
5.05 perhaps...
MySQL are numbered according to a X.Y.Z release number.
X : is the major version, where major
At 22:46 + 4/7/04, Saurabh Data wrote:
Dear users
Can someone give me a brief description of version 4.0 , 4.1 and 5.0
The website says that 4.0 is a production release where as version
4.1 and 5.0 are alpha releases.
I mainly want to know the difference between 4.1 and 5.0 . Why
dhould
Yves Goergen wrote:
Just a short question:
does MySQL version 5.0 contain all features of version 4.1? And will new
additions to 4.1 also be implemented to 5.0 in the same step or may it
take some time for both versions to be synchronous?
generally yes! =)
--
Mirza [EMAIL PROTECTED] wrote:
Is there any info on when 4.1.2. is scheduled for relase? I am stucked
in 4.1.1. with fulltext problem (bug #2490).
Binaries of 4.1.2 will be available in a month.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Mirza,
- Original Message -
From: Mirza [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, February 09, 2004 1:54 PM
Subject: Version 4.1.2. when?
Is there any info on when 4.1.2. is scheduled for relase? I am stucked
in 4.1.1. with fulltext problem (bug #2490).
Daniel Kiss [EMAIL PROTECTED] wrote:
Does anyone know when MySQL 4.1.1 will be released?
I was told that around November 15th. Well, it's almost December now.
Soon. Probably this week.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored
Hi Dan,
for me its already the 2nd of December ;-) here in Tokyo.
On Sunday 30 November 2003 22:43, Daniel Kiss wrote:
Hi all,
Does anyone know when MySQL 4.1.1 will be released?
I was told that around November 15th. Well, it's almost December now.
Thanks,
Dan
--
kind regards
Yrj? M?enp?? [EMAIL PROTECTED] wrote:
Can I expect newly upgraded MySQL 4.0.1x engine to
read my old version 3.x tables without trouble, so I can
optimize them after I have installed the the new engine.
Yes.
You should make database backup before upgrading in any case.
I am using MyISAM
At 19:15 -0500 7/18/03, Andy Hartman wrote:
After I downloaded the Ver 5 Dev tree how do I get it active. I
tried the Windows stuff on the Mysql site with no luck.
the Windows stuff? Please be more specific.
The INSTALL-WIN-SOURCE file in the top-level directory of the source
tree may be of
On Fri, Jan 10, 2003 at 01:48:23PM -0300, Maximo Migliari wrote:
Cool, you work for Yahoo?
Yup. I do a lot of our internal MySQL advocacy and consulting.
I used to post from my work address but decided it'd be easier to
manage one on-line identity than two. Plus it might help to keep
the
On Friday 10 January 2003 23:11, Nuno Lopes wrote:
I would like to know what are the main differencies between the version 4
and and version 3 of mysql.
Check the manual:
http://www.mysql.com/doc/en/News-4.0.x.html
http://www.mysql.com/doc/en/Nutshell_Other_features.html
Cool, you work for Yahoo?
I'd love to know the extent to which Yahoo uses PHP and MySQL these days.
What is the average queries/sec that you are getting with MySQL - what
server setup, etc?
Maximo.
At 17:12 9/1/2003 -0800, you wrote:
On Thu, Jan 09, 2003 at 01:51:20PM -0300, Maximo Migliari
What were the main benefits that you noticed straight away before adapting
your code to use the new features that MySQL 4 offers?
Does the query cache make a big difference? Do you have any benchmarks,
even off your head?
Maximo.
At 09:47 8/1/2003 -0800, you wrote:
On Wed, Jan 08, 2003 at
At 13:51 -0300 1/9/03, Maximo Migliari wrote:
What were the main benefits that you noticed straight away before
adapting your code to use the new features that MySQL 4 offers?
Does the query cache make a big difference?
Oh, yes. It does. :-)
Do you have any benchmarks, even off your head?
On Thu, 9 Jan 2003, Paul DuBois wrote:
Date: Thu, 9 Jan 2003 11:29:03 -0600
From: Paul DuBois [EMAIL PROTECTED]
To: Maximo Migliari [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Version 4 safe to use?
At 13:51 -0300 1/9/03, Maximo Migliari wrote:
What were the main benefits that you
On Thu, Jan 09, 2003 at 01:51:20PM -0300, Maximo Migliari wrote:
What were the main benefits that you noticed straight away before
adapting your code to use the new features that MySQL 4 offers?
Replication is faster in 4.0. That's a big win for us, as we use
replication pretty heavily.
Are many people using MySQL version 4 yet? I'm interested in it
because I
want to use it's SSL capabilities but would like to hear that people
are not
having trouble with it first.
We have been using 4.0.x for about five months now on a production
system and have had no problems.
Scott Pippin
On Wed, Jan 08, 2003 at 09:00:51AM -0700, David Rock wrote:
Are many people using MySQL version 4 yet? I'm interested in it
because I want to use it's SSL capabilities but would like to hear
that people are not having trouble with it first.
I've had very good luck with MySQL 4 in several
Daniel,
- Original Message -
From: Daniel Kiss [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, November 21, 2002 7:18 AM
Subject: Version 4.1
Hi all,
I would like to know when MySQL version 4.1 will be available for windows
as compiled install kit?
my guess is
P.,
Wednesday, November 13, 2002, 6:05:15 PM, you wrote:
PF what mysql version is recommended for running w/apache 1.3.26 php
PF 4.2.2?
PF i'm having trouble getting mysql config'd w/these wonder if i should
PF avoid/lean to any particular versions?
3.23.53 is a stable version, 4.0.4 is
3.23.55 Production
4.2.2 is ALPHA
4.0.4 is BETA
So if you are runing a production server go for 3.*
If you can risk it go for 4.0.4 (should be ok)
and if you want to have some fun 4.2.2
Simon
-Original Message-
From: P. Fawcett [mailto:fawcett;bard.edu]
Sent: 13 November 2002 16:05
To:
Narcis,
Tuesday, July 16, 2002, 6:02:21 PM, you wrote:
NG Please tell me if the MySQL 4.0.2-alpha Windows 95/98/NT/2000/XP (17.2M)
NG supports the subselect command.
No, sub-selects will come in 4.1
How to re-write queries without sub-selects is described at:
Please tell me if the MySQL 4.0.2-alpha Windows 95/98/NT/2000/XP (17.2M)
supports the subselect command.
No version of MySQL currently supports subselects.
From http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
Subselects are currently being implemented in the 4.1 development
Hello Jeremy,
Thank you for keeping correspondence.
Kind regards
Emmanuel
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: 20 January 2002 08:22
To: Emmanuel van der Meulen
Cc: [EMAIL PROTECTED]
Subject: Re: Version 4 Schedule RE: Roadmap
On Sat, Jan 19
Hi,
Ok, it's 40001 according to #define MYSQL_VERSION_ID 40001 ;)
Regards,
Jocelyn
- Original Message -
From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 19, 2002 3:03 PM
Subject: Version number after '!' : what is the good syntax ?
On Sat, Jan 19, 2002 at 09:51:39AM +0200, Emmanuel van der Meulen wrote:
Hello all,
On 19 January 2002 09:28, Jeremy Zawodny wrote;
On Sat, Jan 19, 2002 at 09:22:38AM +0200, Emmanuel van der Meulen wrote:
Hello all,
To both above topics there have been answers, thank you, but
On Fri, Jan 18, 2002 at 09:33:38AM -0600, Steve Suehring wrote:
Hello-
I've done some searching through archive and the website but can't
seem to find a semi-concrete answer. What's the schedule, if any,
for version 4.0 to go stable?
It's stable when the MySQL folks are relatively
On Fri, Jan 18, 2002 at 08:18:29PM +0200, Victoria Reznichenko wrote:
Hello Steve,
Friday, January 18, 2002, 5:33:38 PM, you wrote:
SS REALFROM: Steve Suehring [EMAIL PROTECTED]
SS HOUR: 2002011817
SS Hello-
SS I've done some searching through archive and the website but can't seem
.
Jeremy
---
On 19 January 2002 00:09, Jeremy Zawodny wrote;
To: Steve Suehring
Cc: [EMAIL PROTECTED]
Subject: Re: Version 4 Schedule
On Fri, Jan 18, 2002 at 09:33:38AM -0600, Steve Suehring wrote:
Hello-
I've done some searching
Hello all,
On 19 January 2002 09:28, Jeremy Zawodny wrote;
On Sat, Jan 19, 2002 at 09:22:38AM +0200, Emmanuel van der Meulen wrote:
Hello all,
To both above topics there have been answers, thank you, but these
answers are not clear at all.
That's because preicting the future is
Jeremy Zawodny writes:
On Sat, Aug 25, 2001 at 08:32:00AM -0500, Steve Suehring wrote:
Hello-
I poked around on the site but didn't find any definite answer.
Roughly when is version 4.0 of MySQL expected out? I saw the
information on the todo in regards to version 4.0 and the
On Sat, Aug 25, 2001 at 08:32:00AM -0500, Steve Suehring wrote:
Hello-
I poked around on the site but didn't find any definite answer.
Roughly when is version 4.0 of MySQL expected out? I saw the
information on the todo in regards to version 4.0 and the subsequent
4.1 but didn't see any
True, but his question was about Windows NT Server.
-Original Message-
From: Sommai Fongnamthip [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 2:16 AM
To: Gerald R. Jensen; Garth Hansen; [EMAIL PROTECTED]
Subject:Re: Version question...
3.23.40 is stable
3.23.40 is stable on Linux too.
At 18:46 1/8/2001 -0500, Gerald R. Jensen wrote:
Garth:
I would go for the current version (3.23.39a).
The current version went on the stable list a long time ago, and has a
boat-load of function/featur eimprovements that either did not exist in
3.22.xx or were
Garth:
I would go for the current version (3.23.39a).
The current version went on the stable list a long time ago, and has a
boat-load of function/featur eimprovements that either did not exist in
3.22.xx or were not fine-tuned to the extent they are in the current stuff.
Gerald Jensen
-
Garth:
I would go for the current version (3.23.39a).
The current version went on the stable list a long time ago, and has a
boat-load of function/featur eimprovements that either did not exist in
3.22.xx or were not fine-tuned to the extent they are in the current stuff.
Gerald Jensen
-
Garth:
I would go for the current version (3.23.39a).
The current version went on the stable list a long time ago, and has a
boat-load of function/featur eimprovements that either did not exist in
3.22.xx or were not fine-tuned to the extent they are in the current stuff.
Gerald Jensen
-
Garth:
I would go for the current version (3.23.39a).
The current version went on the stable list a long time ago, and has a
boat-load of function/feature improvements that either did not exist in
3.22.xx or were not fine-tuned to the extent they are in the current stuff.
Gerald Jensen
-
On Mon, Jul 16, 2001 at 01:17:02PM -0400, R Talbot wrote:
As I had to compile my install and can't determine if I can upgrade
for Caldera Install. I can only locate source for 3.23.39 or 3.22.32
and I am not sure if 3.23.39 will compile properly on my 2.2.10
kernal.
It should. Give it a
- Original Message -
From: [EMAIL PROTECTED]
To: Mario Kent [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 1:40 PM
Subject: Re: Version question: -log no -log ?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
- Original Message -
From: [EMAIL PROTECTED]
To: Mario Kent [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 1:40 PM
Subject: Re: Version question: -log no -log ?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
At 7:27 PM -0400 6/19/01, Mario Kent wrote:
I installed 3.23.38 from source on a linux server, a status simply says:
Server version: 3.23.38
Now, I just installed 3.23.39 from source on another linux server and it
displays:
Server version: 3.23.39-log
I want to know what the -log means and how
Sounds like it installed to a different directory than the previous
version - try
/usr/local/bin/mysqld --version
or
/usr/local/mysql/bin/mysqld --version
It would be a good idea to remove any previous binaries to avoid
confusion, as well.
Cheers,
P
On Wed, 7 Mar 2001, Cal Evans wrote:
I
Justin a crit :
I'm having difficulties with version 3.23.32 in production..
after giving up on my own compiled version, which I compiled in the same
way, on the same box, with the same flags as 3.22.32, I was getting
occasional core dump/restarts.. so I reverted to the mysql.com binary
64 matches
Mail list logo