Workbench doesn't allow delete table

Question

I have a table newsletter and I want to delete/update/insert data in it, but when I type

delete * from crm_base.newsletter

for example, it gets an red "X" in the line and gives me the following error message:

Error Code: 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 '* from crm_base.newsletter_temp' at line 1.

I already unchecked the safe update mode in preferences and resetted workbench, but it still gives me the same error. Can anyone help me?

Ed Heal · Accepted Answer · 2013-01-02 15:47:10Z

3

delete from crm_base.newsletter

edited Jan 2, 2013 at 15:47

Ed Heal

60.3k18 gold badges91 silver badges137 bronze badges

answered Jan 2, 2013 at 15:46

Millard

1,1671 gold badge9 silver badges20 bronze badges

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

Comments

Eric Petroelje · Accepted Answer · 2013-01-02 15:48:10Z

2

Your syntax is not correct, use DELETE FROM crm_base.newsletter WHERE condition. Check the Delete syntax reference.

edited Jan 2, 2013 at 15:48

Eric Petroelje

60.7k9 gold badges133 silver badges178 bronze badges

answered Jan 2, 2013 at 15:47

james_bond

6,9163 gold badges30 silver badges39 bronze badges

Collectives™ on Stack Overflow

Workbench doesn't allow delete table

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related