encoded in
the tables for the time of manual conversion. The goal is to have the
tables up and running as soon as possible.
I tried to set the character sets with CHANGE, MODIFY, ALTER, but mysql
always seems to convert the tables’ data. I read that character sets will
be ignored if you convert
be done manually later.
From my side it is ok that the data is wrongly encoded in the tables for the
time of manual conversion. The goal is to have the tables up and running as
soon as possible.
I tried to set the character sets with CHANGE, MODIFY, ALTER, but mysql always
seems to convert
Hey list,
I noticed a table that was trying to fill the disk before the weekend, so I
quickly set up an event to gradually clean it out. Yesterday, however, I
returned to find 400+ jobs in state updating. I disabled the event, but the
jobs hadn't cleared up today, so I had to kill them.
I
Hello,
Have anybody tried to upgrade 5.1 to 5.6? I believe running mysql_upgrade
should be enough, but does there are some caveats?
Ilya Kazakevich.
On 2013-12-04 1:33 PM, Ilya Kazakevich wrote:
Hello,
Have anybody tried to upgrade 5.1 to 5.6? I believe running mysql_upgrade
should be enough, but does there are some caveats?
Ilya Kazakevich.
The MySQL recommendation is to upgrade one major version at a time, ie
5.1-5.5-5.6. There are so
I would from 5.1.40 to 5.5.8 first and then to 5.6
On Dec 4, 2013, at 11:33 AM, Ilya Kazakevich kazakevichi...@gmail.com wrote:
Hello,
Have anybody tried to upgrade 5.1 to 5.6? I believe running mysql_upgrade
should be enough, but does there are some caveats?
Ilya Kazakevich.
--
MySQL
Hello Sabika,
On 12/4/2013 2:56 PM, Sabika Makhdoom wrote:
I would from 5.1.40 to 5.5.8 first and then to 5.6
Why 5.5.8? Our current release is 5.5.35. 5.5.8 is an ancient release
of 5.5 and represents the very first GA release of 5.5 . There have been
27 additional releases (each with
Hi Shawn,
thanks for replying!
Comments in-line.
On 25/03/2013 21:51, shawn green wrote:
Hello Dimitre,
On 3/24/2013 5:23 PM, Radoulov, Dimitre wrote:
[...]
The documentation states the following about the replicate-wild-do-table
option:
==
This option applies to tables, views, and triggers.
?
Anyway, I assume that with the following configuration (i.e. by adding
replicate-do-db),
I'll be able to replicate all statements related to db_name1 and db_name2
(excluding possible grant/revoke statements, because the mysql system
database
won't be replicated).
Is that correct
(i.e. by adding
replicate-do-db),
I'll be able to replicate all statements related to db_name1 and db_name2
(excluding possible grant/revoke statements, because the mysql system
database
won't be replicated).
Is that correct?
Is there a better (more robust) way to replicate a subset
When creating a record, the first field (KeyField)...
KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT
...is it possible to copy this auto-generated value into
another field when using the same INSERT that creates the record?
Or would I have to use an UPDATE query using LAST_INSERT_ID
...is it possible to copy this auto-generated value into
another field when using the same INSERT that creates the record?
Or would I have to use an UPDATE query using LAST_INSERT_ID()
immediately after the INSERT statement?
Thanks for any ideas you have.
Start Here to Find It Fast!™ -
http://www.US
Take a look at TRIGGERS
C.
PS: I am curious to know why you would do that anyway
2012/10/17 W. D. w...@us-webmasters.com
When creating a record, the first field (KeyField)...
KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT
...is it possible to copy this auto-generated value
Hello Dehua,
On 10/17/2012 3:33 AM, Dehua Yang wrote:
select LAST_INSERT_ID() ; Under high concurrency , it would return other
threads value to you.
Incorrect. The results of LAST_INSERT_ID() are connection-specific. The
activity on other connections will not change or alter the value
Hello Shawn
Thanks for your tips. We send the select LAST_INSERT_ID() by our data
middle ware.
I'll ask the middle ware team to check it out.
On Wed, Oct 17, 2012 at 9:33 PM, Shawn Green shawn.l.gr...@oracle.comwrote:
Hello Dehua,
On 10/17/2012 3:33 AM, Dehua Yang wrote:
select
At 02:44 10/17/2012, Claudio Nanni, wrote:
Take a look at TRIGGERS
C.
PS: I am curious to know why you would do that anyway
Will want this 'AssociatedWith' field to be associated
with an older records' KeyField so I can search for a
group of records by this field.
Start Here to Find It
that rely on that first record's
`KeyField`.
PS: I am curious to know why you would do that anyway
2012/10/17 W. D. w...@us-webmasters.com
When creating a record, the first field (KeyField)...
KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT
...is it possible to copy this auto
-Original Message-
From: ratlhaga...@yahoo.com [mailto:ratlhaga...@yahoo.com]
Sent: September 18, 2012 7:31 AM
To: mysql@lists.mysql.com
Subject: [Possible Spam]Php programmer
Hi,
I need help, I'm working on a project that need time query in Mysql. I
want
to display a time
Hi,
I asked this question over on stackoverflow - basically I have a query
and when using EXPLAIN I see that around 2400 rows are still being
scanned. I'd added various indexes but it cannot make it perform any
better.
I would appreciate if anyone has any further ideas?
access on it
using both key parts (if by some crazy reason it doesn't, use FORCE INDEX to
make it to). This way, you will be scanning as few rows as possible.
Also, check if the EXPLAIN has Using index. If it doesn't, add `id` to the
index, i.e. use
INDEX (importance, company_id, id)
That way
FORCE
INDEX to make it to). This way, you will be scanning as few rows as possible.
Umm... It might just be a matter of cardinality? :-) While the optimizer can be
wrong at times (and it's certainly worth checking that) it does usually pick
the best choices.
--
Bier met grenadyn
Is als
Marc,
From what you say it seems a logical problem with your data,
And it cannot be corrupted at database level.
Check your application logs.
You need to know why order does not succeed.
Cheers
Claudio
On Jun 18, 2011 9:52 PM, sono...@fannullone.us wrote:
I think I may have corrupt data. In
I think I may have corrupt data. In one of my shopping cart installs,
no orders were getting written to the orders table. Other tables, like the
customers table, were being written to just fine.
In phpMySQL, I ran check, optimize, repair, and analyze on the orders
table, and
Very interesting. Waiting for update.
On Jun 15, 2011 4:51 AM, Hank hes...@gmail.com wrote:
The slave is receiving null as the statement based insert, not an out of
range number from the master.
I've been doing more research all day on this bug and have a bit more
information as to what's
You should also have a look at the slave relay log.
But in any case sounds like a bug.
Claudio
On Jun 14, 2011 5:18 AM, Hank hes...@gmail.com wrote:
Both my master and slave bin logs look OK (I think)..
master bin log:
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET
That is the slave relay log dump I posted (and mis-labeled). Thanks.
-Hank
On Tue, Jun 14, 2011 at 2:34 AM, Claudio Nanni claudio.na...@gmail.comwrote:
You should also have a look at the slave relay log.
But in any case sounds like a bug.
Claudio
On Jun 14, 2011 5:18 AM, Hank
2011/06/13 22:38 -0400, Hank
But that bug report was closed two years ago. I have no idea if it's the
server sending bad data or the slaves. I think it's the slaves, because on
the slave error, it clearly is getting this statement: insert into test
values (1,null) to replicate, but when it is
The slave is receiving null as the statement based insert, not an out of
range number from the master.
I've been doing more research all day on this bug and have a bit more
information as to what's causing it. I plan to write it up tomorrow and
post it.
Basically, everything works perfectly,
Hello All,
I have a 64bit, 5.5.8 master, and this bug appears on both 5.5.11 and 5.5.8
32 and 64-bit slaves (statement based replication).
I'm finding an auto-increment field (part of a compound primary key) updates
correctly using null to insert the next value on the master.. but when
this
Hank,
I can't reproduce it right now,
But it really seems a bug.
Just a shot in the dark, Are you sure you have statement based and not mixed
replication?
I don't even know if that would affect , just an idea.
Claudio
On Jun 14, 2011 3:07 AM, Hank hes...@gmail.com wrote:
Hello All,
I have a
Yes, it's basic out-of-the box mysql replication.
This appears to be an instance of this bug:
http://bugs.mysql.com/bug.php?id=45670
But that bug report was closed two years ago. I have no idea if it's the
server sending bad data or the slaves. I think it's the slaves, because on
the slave
Both my master and slave bin logs look OK (I think)..
master bin log:
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
SET TIMESTAMP=1308012505/*!*/;
SET @@session.pseudo_thread_id=9/*!*/;
SET
If the bracketed stuff really can be anything, you're better off doing it
externally, I guess. If you can be reasonably sure that there'll not be any
square brackets in there, you can fluff about with instr() and substr().
On Sat, Jan 22, 2011 at 6:18 PM, Eric Bergen eric.ber...@gmail.com wrote:
There isn't a built in way but you can try
http://www.mysqludf.org/lib_mysqludf_preg/
I would go with the php/perl script if this is a one time thing.
-Eric
On Jan 21, 2011, at 11:31 AM, Phil pchap...@nc.rr.com wrote:
I have a table which contains a username column which may be constructed
I have a table which contains a username column which may be constructed
something like
somename[A] or [DDD]someothername
The A or DDD can be anything at all.
I've added a new column to the table to which I'd like to populate with the
value within the square brackets.
I
the databases use MyISAM
exclusively.
Given the above, can anyone suggest any possible causes?
Thanks
Mark
--
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
statement: we haven't changed the structure
of this database recently (it hasn't changed for months, if not years).
We are running MySQL 5.0.77 on Centos. All the databases use MyISAM
exclusively.
Given the above, can anyone suggest any possible causes?
Thanks
Mark
--
http
This is most likely user error but I noticed today that
when I subract 1 from the curdate() function I get a very
interesting result:
mysql select curdate() - 1 from dual;
+---+
| curdate() - 1 |
+---+
| 20101000 |
+---+
1 row in set (0.00 sec)
You're using incorrect syntax for date math. Use:
CURDATE() - INTERVAL 1 day
See the manual for details.
-Original Message-
From: Ted Maas [mailto:tm...@uic.edu]
Sent: Friday, October 01, 2010 7:47 AM
To: mysql@lists.mysql.com
Subject: possible curdate() issue
This is most likely user
Daevid Vincent wrote:
We currently have some tables that are approaching 1 BILLION rows (real
Billion, with nine zeros, not that silly six zero version). Trying to do an
ALTER on them to add a column can sometimes take hours.
A few years ago I have tested possible table structures
I had to do this trick with a few million rows in the table, and what
I did was to create a new table with the required structure, then did
insert into select from, starting with the newest data first, cause
that made sense for my application. Then, renamed the old table and the
new.
YMMV
andu
-Original Message-
From: Rob Wultsch [mailto:wult...@gmail.com]
Sent: Thursday, August 05, 2010 6:05 PM
To: Daevid Vincent
Cc: MySQL List
Subject: Re: Possible tricks to ALTER on huge tables?
Having significant amount of overhead for unused columns will without
doubt harm
there's an optimization for you mysql developer team)
Another option I considered, was is it possible to just go in with a hex
editor and rename the field in the .frm file? Is there some kind of .frm
editor available anywhere?
r...@mypse:/var/lib/mysql/agis_core# hexdump -C country.frm
1000 01
Daevid Vincent wrote:
I'm wondering if we had the foresight to create the tables, and then tack
on extra dormant columns of various common types, such as:
Nothing beats empirical evidence. Why don't you try it and find
out (and report back)!
--
MySQL General Mailing List
For list archives:
, or if
it treats any change the same and will still take hours to complete (if so,
perhaps there's an optimization for you mysql developer team)
Another option I considered, was is it possible to just go in with a hex
editor and rename the field in the .frm file? Is there some kind of .frm
editor
I have two tables and I have data to insert into both at the same time,
but the second table depends on an ID that is auto created in the first
table. I'm not sure exactly how to accomplish this.
Table_One
Table_One_Index_ID
Data_One
Date_Two
Table_Two
Table_Two_Index_ID
Table_One_Index_ID
Keith,
You will need to reference the mysql_insert_id() function after
adding the row to Table_One. Then use the value returned for the rest of
the tables.
http://dev.mysql.com/doc/refman/5.1/en/getting-unique-id.html
Mike
At 08:48 AM 3/12/2010, you wrote:
I have two tables and I have
Johan,
That seems to be the ticket. Thanks!
Keith
On Fri, 2010-03-12 at 16:54 +0100, Johan De Meersman wrote:
Have a look at last_insert_id().
On Fri, Mar 12, 2010 at 3:48 PM, Keith Clark
keithcl...@k-wbookworm.com wrote:
I have two tables and I have data to insert into both at
INTO child2 VALUES (@id, ... );
-Original Message-
From: Keith Clark [mailto:keithcl...@k-wbookworm.com]
Sent: Friday, March 12, 2010 7:57 AM
To: mysql@lists.mysql.com
Subject: Re: Nested inserts possible?
Johan,
That seems to be the ticket. Thanks!
Keith
On Fri, 2010-03-12 at 16:54
Have a look at
last_insert_id()http://dev.mysql.com/doc/refman/5.1/en/information-functions.html#function_last-insert-id
.
On Fri, Mar 12, 2010 at 3:48 PM, Keith Clark keithcl...@k-wbookworm.comwrote:
I have two tables and I have data to insert into both at the same time,
but the second table
i used mysql_tzinfo_to_sql utility to create timezone_* database after
upgrading zoneinfo in my host.
after that i am seeing this mismatch.
'America/Sao_Paulo' (http://www.timeanddate.com/worldclock/city.html?n=233) and
'America/Buenos_Aires'
Hey all -
I have a table listing references for chapters in a book. I'm trying to find
all the cases where a single chapter lists more than one reference from the
same author. In this example table, I want it to find IDs 1 and 2, because
they're both from the same author, and both in chapter 1
On 13/02/2010 16:12, Brian Dunning wrote:
Hey all -
I have a table listing references for chapters in a book. I'm trying to find
all the cases where a single chapter lists more than one reference from the
same author. In this example table, I want it to find IDs 1 and 2, because
they're both
MuraliKrishna wrote:
Hi is it possible to have two instances of mysql over single windows xp.
because I want to workout with those as server and client. please help me
regarding this.
Sure you can!
Read this and get back to us with questions:
http://dev.mysql.com/doc/refman/5.1/en/multiple
Hi is it possible to have two instances of mysql over single windows xp.
because I want to workout with those as server and client. please help me
regarding this.
Yes you can, but port has to be different.
Regards,
Thiyaghu CK
www.mafiree.com
On Sat, Feb 6, 2010 at 2:50 PM, MuraliKrishna
murali_kris...@arthaoptions.com wrote:
Hi is it possible to have two instances of mysql over single windows xp.
because I want to workout with those as server
http://isc.sans.org/diary.html?storyid=7900
http://isc.sans.org/diary.html?storyid=7900
Possible new MySQL 0day
Published: 2010-01-06,
Last Updated: 2010-01-06 21:46:51 UTC
by Toby Kohlenberg (Version: 1)
http://intevydis.com/ Intevydis has published a flash video showing what
appears
On Wed, Jan 6, 2010 at 5:47 PM, Daevid Vincent dae...@daevid.com wrote:
http://intevydis.com/ Intevydis has published a flash video showing what
appears to be a new 0day exploit against MySQL 5.x.
Gah. Is there a text description available that doesn't require sitting
through some #%#$ video?
c...@hosting4days.com wrote:
:Newbie:
Short Question: Is it possible to create an inner join (or another join)
with multiple tables?
something like
$query_list1 = SELECT table1.id,table1.status, table2.id, table3.id
(more here - etc.) FROM table1
INNER JOIN table2 ON table1.id = table2.id
I don't see why not, but another choice is to create a view that encompasses
all these tables and Select * From my_view.
Arthur
On Fri, Sep 25, 2009 at 11:28 PM, c...@hosting4days.com
c...@hosting4days.com wrote:
:Newbie:
Short Question: Is it possible to create an inner join (or another join
:Newbie:
Short Question: Is it possible to create an inner join (or another
join) with multiple tables?
something like
$query_list1 = SELECT table1.id,table1.status, table2.id, table3.id
(more here - etc.) FROM table1
INNER JOIN table2 ON table1.id = table2.id
INNER JOIN table3 ON table2
On 10 Jul 2009, at 03:44, sangprabv wrote:
SELECT count(sql_id) AS total, DATE_FORMAT(insertdate, '%H:%i' ) AS
mydate FROM momt WHERE 1=1 AND insertdate BETWEEN DATE_ADD(NOW(),
INTERVAL - 1 HOUR) AND NOW() AND (sms_type = 1 OR sms_type =2) GROUP
BY
mydate ORDER BY insertdate
Firstly do an
I have this query on my current application:
SELECT count(sql_id) AS total, DATE_FORMAT(insertdate, '%H:%i' ) AS
mydate FROM momt WHERE 1=1 AND insertdate BETWEEN DATE_ADD(NOW(),
INTERVAL - 1 HOUR) AND NOW() AND (sms_type = 1 OR sms_type =2) GROUP BY
mydate ORDER BY insertdate
Is there any
Hi...
I have the following...
mysql INSERT INTO ParseScriptTBL VALUES
- ('auburnCourse.py',40,1,1),
- ('auburnFaculty.py',40,2,2),
- ('uofl.py',2,1,3),
- ('uky.py',3,1,4),
- ('ufl.py',4,1,5)
- ;
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql select * from
Try with GROUP_CONCAT(ScriptName)
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat
2009/6/12 bruce bedoug...@earthlink.net
Hi...
I have the following...
mysql INSERT INTO ParseScriptTBL VALUES
- ('auburnCourse.py',40,1,1),
-
hi martin...
thanks for the reply.. but that still generates two separate rows as well...
-Original Message-
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Friday, June 12, 2009 12:04 PM
To: bruce Douglas
Subject: RE: a possible group issue???
mysql select * from
I have a column which contains a list of IDs separated by commas. How
can I take the content of this column, and insert it into a temporary
table so that each ID is on a separate row? Can this be done using
SQL?
Thanks!
Khai
--
MySQL General Mailing List
For list archives:
I have a column which contains a list of IDs separated by commas. How
can I take the content of this column, and insert it into a temporary
table so that each ID is on a separate row? Can this be done using
SQL?
Can be done in a stored procedure, or (more easily) in an application
language.
(and tried to explain how to do
that).
But if somebody finds that the message
*1135: Can't create a new thread (errno 35); if you are not out of
available memory, you can consult the manual for a possible
OS-dependent bug*
really is caused by a file limit, I propose to report a bug about
for a possible OS-dependent
bug
Hi all!
Mark wrote:
On my FreeBSD:
usr/include/errno.h:#define EAGAIN 35 /* Resource temporarily unavailable
*/
/usr/include/errno.h-#ifndef _POSIX_SOURCE
/usr/include/errno.h-#define EWOULDBLOCK EAGAIN /* Operation would block
*/
Ok, next step then:
The OP wrote
Hello guys and gurus
I am keep getting this error after a while *1135: Can't create a new thread
(errno 35); if you are not out of available memory, you can consult the
manual for a possible OS-dependent bug*
Even though, I have 16GB memory and 32GB swap. But mysqlserver stops
answering. Could
Hi folks
then if I check with the process: I get following output:
# ps ax | grep mysqld
797 con- I 0:00.00 /bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/localhost.server1.pid
835 con- S
Message-
From: VeeJay [mailto:maan...@gmail.com]
Sent: dinsdag 28 april 2009 11:27
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: 1135: Can't create a new thread (errno 35); if you are not out
of available memory, you can consult the manual for a possible OS-dependent
bug
Hi Mark
Yes, you
thread (errno 35); if you are not out of
available memory, you can consult the manual for a possible OS-dependent
bug
Hello guys and gurus
I am keep getting this error after a while *1135: Can't create a new
thread
(errno 35); if you are not out of available memory, you can consult the
manual
.
Date: Tue, 28 Apr 2009 12:26:47 +0200
From: joerg.bru...@sun.com
Subject: Re: 1135: Can't create a new thread (errno 35); if you are not out
ofavailable memory, you can consult the manual for a possible
OS-dependent bug
To: maan...@gmail.com
CC: ad...@asarian-host.net; mysql
memory, you can consult the manual for a possible OS-dependent
bug
Hello guys and gurus
I am keep getting this error after a while *1135: Can't create a new
thread
(errno 35); if you are not out of available memory, you can consult the
manual for a possible OS-dependent bug*
--
MySQL
are not out
of available memory, you can consult the manual for a possible OS-dependent
bug
Jörg
mgai...@martini ~
FGIN.sh 35 | fgrep errno
find: File system loop detected; `/usr/include/gnome-xml/libxml' is part of
the
same file system loop as `/usr/include/gnome-xml'.
/usr/include/apr-1
useful data truncated
error. Is it possible to define the stored program to produce better
error
handling for that kind of error?
This is probably a FAQ, but in general, it appears that error diagnostics
in
stored programs are very primitive. Are there any plans in a roadmap to
improve
data truncated
error. Is it possible to define the stored program to produce better
error
handling for that kind of error?
This is probably a FAQ, but in general, it appears that error
diagnostics
in
stored programs are very primitive. Are there any plans in a roadmap
If I define an enum parameter for a stored program, and the calling code
sends an invalid value, they get the less than useful data truncated
error. Is it possible to define the stored program to produce better error
handling for that kind of error?
This is probably a FAQ, but in general
...@gmail.com wrote:
If I define an enum parameter for a stored program, and the calling code
sends an invalid value, they get the less than useful data truncated
error. Is it possible to define the stored program to produce better error
handling for that kind of error?
This is probably a FAQ
error. Is it possible to define the stored program to produce better
error
handling for that kind of error?
This is probably a FAQ, but in general, it appears that error diagnostics
in
stored programs are very primitive. Are there any plans in a roadmap to
improve this?
I have two tables defined:
CREATE TABLE `tga_body` (
`body_id` int(10) unsigned NOT NULL auto_increment,
`blob_pos` mediumint(8) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`blob_id` int(10) unsigned NOT NULL,
PRIMARY KEY USING BTREE (`body_id`),
On Mon, 19 Jan 2009, Duane Hill wrote:
I have two tables defined:
CREATE TABLE `tga_body` (
`body_id` int(10) unsigned NOT NULL auto_increment,
`blob_pos` mediumint(8) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`blob_id` int(10) unsigned NOT NULL,
Hello together,
I have successfully set up a master-master-replication between two
servers. My question is: It is possible to set up such a replication
between three (or more) servers? Like this
Master3 --- Master1 --- Master2
|
Master4
Thanks for your feedback
Best
On Tue, Jan 13, 2009 at 12:32 PM, Frank Becker
computersac...@beckerwelt.de wrote:
Hello together,
I have successfully set up a master-master-replication between two
servers. My question is: It is possible to set up such a replication
between three (or more) servers? Like this
Master3
| \^ |
| \__/ |
||
||
VV
Slave3 Slave4
==
As long as you obey the rule: A SLAVE CANNOT HAVE TWO MASTERS,
there are many replication topologies that are possible
-Original Message-
From: Frank Becker
Hello Baron, thanks for your response.
These types of questions can always be answered by asking: does my
proposed setup require any server to have more than one master? If
so, it's currently not possible.
What I want to do is the following:
eGroupware is a enterprise-groupware solution. I
'peter' is an author but 'tom' not;
etc.
If there would be no possibility to do that, how could I redesign my
tables?
It is definitely possible to write these as single queries and there are
many ways to do it. For most queries involving an AND relationship
between two rows, you will end up
Hi there, I'm just trying to solve a little problem:
There are two tables (simplified):
CREATE TABLE article (ID int, Title varchar, ...other_data );
CREATE TABLE author (ID int,name varchar,article_ID int,...other_data );
Now I have a lot of articles. They have one or more autors, e.g.
INSERT
Hi all,
I'm busy setting up replication and have encountered what looks like a bug
in mysqldump. The following commands work perfectly:
Running the following commands in the mysql client on the slave:
stop slave;
reset slave;
create database dbName;
CHANGE MASTER TO MASTER_HOST='masterHost',
To: mysql@lists.mysql.com
Subject: Possible bug in mysqldump?
Hi all,
I'm busy setting up replication and have encountered what looks like a bug
in mysqldump. The following commands work perfectly:
Running the following commands in the mysql client on the slave:
stop slave;
reset slave;
create database
Message-
From: Mark Maunder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 3:02 AM
To: mysql@lists.mysql.com
Subject: Possible bug in mysqldump?
Hi all,
I'm busy setting up replication and have encountered what looks like a bug
in mysqldump. The following commands work
.
From: Mark Maunder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 12:17 PM
To: Rolando Edwards
Cc: mysql@lists.mysql.com
Subject: Re: Possible bug in mysqldump?
Thanks for the reply Rolando.
In both the examples I provided (pipe and text file) the CHANGE MASTER
*To:* Rolando Edwards
*Cc:* mysql@lists.mysql.com
*Subject:* Re: Possible bug in mysqldump?
Thanks for the reply Rolando.
In both the examples I provided (pipe and text file) the CHANGE MASTER
command appears at the top of the data import and is uncommented and
therefore executes before the data
Under 5.0.41 I have having problems of CPU sitting at exactly 100% load
on a single CPU for very long periods of time, like 10 hours.
I traced this command:
mysql SHOW MUTEX STATUS;
Which returned 1281006 lines, ending with:
+-+--+--+
| File| Line | OS_waits |
Hello,
This time I'm rearly not sure if this is possible to do. I've got two
queries that I would like to bring together to make only one query ...
I've got a list of users
And also a login table
I would like to list all users and show the number of times they have
logged in.
So to get
b ON a.username = b.username
GROUP BY a.username,a.first_name,a.lastname;
PB
-
Richard wrote:
Hello,
This time I'm rearly not sure if this is possible to do. I've got two
queries that I would like to bring together to make only one query ...
I've got a list of users
And also a login
, a.last_name,COUNT(b.username) AS count
FROM user_list a
JOIN login_table b ON a.username = b.username
GROUP BY a.username,a.first_name,a.lastname;
PB
-
Richard wrote:
Hello,
This time I'm rearly not sure if this is possible to do. I've got two
queries that I would like to bring together to make
,
This time I'm rearly not sure if this is possible to do. I've got two
queries that I would like to bring together to make only one query ...
I've got a list of users
And also a login table
I would like to list all users and show the number of times they have
logged in.
So to get the list
1 - 100 of 787 matches
Mail list logo
