Home / Questions / 128204
Accepted
Sagara
Asked: 2020-01-02 17:00:56 +0800 CST 2020-01-02 17:00:56 +0800 CST

CodeIgniter how to make autoincrementing id reinsert from 1

  • 772

Hello, I am working with CodeIgniter and in an operation it happens that all the contents of a table must be deleted, and then the new records must be inserted.

All this happens without problems, but I need that when new records are inserted the auto-incrementing id reinserts from 1

I use MySql as DB

Thank you very much in advance for your answers.

php

1 Answers

  1. Best Answer

    Use the truncate table_name statement instead of delete from table_name

    • 1