Current location - Music Encyclopedia - Today in History - How to insert multiple data with SQL?
How to insert multiple data with SQL?
Method 1. If there is not much data, you can write multiple sql statements. Insert employee value ('0 1112',' Rollin',' 1973-5-3',1,'Jiefang Road1.

Insert employee values ('0000 1',' Wang Lin',' 1956- 1-23', 1,' No.65438 Zhongshan Road +000-2', 21.

Insert employee values ('0 10008',' five melts',' 1966-3-28', 0,' beijing east road', 2 1000 1 33210.

Insert employee values ('0200 10',' Wang Xiangrong',' 1972- 12-9', 1,' Sipailou 10- 10).

Method two. If the amount of data is large, you can first save the data in the text, write a program for analysis, and then automatically generate sql statements for storage.

Method 3: You can save the data in the format supported by the database, and then import it with the tools provided by the database itself.