BULK INSERT in MYSQL

by

In MySQL, the equivalent would be

LOAD DATA INFILE

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

LOAD DATA INFILE 'C:\MyTextFile'
INTO TABLE myDatabase.MyTable
FIELDS TERMINATED BY ','

More Related Contents:

  1. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  2. MySQL Conditional Insert
  3. How to do a batch insert in MySQL
  4. Get the new record primary key ID from MySQL insert query?
  5. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  6. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  7. MySql Table Insert if not exist otherwise update
  8. Increment a database field by 1
  9. Prevent auto increment on MySQL duplicate insert
  10. MySQL trigger On Insert/Update events
  11. How do I get the ID of multiple inserted rows in MySQL?
  12. MySQL trigger to update a field to the value of id
  13. How to insert data to MySQL with auto-incremented column(field)?
  14. How to insert values in table with foreign key using MySQL?
  15. MySQL INSERT INTO … VALUES and SELECT
  16. MySQL error 1241: Operand should contain 1 column(s)
  17. MySQL Insert & Joins
  18. How to add a where clause in a MySQL Insert statement?
  19. Reserved word in column name – insert into MySQL [duplicate]
  20. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  21. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  22. Mysql insert into 2 tables
  23. MySQL – insert data from another table merged with constants
  24. Insert data into table with result from another select query
  25. MySQL optimizing INSERT speed being slowed down because of indices
  26. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  27. Incorrect integer value: ” for column ‘id’ at row 1
  28. “Unknown column in ‘field list'”, but column does exist
  29. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?
  30. Insert and set value with max()+1 problems

Leave a Comment