murthy gandikota a écrit :
> Hi
> I did a hot backup a while ago. When I had to restore from backup there
> were several error messages. So I ran mysqlcheck for every table with
> --auto-repair option. Is this the best way?
>
> Thanks
> Murthy
>
>
> ---
Hi,
Some Body wrote:
Hi all,
I have a situation where the data in a table has to
be transposed.
I have a table having columns
id, a_id, a1, a2, a3, a4, ..., an
In the query I need a result similar to
a_id a_id a_id
2001 2002 2003
a1 1 2 1
a2 1 5 6
a3 2
I have an issue. Both with mysql pconnect enabled and disabled.
Randomly, between every 5 mins or ever few hours the connections will jump
by as much as 100 connections of more in the span of a a few seconds (5 - 15
seconds usually) then return back to normal.
However, during this peak/flood of
Hi,
I have a problem with mysqldump, its exiting with the message
mysqldump: Error 5: Out of memory (Needed 22042208 bytes) when dumping
table `theTable` at row: 2990911
I have searched the archives and tried what people suggested but nothing
seems to work, I'm dumping using the following co
Hi all,
I have a situation where the data in a table has to
be transposed.
I have a table having columns
id, a_id, a1, a2, a3, a4, ..., an
In the query I need a result similar to
a_id a_id a_id
2001 2002 2003
a1 1 2 1
a2 1 5 6
a3 2 7 2
a4 3 9
I rewrote my line using your suggestion ...
select id,first,middle,last from persons order by rand() limit 10;
and it worked perfectly. I'm still curious about why my original version
gave such cockeyed results, but I'll focus on the successful solution
and leave that unsolved problem for anoth
I had the same behavior when I substituted this line using char(10) for
the line that used '\n' . The query sent from the file still just prints
the '\n' instead of interpreting it.
select Concat('\n', Honorific, ' ' ,First, ' ', Middle, '. ', Last, ' ',
Suffix, ' (', spouse, ')', char(10), house,
Just one suggestion re the behavior of special characters between file
input and command line input. Try using char(10) {I think that is new
line} instead of \n. That should work in both scenerios.
-Original Message-
From: John Kebbel [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 28, 20
Hi
I did a hot backup a while ago. When I had to restore from backup there were
several error messages. So I ran mysqlcheck for every table with --auto-repair
option. Is this the best way?
Thanks
Murthy
-
Ahhh...imagining that irresistible "new
Hi
I did a hot backup a while ago. When I had to restore from backup there were
several error messages. So I ran mysqlcheck for every table with --auto-repair
option. Is this the best way?
Thanks
Murthy
-
Ahhh...imagining that irresistible "new
If might suggest:
SELECT * FROM BAR
ORDER BY RAND()
LIMIT 10
On 4/29/07, John Kebbel <[EMAIL PROTECTED]> wrote:
For possible educational research purposes, I was playing around with a
query that would randomly select people from a database. The database I
experiment with has a group of fictiti
On Friday 27 April 2007, B. Keith Murphy wrote:
> Hey everyone,
>
> I have been considering putting together a e-zine for MySQL as my way to
> give back to the community. I was curious as to what type of interest
> there would be in this.
Well. Looks like you can't back out of it anymore ;)
For possible educational research purposes, I was playing around with a
query that would randomly select people from a database. The database I
experiment with has a group of fictitious persons with id numbers
(primary key) ranging sequentially from 2 to 378. When I ran these
queries below, I was e
13 matches
Mail list logo
