Asking
Only logged in members can reply and interact with the post.
Join SimilarWorlds for FREE »

Anyone familiar with MySQL. Why DELETE FROM doesn't work but ;DELETE FROM works?

This page is a permanent link to the reply below and its nested replies. See all post replies »
Northwest · M
It worked.

Delete * from sometable where id=5
;
You hit return after the first line, but MySQL is waiting for the ; to execute the statement. When you enter the ; and hit return, the delete statement is properly executed.

The remainder of that line: Delete from.. does not execute. It’s waiting for an ;