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
-1
votes
1 answer

How to import file into oracle table

I have a .tbl file with data and I'm trying to import this data into a table. I'm using SQL Developer for this with this command: load data infile "C:\path\users.tbl" insert into table users fields terminated by "|" lines terminated by "\r\n; But…
johy
  • 3
  • 1
  • 4
-1
votes
1 answer

Loading csv file into MYSQL table using LOAD INFILE

I am trying to load a small file into a dummy table created on MYSQL but I get these below errors when I try running the commands.Please kindly help me regarding this. Thank you. mysql> LOAD DATA INFILE '/Users/ravitejavutukuri/Desktop/Acme…
Teja
  • 13,214
  • 36
  • 93
  • 155
-1
votes
3 answers

LOAD DATA INFILE error in php

I want to import a csv file content into a database table, I'm using this code that it works perfectly when pasting it in phpmyadmin console: LOAD DATA LOCAL INFILE '/Applications/MAMP/htdocs/testApp/trips.csv' INTO TABLE trips FIELDS TERMINATED BY…
androniennn
  • 3,117
  • 11
  • 50
  • 107
-1
votes
1 answer

load infile from txt file doesnt work

I have problems with loading my data from a txt file into my table Tables: CREATE TABLE s_schueler ( s_schnr int(20) NOT NULL AUTO_INCREMENT, s_name varchar(30) NOT NULL, s_k_klasse varchar(10) NOT NULL, KEY s_k_klasse (s_schnr), …
user3371521
  • 37
  • 7
-1
votes
2 answers

Python inFile with loop

I am attempting to open a file with python in order to take the averages off of a file input.txt. After the averages are taken, they then must be displayed after each person's name such as 's score is bacons. We have not yet gone…
Khama'li A Surrah
  • 21
  • 2
  • 8
-2
votes
1 answer

Is there anything in mariadb to import data from .txt file or different format where i can define a filed value length from position to position?

Trying to import the data in maridadb and my data will look like "20220910SATURDAY" "20220911MON" "20220912TUE" "20220913THUR" represents the data. My database structured columns are…
Vikas Reddy
  • 1
-2
votes
1 answer

Load data infile does nothing

I'm kinda new to SQL. I am trying to add data to an alredy created table, the csv looks like these, it is 132645 lines…
user15468984
-2
votes
1 answer

XML LOAD DATA INFILE childnode value overrides parent nodes value

I want to get the value of the parent child node in XML but the value of the childnode is overriding it because they're of the same name How do I make it pick the parent node value without the childnode value overriding it? I'm using LOAD XML LOCAL…
ken4ward
  • 2,246
  • 5
  • 49
  • 89
-2
votes
1 answer

inFile - reading different files

I am curious to know from the more experienced c++ programmers out there if there is a way to have a function read in files that have different formats. Example is one file has a template of house # then street name and the other file is the…
Hang It Fire
  • 1
  • 1
-2
votes
1 answer

java.lang.IllegalArgumentException: Named query not found: LOAD DATA INFILE

I am desperately hoping that someone could help shine some light on this for me as I have been struggling to find the solution for several hours and not getting anywhere. I have problem in the SQL requette : LOAD DATA INFILE and i don't know the…
Ism Ze
  • 1
  • 5
-2
votes
1 answer

MySql error using OPTIONALLY ENCLOSED BY

I am uploading huge csv file in a mysql database using LOAD DATA local INFILE command. The table has got single field(hids) only which is integer,primary and autoincrement.The query is $insert_query = "LOAD DATA local INFILE '".$target_path."' INTO…
user3671491
  • 99
  • 1
  • 10
-2
votes
1 answer

load data infile mysql- won't run

I am trying to load a text file with fields separated by commas and lines by a newline. The data is out of order from my table, and i am trying to pass my column names out of order. Is this the correct way to go about this? LOAD DATA INFILE…
SteveManC
  • 132
  • 4
  • 12
1 2 3
…
42
43