views:

59

answers:

3

if i write delete * from tablename in mysql ,all rows get delete it there any way to get the data back in mysql in that table

+3  A: 

No, there isn't.

And the correct query is DELETE FROM tablename. (without *)

True Soft
+2  A: 

Restore from backup.

Marcelo Cantos
A: 

the easiest way would be to restore your latest backup.

oezi