next »

[HappyFace]

To delete every column in a table you can do:

Code

GeSHi (sql):
DELETE * FROM someTable
Created by GeSHI 1.0.7.20

or if you want to delete data from a table that meets a certain condition:

Code

GeSHi (sql):
DELETE * FROM someTable
WHERE someCondition = 1
Created by GeSHI 1.0.7.20