On 9/26/2006 4:02 PM, Dan Buettner wrote:
Jorrit, it's a known behavior, not a bug.
Recent versions of MySQL will, when given a zero (0) as a value for an
auto incrementing identity column, simply fill in the next auto
incrementing value ... unless you flip a switch to specifically tell
it
Dear list,
I discovered something that seems to be odd behaviour.
I have a basic table with one column set to auto_increment:
mysql DESCRIBE basic_table;
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra
[EMAIL PROTECTED] wrote:
Hi to all!
I have to transfer copy of the one table from one to other database.
I was working with phpMyAdmin. I exported table in sql file but, when
tried to Import it to other database I got
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
On 4/10/2006 8:50 PM, Yves Goergen wrote:
On 10.04.2006 18:32 (+0100), Jorrit Kronjee wrote:
I'm not entirely sure what you mean. Are `mysql4.mydomain' and
`mysql5.mydomain' hostnames?
Yes, as I have explained earlier in this thread.
Hostnames resolve into IP adresses, which are used
Yves Goergen wrote:
On 09.04.2006 23:40 (+0100), Jorrit Kronjee wrote:
You seem to be best off with a setup where you've got the MySQL5 UNIX
socket disabled, MySQL5 bound to one specific IP address, MySQL4
listening on 127.0.0.1 and a simple port forwarding rule to MySQL4.
I'm missing
Yves Goergen wrote:
On 09.04.2006 01:03 (+0100), Eric Braswell wrote:
Does that make sense? Did I misunderstand?
That's exactly what I'm doing right now. In my test network:
MySQL 4.0 - 192.168.0.32 (mysql4.myhost)
MySQL 5.0 - 192.168.0.33 (mysql5.myhost)
But what I wanted to do is:
On 3/29/2006 2:10 PM, Jorrit Kronjee wrote:
It seems you are running in to Bug #7209:
http://bugs.mysql.com/bug.php?id=7209
This is fixed in 5.0.19 now.
Best regards
Mark
Mark,
Apparently so, thanks for the hint! We'll try to upgrade as soon as
possible.
I'll supply the mailing
Cor,
You can set the enclosing character with the ENCLOSED BY parameter.
So something like ENCLOSED BY '' will remove those quotes.
- Jorrit
C.R.Vegelin wrote:
Thanks Paul,
Yes, I've tried IFNULL() to map NULL values to empty strings.
But then I get 1;2;;4;;2;9 in stead of 1;2;;4;;2;9
So
Mike Blezien wrote:
Hello,
I'm sure this is a simple query but haven't come up with a good
approach. Need to get the number of days between two dates. IE: today's
date: (2006-04-01 - 2006-03-05)
need to calculate the number of days between these dates.. what is the
best query statement to
Mike Blezien wrote:
Jorrit,
- Original Message - From: Jorrit Kronjee [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, April 01, 2006 7:46 AM
Subject: Re: Getting number days between 2 dates
Mike Blezien wrote:
Hello,
I'm sure this is a simple query but haven't come up
[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to reach
that limit. However, these are timely based measurements, so it could've
peaked in between, although highly unlikely.
I'm not very comfortable tweaking these values in a
Mark Leith wrote:
Hi Jorrit,
Jorrit Kronjee wrote:
[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to
reach that limit. However, these are timely based measurements, so it
could've peaked in between, although highly unlikely
Hello list,
Recently we upgraded from 3.23.3 to 5.0.18 and started noticing some
weird behaviour. We have update scripts running on a regular interval
and some of these scripts randomily exited with MySQL error:
SELECT command denied to user 'user'@'host' for table 'example'
However, this error
format.
Did run mysql_fix_privilege_tables to update your
mysql passwords in the mysql privileges database?
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From: Jorrit Kronjee
[EMAIL PROTECTED] wrote:
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From: Jorrit Kronjee [EMAIL PROTECTED]
Subject: Re: Random 'select permission denied' since upgrade to 5.0.18
snip
Could this message appear when, for instance, a maximum amount of threads
has been
is your access control by hostname or IPnumber? if hostname you could
be having transient DNS issues - where the IPnumber on the client
connect can't be resolved into the permitted hostname (fast enough).
try using IPnumber in the access control and see if the problem goes
away - if it does
16 matches
Mail list logo
