Inserting multiple rows in mysql

Question

Is the database query faster if I insert multiple rows at once   like  INSERT      UNION  INSERT      UNION    I need to insert like 2-3000 rows

User · Answer

If you have your data in a text-file  you can use LOAD DATA INFILE      When loading a table from a text file  use LOAD DATA INFILE  This is usually 20 times faster than using INSERT statements    Optimizing INSERT Statements  You can find more tips on how to speed up your insert statements on the link above

User · Answer

Here is a PHP solution ready for use with a n m  many-to-many relationship  table       get data  table 1   get table 1 rows     table 2 fk id   123      prepare first part of the query  before values   query    INSERT INTO  table        table 1 fk id       table 2 fk id       insert date    VALUES       loop the table 1 to get all foreign keys and put it in array foreach  table 1 as  row         query values          row  table 1 pk id       table 2 fk id  NOW            Implode the query values array with a coma and execute the query   db- gt query  query   implode      query values

User · Answer

db table name   blog post   menu    site title    Insert into Table  column names separated with comma   sql    INSERT INTO product cate  site title  sub title     VALUES    site title     sub title         db table name   blog post   menu    site title    Insert into Table  column names separated with comma   sql    INSERT INTO menu  menu title  sub menu    VALUES    menu title     sub menu           db table name   blog post    menu    site title    Insert into Table  column names separated with comma   sql    INSERT INTO blog post  post title  post des  post img    VALUES    post title      post des     post img

User · Answer

BEGIN  INSERT INTO test b  price sum    SELECT price   FROM   test a  INSERT INTO test c  price summ     SELECT price FROM   test a  COMMIT

User · Answer

INSERT statements that use VALUES syntax can insert multiple rows  To do this  include multiple lists of column values  each enclosed within parentheses and separated by commas    Example   INSERT INTO tbl name      a b c  VALUES      1 2 3        4 5 6        7 8 9     Source

[mysql] Inserting multiple rows in mysql

Examples related to mysql

Examples related to sql-insert