/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

0 vote74 views1 answer
How to get initials in sql
SQL
6 votes120 views5 answers
Oracle list tablespaces
SQL
1 vote94 views3 answers
Connection string mysql
SQL
0 vote79 views1 answer
Myswql show full processlist
SQL
0 vote77 views1 answer
Create boolean column in MySQL with false as default value?
SQL
1 vote82 views1 answer
Oracle rolling back transactions
SQL
0 vote80 views1 answer
Error code 1241 mysql
SQL
0 vote93 views2 answers
Null value in column violates not-null constraint
SQL
1 vote78 views1 answer
Mysql how to reset primary key
SQL
0 vote86 views1 answer
Rollback to name in sql
SQL