/SQL/Remove all records from table mysql

Remove all records from table mysql

Delete all records from table

DELETE FROM table_name;

Delete all content in table mysql

TRUNCATE tablename

Remove all records from table mysql

/* Will delete all rows from your table. Next insert will take next auto increment id. */
DELETE from tableName;
/* Will delete all rows from your table but it will start from new row with 1. */
TRUNCATE tableName;

Similar codes

11 votes133 views1 answer
Mysql text type max length
SQL
0 vote126 views2 answers
Sql join on wildcard
SQL
0 vote125 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote139 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
1 vote151 views2 answers
Sql queries practice
SQL
0 vote135 views1 answer
Apex for oracle 11g
SQL
1 vote158 views1 answer
Sql server loop over query
SQL
0 vote133 views1 answer
Sql get number of days between two dates
SQL
1 vote135 views1 answer
Backup mysql data only
SQL
0 vote167 views1 answer
Reset a table's identity column and remove test records
SQL