database

[prolong199]

I am trying to delete the contents of a table and i am using the statement

delete from "table"

but its not working, i think it is because although i have connected to the database it doesn't know what db and what table to delete from. Can someone please help me solve this very simple problem?

[gesf]

What error are you getting !?
Maybe you're making something wrong!

// This is wrong
delete from "table"

// This is right
delete from table

If you have successfuly connected to the DB and the table exists, it should work!

Cheers

I use this query to delete all content in a table
delete from table where 1=1;
___________________
free ebooks mysql | free ebooks download