Matthew,
The mistake seems to be in believing that the alias from the SELECT
carries over and is used in the UPDATE. You need to add an alias to
the UPDATE. You are referring to _import_products in the UPDATE, but
you never define it as an alias.
On Tue, Mar 13, 2012 at 10:30 PM, Matthew Stuart
Matthew, Baron,
I am actually a bit confused,* what has the SELECT to do with the UPDATE?*
SELECT ProductSku, COUNT(ProductSku) _import_products FROM
_import_products GROUP BY ProductSku;
I think the problem is simply that you are using two relations (tables)
that are effectively the same and yo
If you want to go to this year's MySQL conference like all the cool
kids, now's your chance. Percona is giving away free tickets (and free
books)! Details here:
http://www.mysqlperformanceblog.com/2012/03/14/win-free-mysql-conference-tickets/
--
MySQL General Mailing List
For list archives: http
Dear All,
Is there any way to recover data or only schema of corrupted innodb
tables.My 4 innodb tables are coorupted in a database.
mysql> show tables;
+-+
| Tables_in_ois |
+-+
| acos|
| aros|
| aros_acos
