你即將離開本站

並前往https://stackoverflow.com/questions/63037817/if-i-truncate-table-and-after-that-i-insert-a-new-row-then-the-numbering-of-id

mysql - if i truncate table and after that, I insert a new row then ...

Truncate table drops the existing rows, but does not reset the table metadata, which is where the auto increment counter is kept.

確定！ 回上一頁

查詢 「MySQL TRUNCATE TABLE」的人也找了：

  1. Mssql TRUNCATE TABLE
    2.
  2. MySQL TRUNCATE
    3.
  3. Truncate table foreign KEY
    4.
  4. MySQL truncate foreign key
    5.
  5. Cannot truncate a table referenced in a foreign key constraint
    6.
  6. mysql刪除資料表內容
    7.
  7. mysql清空資料庫
    8.
  8. MySQL TRUNCATE table if exists
    9.