0

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

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.

20th Sep 2018, 4:50 PM
Lady Lier
1 Antwort
+ 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
21st Sep 2018, 9:40 PM
Daniel Antonio Paternina González