Hi Baron,
The answers are as below
I have not upgraded the server. Done tuning on my.cnf on innodb parameters.
No i have not change the storage engine from MYISAM to INNODB
Regards,
Krishna
On 9/28/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Krishna Chandra Prajapati wrote:
Hi All,
I
Hi all,
I have a table with ordes and i want to know the top 10 Citys have the most
ordes. This is my table
Order_id, City
Need count the rows where haver the most similar text y the column City?
Thanks all
can u please give sample data.
If the same city has more than one order_id then, you could use this
select city,count(*) total from table group by city order by total desc
limit 10;
regards
anandkl
On 10/1/07, Tomas Abad [EMAIL PROTECTED] wrote:
Hi all,
I have a table with ordes and i
Very well, Works, thanks.
-Mensaje original-
De: Ananda Kumar [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 01 de octubre de 2007 13:16
Para: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Asunto: Re: Querry Count Rows
can u please give sample data.
If the same city has more than one
Hi Rick,
(I'm CCing the list in again -- keeping the discussion on-list lets
everyone see it and potentially solve their own problems by searching
archives in future).
It looks to me like it ought to be working. What is the exact INSERT
INTO statement that isn't working?
Are there any
I posted this message on the Replication list, but have got no responses,
so, I figured I'd try here.
I just set up Replication recently with a Web Server 2003 server being the
master and a Windows 2000 server machine being the slave. When I got done, I
did a few tests, and all appeared to be
I posted this on the Replication list, but have received no reply, so I
figured I'd try here.
When the databases get out of sync during replication, what is the best way
to re-sync them on a Windows system? The only way I know of right now is to
do it late at night, and pray that no one gets in
Hi Jesse,
Jesse wrote:
I posted this on the Replication list, but have received no reply, so I
figured I'd try here.
When the databases get out of sync during replication, what is the best way
to re-sync them on a Windows system? The only way I know of right now is to
do it late at night, and
Hi Jesse,
Jesse wrote:
I posted this message on the Replication list, but have got no
responses, so, I figured I'd try here.
I just set up Replication recently with a Web Server 2003 server being the
master and a Windows 2000 server machine being the slave. When I got
done, I
did a few
It seems that way, to me, too Baron.
I actually did a test using Navicat and intput
a test debit into the table directly. It took the
amount, 150.49, without any problem, nor did it
round it off to the nearest dollar.
I need to mention that this is working in conjunction
with ColdFusion to
I can't think of anything other than looking deeper into the MySQL log
files. I'm not sure where those are on Windows, but I imagine it's not
all going to the event log. Maybe there is something in c:\program
files\mysql 5\ (or wherever you installed MySQL). Try looking for a file
named
Jesse wrote:
I can't think of anything other than looking deeper into the MySQL log
files. I'm not sure where those are on Windows, but I imagine it's
not all going to the event log. Maybe there is something in
c:\program files\mysql 5\ (or wherever you installed MySQL). Try
looking for a
What is the event at that position in the binlog? Use the mysqlbinlog
tool to see, or on the master you can run SHOW BINLOG EVENTS (check the
manual for the full syntax).
If I'm reading this right (and I'm probably not), the log goes from position
98 to position 557 Position 98 has a DELETE
Jesse wrote:
What is the event at that position in the binlog? Use the mysqlbinlog
tool to see, or on the master you can run SHOW BINLOG EVENTS (check
the manual for the full syntax).
If I'm reading this right (and I'm probably not), the log goes from
position 98 to position 557 Position
Hopefully that's enough info for you to decide whether you read it right.
But it looks like your slave had some issue with that. Do you have a lot
of privileges? One of the Google engineers told me he's sometimes seen
FLUSH PRIVILEGES break replication with a lot of privileges.
Whoever was
I did some googleing and some other searching, now I am looking for a
cure all. I have a column into which it appears that a carriage return
has been inserted and it is mucking about with some queries;
mysql select dealerLong from profile where id = '130';
++
| dealerLong |
Hi Jay,
Try this:
http://www.xaprb.com/blog/2006/04/14/bad-character-data-in-mysql/
Baron
Jay Blanchard wrote:
I did some googleing and some other searching, now I am looking for a
cure all. I have a column into which it appears that a carriage return
has been inserted and it is mucking
I have Mysql 5.0.45 using innodb tables.
Occasionally, I get corrupted tables. I can go into Mysql administrator
gui and see the bad table and I can repair the index or whatever is
wrong from the gui.
I need a command line way to periodically detect for issues and if it
finds one the I need a
Bryan Cantwell wrote:
I have Mysql 5.0.45 using innodb tables.
Occasionally, I get corrupted tables. I can go into Mysql administrator
gui and see the bad table and I can repair the index or whatever is
wrong from the gui.
I need a command line way to periodically detect for issues and if it
This has been asked for many many times on this list, not sure why mySQL AB
doesn't just release a command line tool like a 'mysql diff' and also a
'mysql lint'. The lint one should be totally trivial for them to do, as they
already have a SQL parser! I can't tell you how many times our daily
Try:
replace(replace(dealerLong, '\n', ''), '\r', '')
Jay Blanchard wrote:
I did some googleing and some other searching, now I am looking for a
cure all. I have a column into which it appears that a carriage return
has been inserted and it is mucking about with some queries;
mysql select
[snip]
Try:
replace(replace(dealerLong, '\n', ''), '\r', '')
[/snip]
Didn't work, perhaps because they are hidden. I ended up taking the long
road;
update table set foo = replace(HEX(foo), '0D', '');
update table set foo = UNHEX(foo);
HEX allowed me to see the carriage return (0D) and then use
22 matches
Mail list logo
