how to insert many similar records in mysql at a time using phpmyadmin?
- by Networker
we know that we can insert multiple records at a time using this query:
INSERT INTO `TABLE1` (`First`,`Last`) VALUES ('name1','surname1'),
('name2','surname2'),
('name3','surname3'),
('name4','surname4');
but what if we want to add 1000 similar records as above (name*,surname*) do we have to write down all the records or we can use something like wildcard? or is there any other solution using mysql?
