/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

8 votes291 views1 answer
Oracle create datafile
SQL
1 vote256 views1 answer
Find logged in users mysql
SQL
17 votes276 views6 answers
Get last record in sql
SQL
0 vote285 views4 answers
Convert databse to achieve log mode oracle
SQL
3 votes281 views2 answers
Mysql create timestamp column
SQL
0 vote268 views1 answer
Print orcale
SQL
1 vote317 views1 answer
Db.Database.SqlQuery
SQL
0 vote306 views1 answer
How to create notes in mysql
SQL
0 vote289 views2 answers
Sql server Insert Into table
SQL
3 votes284 views2 answers
Postgres alter table owner
SQL