643 questions
0
votes
1
answer
115
views
Syntax error 1064 with LOAD DATA ... FIELDS OPTIONALLY ENCLOSED BY '"'
My SQL statement in MySQL 5.7.44, Windows 10:
drop table if exists test;
create table test (col1 VARCHAR(64), col2 VARCHAR(80) );
LOAD DATA LOCAL INFILE "t.csv" INTO TABLE test FIELDS ...
- 1,213
0
votes
0
answers
187
views
options for loading mnist dataset in python
I am confused about the options for loading data into python. Using the mnist dataset, I have found numerous options for loading the test and trainsets. Since these options are tethered to the ...
0
votes
1
answer
77
views
Error in importing Large Dataset using My SQL Workbench intogroup azure batabase
I'm fairly knew to using SQL. I'm trying to load in my dataset (about 12.1K rows, 6000kB) into a table using workbench, but I get this error:
Error Code: 1045. Access denied for user '[my_username]'@'%...
- 1
0
votes
0
answers
78
views
mysql LOAD DATA INFILE OPTIONALLY ENCLOSED BY '(' AND ')'
I have some problems with the LOAD DATA INFILE practically the path of the text file is unable to load on mysql.
I tried with many combinations but I can't, could you kindly help me
I advance a ...
- 97
2
votes
0
answers
342
views
LOCAL INFILE ERROR: but as of v2.0 you must provide streamFactory option returning ReadStream
I wanted to upload a csv file using SQL commands but I got this error.
As a result of LOCAL INFILE command server wants to read yob2019.csv file, but as of v2.0 you must provide streamFactory option ...
- 21
0
votes
0
answers
94
views
How many possible names for a MySQL config file? (my.cnf; .config, my.ini...) [duplicate]
I'm running MySQL 8.0 on just my little Windows machine (Windows 11 Pro) and I want to use LOAD LOCAL INFILE, which of course requires that I set some parameters in a file that might be called 'my.ini'...
- 31
1
vote
2
answers
152
views
MySQL load data insert, split values to multiple rows
Using the LOAD DATA LOCAL INFILE
num column Store every 6 digits
How can I parameterize the load command to iterate through the array?
Mysql version 8.0.23
In File text
id length 1,
cnt length 2,
num ...
- 13
1
vote
1
answer
626
views
Mysql Using CSV Files Stored In Blob Field With Load Data Infile
I am working with a database that has a series of csv files stored in blob fields.
I'd like to select the correct file (.csv) using a select with where clause, then insert records for each line in the ...
- 21
1
vote
0
answers
278
views
MYSQL Rollback with a set of LOAD DATA INFILE
I use a batch file to load my tables from CSV files using numerous LOAD DATA INFILE commands. When an error occurs during one of a table's LOAD statements, rollback occurs only for that table with 0 ...
- 21
-1
votes
1
answer
64
views
Load DATA INFILE taking approx 3min for a 2 GB file. updated_at column set to DEFAULT CURRENT_TIMESTAMP
all records have same TIMESTAMP value.
i am not setting any value for updated_at column in the load data infile statement.
Why such behaviour
Expecting the seconds to be different as it is not ...
0
votes
0
answers
503
views
Mysql Workbench - Error Code: 5. Out of memory
I am using myworkbench 8.0 to import data to MySql 8.0.32 from a 16G csv file. I get "Error Code: 5. Out of memory (Needed 784334881 bytes)". Machine spec: Win 10, 8Gb ram. CSV is | ...
- 1
1
vote
1
answer
583
views
MySQL: Imported CSV file converts Nulls to 0
I have checked some of the older discussions regarding this mater and it does not seem to fix the issue for me.
The only solution avaiable was here: MySQL load NULL values from CSV data but I have way ...
- 85
0
votes
1
answer
289
views
Read Data into Google Colab Environment
I am trying to run a sentiment analysis code in google colab to increase the processing speed compared to running the code on my device. But I am running into a strange error, which I am not able to ...
0
votes
1
answer
236
views
How do I properly use LOAD DATA LOCAL INFILE IGNORE 1 LINES to update an existing table?
I successfully loaded large CSV files (with 1 header row) to a MySQL table from Python with the command:
LOAD DATA LOCAL INFILE 'file.csv'
INTO TABLE 'table"
FIELDS TERMINATED BY ';'
IGNORE 1 ...
1
vote
1
answer
75
views
mySQL Server function LOAD DATA INFILE producing odd output
I am trying to load a .csv file into mySQL Server. I have to do this in the terminal. My process for importing the .csv is as follows:
mysql> CREATE TABLE Dealers ( Dealer_ID INT PRIMARY KEY, ...
