Hi,
I have issue with the mytop application. I have installed
mytop-1.6.tar.gz from http://jeremy.zawodny.com/mysql/mytop/
MySQL on localhost (5.0.54)
up 60+00:11:46 [21:52:35]
Queries: 6.3G qps: 1301 Slow: 0.0 Se/In/Up/De(%):00/00/00/00
qps now: 1730 Slow qps: 0
At 12:13 AM 12/6/2009, Oscar wrote:
hi all,
Someone told me that UPDATE equals DELETE old row + INSERT new row.
Anybody clarify it?
Are you talking about InnoDb or MyISAM tables.
I'm only familiar with MyISAM tables. Perhaps he was referring to an Update
that added more text to a variable
At 1:26 PM -0500 12/6/09, Victor Subervi wrote:
Hi;
I have the following:
mysql> select * from categoriesProducts as c inner join relationshipProducts
as r on c.ID = r.Child inner join categoriesProducts as p on r.Parent = p.ID
where p.Category = prodCat2;
ERROR 1054 (42S22): Unknown column 'pro
Hi;
I have the following:
mysql> select * from categoriesProducts as c inner join relationshipProducts
as r on c.ID = r.Child inner join categoriesProducts as p on r.Parent = p.ID
where p.Category = prodCat2;
ERROR 1054 (42S22): Unknown column 'prodCat2' in 'where clause'
mysql> describe categorie
I do know thw internals,
but i guess having "select" only would be enough if you drop the "auto-repair"
feature.
a "repair" always requires changes (=write).
maybe you can use mysqlldump instead ?
re,
wh
René Fournier schrieb:
> Just wondering what they are. I'd rather not use the MySQL root use