MySQL Question

delete all from table

what's faster?

DELETE * FROM table_name;


or

DELETE * FROM table_name where 1=1;


why?

does
truncate table
work in access?

Answer

Just use TRUNCATE TABLE table_name