[SQL] delete data table

[Arkie]

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

[ashish]

DELETE * FROM alextable it delete the total record or filed . .
regards,
phe9oxis,