deleting fields in mysql

[kokong]

What is the query to delete some fields in mysql?

[debasisdas]

To delete some value in a field try to set the value to null.

To remove the field itself from the table try to ALTER the table.

[werks]

What is the query to delete some fields in mysql?

Try this

DELETE * FROM tblBooks

Hope it helps

Better Than Yesterday

[r035198x]

Try this

DELETE * FROM tblBooks

Hope it helps

Better Than Yesterday

Sorry werks but that won't work. The * is not allowed.
To delete all the rows in a table just use [CODE=mysql]delete from tableName[/CODE]