MySQL Forums
Forum List  »  Quality Assurance

5.0.92: USING table alias - fals
Posted by: Nick Baryshnikov
Date: October 04, 2011 06:52AM

Hi everyone.

Right now i'm using MySQL 5.0.92 (Because of replication from 4.0 version. I can't change that version, so I can't update this one).

Here is test-case:

yavin# jexec 32 mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 430
Server version: 5.0.92 FreeBSD port: mysql-server-5.0.92

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> USE test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> CREATE TABLE test (
-> id int(14)
-> );
Query OK, 0 rows affected (0.00 sec)
mysql> DELETE FROM test USING test t WHERE 1=1;
ERROR 1109 (42S02): Unknown table 'test' in MULTI DELETE
mysql> DELETE FROM test USING test WHERE 1=1;
Query OK, 0 rows affected (0.00 sec)


In 4.0 version this case success. Could someone hive me link or smth to solve this error?

Options: ReplyQuote

Written By
5.0.92: USING table alias - fals
October 04, 2011 06:52AM
November 10, 2011 09:45PM
November 17, 2011 08:41PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.