Stack Overflow
Stack Overflow

Questions tagged [load-data-infile]

A mySQL function for loading external data directly into the database.

LOAD DATA INFILE is a mySQL function for loading external data directly into the database.

More information available from the mySQL manual: http://dev.mysql.com/doc/refman/5.1/en/load-data.html

642 questions
0
votes
1 answer

Insert into partitioned table taking very long time

I have table structure like below: CREATE TABLE IF NOT EXISTS `dnddata` ( `numbers` varchar(10) NOT NULL, `opstype` char(1) NOT NULL, PRIMARY KEY (`numbers`) ) ENGINE=MYISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (numbers) PARTITIONS…
sankar.suda
  • 1,097
  • 3
  • 13
  • 26
0
votes
1 answer

Loading individual columns of csv

I am using load data infile, what would I have to do to import only a certaing element in CSV file to a certain column in our table
Ranoy
  • 98
  • 2
  • 4
  • 17
0
votes
1 answer

LOAD DATA INFILE - mysql/php script not functioning as it should

Trying to use 'LOAD DATA INFILE' in order to populate a database table from a CSV(10k records) but at the moment it does nothing. No error, no data being input and I have no idea what is wrong with it so any help is appreciated! My code (-CSS and…
Pidge
  • 347
  • 1
  • 5
  • 10
0
votes
2 answers

Load data from file in Play framework YAML

I would like to load some data stored in a file into my mysql database when play is applying evolution to the database. Basically when play is running the 1.sql to upgrade the database, I would like to run a "LOAD DATA INFILE" or equivalent. Maybe…
Pat-rice
  • 422
  • 1
  • 3
  • 16
0
votes
1 answer

Map column name to field name LOAD XML LOCAL INFILE

I have just exported a data table in XML format from phpPgAdmin. I want to load this file into my local mysql database. The table structure is the same for both databases. I know that mysql allows import of xml data using the example xml structure…
Franc
  • 1
  • 2
0
votes
3 answers

Importing a CSV file into mysql. (Specifically about create table command)

I hava text file full of values like this: The first line is a list of column names like this: col_name_1, col_name_2, col_name_3 ......(600 columns) and all the following columns have values like this:…
jason
  • 3,471
  • 6
  • 30
  • 43
0
votes
1 answer

in mysql is there a way to make load data infile ignore the bom?

I checked mysql site, and there seem to be a bunch of people talking about this but no solution its been yet provided. The problem is that MySQL takes the BOM as part of the csv contents, which leads to unpredictable results. I dont want to strip…
Devela
  • 564
  • 1
  • 6
  • 25
0
votes
1 answer

Loading a help file with PHP code to MySql Database?

have a help file which i have created in Notepad++ with the following syntax //Filename:PHP_Help.html