how to insert many similar records in mysql at a time using phpmyadmin?
Posted
by
Networker
on Super User
See other posts from Super User
or by Networker
Published on 2014-06-02T00:54:14Z
Indexed on
2014/06/02
3:36 UTC
Read the original article
Hit count: 497
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?
© Super User or respective owner
