I'm trying to loop the following statement with PHPmyAdmin in order to add 1000 entries with the variable "i" incremented for each entry. (data and ip can be static)
INSERT INTO 'TABLE'('id', 'data', 'ip') VALUES ([i], [06/03/2016],[192.168.0.1])
It's been 20 years since I've done any coding with loops. Can anyone help me?