Vaibhav Vaidya Posted November 29, 2014 Share Posted November 29, 2014 How to insert multiple rows by sql queries? Link to comment Share on other sites More sharing options...
niche Posted November 29, 2014 Share Posted November 29, 2014 LOAD DATA http://dev.mysql.com/doc/refman/5.1/en/load-data.html Link to comment Share on other sites More sharing options...
Ingolme Posted November 29, 2014 Share Posted November 29, 2014 In your insert query you can insert multiple records at once: INSERT INTO t (id, field1, field2, field3) VALUES(1, 'A', 'B', 'C')(2, 'A', 'B', 'C')(3, 'A', 'B', 'C')(4, 'A', 'B', 'C') Link to comment Share on other sites More sharing options...
Sherin Posted February 24, 2020 Share Posted February 24, 2020 You can insert multiple record through this way : insert into [table-name] (column_name) values('Value1'),('Value2'); Link to comment Share on other sites More sharing options...
Ingolme Posted February 24, 2020 Share Posted February 24, 2020 Please do not reply to old topics. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now