Change the structure of a table in MySQL

0

In this case I will use ALTER TABLE to take the AUTO_INCREMENT to zero (0) .

The goal is to bring the table to 0 without having to delete it and create a new one. To do this we just have to write the following order:

ALTER TABLE 'nombre_de_la_tabla' AUTO_INCREMENT = 0
    
asked by 20.01.2018 в 19:31
source

1 answer

0

ALTER TABLE can change the structure of a table, add or delete columns, create or delete indexes, modify the type of existing columns or rename columns or the table itself. You can also change features such as the storage engine used for the table or the comment in the table.

Source: link

    
answered by 20.01.2018 / 19:31
source