Clear data in MySQL table with PHP

Question

How do I clear all the entries from just one table in MySQL with PHP

User · Answer

TRUNCATE will blank your table and reset primary key DELETE will also make your table blank but it will not reset primary key.

we can use for truncate

TRUNCATE TABLE tablename

we can use for delete

DELETE FROM tablename

we can also give conditions as below

DELETE FROM tablename WHERE id='xyz'

User · Answer

TRUNCATE TABLE tablename   or  DELETE FROM tablename   The first one is usually the better choice  as DELETE FROM is slow on InnoDB   Actually  wasn t this already answered in your other question

User · Answer

TRUNCATE TABLE table    is the SQL command  In PHP  you d use   mysql query  TRUNCATE TABLE table

User · Answer

MySQLI example where  con is the database connection variable and table name is  mytable   mysqli query  con  TRUNCATE TABLE mytable

User · Answer

Actually I believe the MySQL optimizer carries out a TRUNCATE when you DELETE all rows

User · Answer

TRUNCATE TABLE  table    unless you need to preserve the current value of the AUTO INCREMENT sequence  in which case you d probably prefer  DELETE FROM  table    though if the time of the operation matters  saving the AUTO INCREMENT value  truncating the table  and then restoring the value using  ALTER TABLE  table  AUTO INCREMENT   value   will happen a lot faster

User · Answer

TRUNCATE TABLE mytable   Be careful with it though

[php] Clear data in MySQL table with PHP?

Examples related to php

Examples related to mysql