MySQL Insert Multiple Rows Record in Table

Inserting Multiple Records in Mysql Code in Single query


Most of the cases we are using for loop to insert multiple records in a table. This will cause increase in execution time. So the best way is to avoid the looping. This example will help you to insert multiple records to MySQL table in Single query.

insert into students (student_name, age) values
('Michalka', '26'),
('Mockingbird', '18'),
('John', '23')


Related Topic List of Mysql Error Code and Description
Pagination in JSP Page Example Code
Mysql Query for Dynamic Table Creation
How to Control the Position of Child Controls on Screen by Android Layout Managers
PHP Functions for MySQL
SQL  MySQL  

nScraps.com 2011   Privacy Policy  Terms of Service  Feedback