My understanding of what is happening here is this:
The 'rows' column of EXPLAIN output is an estimate of how many rows
MySQL thinks it will likely have to examine in a table to get your
answer. When there's an index, it will hopefully be able to use that
to exmaine a small subset of the rows in
On Wed, 25 Oct 2006, Paul DuBois wrote:
At 17:33 -0400 10/25/06, Waldemar Jankowski wrote:
Hello everyone,
I'm wondering if there is a way to exit out of a REAPEAT/WHILE loop
iteration in a stored procedure. I think LEAVE will get you out of the
loop completely, but I looking for something l
At 17:33 -0400 10/25/06, Waldemar Jankowski wrote:
Hello everyone,
I'm wondering if there is a way to exit out of a REAPEAT/WHILE loop
iteration in a stored procedure. I think LEAVE will get you out of
the loop completely, but I looking for something like "next" record.
Perhaps you want ITER
Hello everyone,
I'm wondering if there is a way to exit out of a REAPEAT/WHILE loop
iteration in a stored procedure. I think LEAVE will get you out of the
loop completely, but I looking for something like "next" record.
Thanks,
Waldemar
--
MySQL General Mailing List
For list archives: http:/
All;
Am I crazy, or doesn't this have to be an optimizer/explain bug?
SQL interspersed with comments follow...
mysql> CREATE TEMPORARY TABLE `table_a` ( `s_id` int(11) NOT NULL
default '0', `r_id` int(11) NOT NULL default '0', `d_id` int
(11) NOT NULL default '0', `status`
On 10/25/06, Mark <[EMAIL PROTECTED]> wrote:
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database by
different people so there was no consistency in the format used. There
are now names entered such a
Mark wrote:
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database
by different people so there was no consistency in the format used.
There are now names entered such as:
Smith, John S.
Doe - Jane
I don't have any suggestions for a script, but I've wrestled with this issue
before in other places. It is very difficult to regularize the format of a
full name:
Johnson, Jr. - Fred
Applewhite-Smith, Pamela
Quimby III, Roger Alan
etc. I suppose it all depends upon how bad the existing data is, a
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database by
different people so there was no consistency in the format used. There
are now names entered such as:
Smith, John S.
Doe - Jane W.
Doe John
Hi!
SQL Maestro Group is happy to announce a new version of our powerful GUI
solution for MySQL server administration and database development.
http://www.sqlmaestro.com/products/mysql/maestro/download/
New version features:
1. Support of events and table partitions (MySQL 5.1).
2. The new v
Hello,
Did you try to convert the .lib file to a GCC .a library ? See
http://mingw.org/mingwfaq.shtml#faq-msvcdll
If reimp doesn't work, you can try pexports and dlltool. I have an old
batch file I used for older MySQL versions at
http://athanatos.free.fr/EXE/implib.bat
[EMAIL PROTECTED]
Hello,
I'm trying to compile some C code with the simple following code (dev-c++):
#include
#include
#include
#include
int main(int argc, char *argv[])
{
MYSQL * mysql_con = NULL;
mysql_con = mysql_init(mysql_con);
return 0;
}
As the result, i obtain this :
gcc.exe -D__DEBUG__ main.
At 21:39 -0400 10/14/06, Ferindo Middleton wrote:
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date field
RV, you may find that increasing the size of the key_buffer could have
a negative effect on performance. You want to make sure that there's
enough physical RAM for all the processes on the machine, to avoid
paging/swapping to disk, which is very slow.
Here's a an interesting note:
http://dev.mys
Folks,
A few months ago, I came here asking for directions on how I could improve
performance of MySQL. Back then, I was using OpenBSD on a dual Opteron 248
with 2GB, LSI MegaRAID 320-1, 15k RPM SCSI discs, MySQL was (still is)
4.0.27, the database is MyISAM, reaching 50GB.
After some consid
Is it right to have this result with a 'show slave status'?
(...)
Replicate_do_db: dbname, dbname
(...)
I mean, to see the dbname twice? or there is something wrong in mysql
master or slave config?
I have to put the "replicate_do_db" variabile in slave config too?
thank you in advance
by
test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
17 matches
Mail list logo
