Insert and create multiple rows with the same value info into the table SQL (mysql)

Question

hello, my question is, how do I indicate that I want to add 20 rows with the same info and just have the auto_increment change in the I'd. thanks.

Answer 1

for auto_increment the id, you can check this page: https://www.quora.com/What-is-the-difference-between-identity-and-auto_increment-in-MySQL
the identification changes every time you insert a row

if you want add multiple rows, you can use "WHILE" : https://dev.mysql.com/doc/refman/8.0/en/while.html