mysql5.0条件删除问题

[banjiamayi]

event表结构：
id(int) name(varchar)
1 user1
2 user1
3 user1
4 user2
5 user2
想要删除所有name为user1的数据，使用 DELETE FROM event WHERE id in (select id from event where name='user1')，报错：You can't specify target table 'event' for update in FROM clause。想请教各位应该如何解决

[jlwei888]

delete from event where name = 'user1'

[北方吸引力]

为什么不直接DELETE FROM event WHERE name='user1'

[licip]

是呀。为什么不直接删除呀。

[banjiamayi]

谢谢各位了，我以为删除都要根据主键删呢！

[古月一刀2005]

1楼头像太那个啥啦！！！