LMSouq
database Open

MySQL Delete all rows from table and reset ID to zero

MA
marek_lani
1 month ago
3 views
Problem Description
I need to delete all rows from a table but when I add a new row, I want the primary key ID, which has an auto increment, to start again from 0 respectively from 1.

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base