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 ha
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.
BOO
simply try BOOL or BOOLEAN. 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-m
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
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
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 wrote:
> Hello Neil,
>
> On 5/22/2013 1:05 PM, Neil Tompkins wrote:
>> Hi, Like the link states
>>
>> "For clarity: a TINYINT(1) dataty
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 wrote:
> Hi Shawn
>
> I plan in installing the latest MySQL version tomorrow. Does MySQL not
> support Bool eg true and false
>
> Neil
>
> On 22
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 un
> 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 C
--- On Mon, 15/2/10, Prathima Rao wrote:
> From: Prathima Rao
> 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 of the systmem has
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 & R
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-p
, 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
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 th
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 cl
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
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 co
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 big-endian,
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
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 a
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,
Mathemat
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 on
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,
- 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).
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
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 regard
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 sponso
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
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 o
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 la
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 wro
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.
>
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, Maxi
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?
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 09:0
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
>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 Pipp
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 g
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:
http://www.mysql.com/doc/A/N/A
> 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
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, tha
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
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 futu
so there are few clear answers.
Jeremy
> ---
> On 19 January 2002 00:09, Jeremy Zawodny wrote;
>
> > To: Steve Suehring
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: Version 4 Schedule
> >
> >
> > On Fri,
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
Hello all,
To both above topics there have been answers, thank you, but these answers
are not clear at all.
---
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 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 con
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 t
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
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 on
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
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
- O
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
- O
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
- O
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
- O
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
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
- 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
- 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
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 binar
65 matches
Mail list logo
