Skip to content

howto - mysql delete from table as t

Posted by artodeto on

You try something like

DELETE FROM `my_table` AS `t` WHERE ...
and you get back an error. The problem is, that you are using an alias for your table and mysql can not figure out where to delete from. The solution/fix is simple
DELETE `t` FROM `my_table` AS `t` WHERE ...
. I found the answere here

Trackbacks

No Trackbacks

Comments

Display comments as Linear | Threaded

No comments

Add Comment

E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

Markdown format allowed
Form options