method for inserting data when there are self-growing primary keys in the table

How do we insert data in a database table that has its own growth primary key (as shown in the picture)?

Mode one:

When there is less data to insert, that is, we can specify the value of the column (ID) with a single insert, but the newly inserted value cannot be duplicated with the existing value, and must be greater than the maximum value

Mode two:

When the amount of data that needs to be inserted is large, it is obvious that method one is not feasible when it is necessary to bulk generate data inserts by means of stored procedures or other means. So what should we do now?

There are two ways to fix this:

1 The value of this column (ID) can be set to null or 0, so that MySQL will do its own processing

2 Manually specify the column you want to insert, but do not specify the column (ID)