MySql Delete not working

Question

I have a mysql delete script which gives me an error:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN mall ON mall.m_id = unifo.mids WHERE mallnames = 'My Mall'' at line 2

Delete query:

DELETE FROM unifo 
LEFT JOIN mall ON mall.m_id = unifo.mids 
WHERE mallnames = 'My Mall' && time_insert < NOW( ) - INTERVAL 25 
MINUTE

I cannot find my mistake

Mahesh Madushanka · Accepted Answer · 2016-07-03 03:23:51Z

2

you have a basic issue in this query

DELETE FROM unifo 
LEFT JOIN mall ON mall.m_id = unifo.mids 
WHERE mallnames = 'My Mall' && time_insert < NOW( ) - INTERVAL 25 
MINUTE

your performing a left join with mall table and then base on mall value your going to delete something but in left join mallname can be null no point of left joining it

2 specify the table

DELETE unifo FROM unifo ....

answered Jul 3, 2016 at 3:23

Mahesh Madushanka

3,0032 gold badges17 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:32:56Z

1

You may need to say which table you are deleting from, as in this answer: Delete with Join in MySQL

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Jul 3, 2016 at 3:23

dcc310

1,1061 gold badge9 silver badges13 bronze badges

Comments

Gordon Linoff · Accepted Answer · 2016-07-03 03:33:48Z

0

You have two tables in the from, but do not specify which to delete from.

I would recommend uses table aliases as well:

DELETE u
    FROM unifo u LEFT JOIN
         mall m
         ON m.m_id = u.mids 
WHERE mallnames = 'My Mall' AND time_insert < NOW( ) - INTERVAL 25 MINUTE ;

This assumes that you want to delete the rows from unifo.

answered Jul 3, 2016 at 3:33

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

MySql Delete not working

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related