mysqlheidisql
I get the following error when import CSV to a table in Heidi SQL "SQL Error: Data truncated for column 'SlNo' at row 1"
I have saved a dataframe (pandas) in python as a CSV file and am trying to import it into a table using Heidi SQL and I get the error "SQL Error: Data truncated for column 'SlNo' at row 1".
Here is the error:
Here is my table:
And this is the CSV file: https://drive.google.com/open?id=1qDfkTNZNTOKTSpnia3CFoW1ahHm6LQ5v
Solution
As fields in your csv file separated by comma, you have to specify "," (comma) as field terminator on import dialog instead of ";" (semicolon).
- MySQL or MariaDB - how to instantiate user @variables?
- MySQLConnector c# update MySqlCommand parameters
- INSERT INTO after WITH statement in MySQL
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
- Connect to mysql in a docker container from the host
- Executing SQL scripts on docker container
- XAMPP - Error: MySQL shutdown unexpectedly
- Undefined Module Mysl - Ballerina
- DBeaver error resolving maven dependencies
- ERROR - Must Declare Scalar Variable - C#
- Cannot delete or update a parent row: a foreign key constraint fails. Foreign keys exist though
- MySQL: IF EXISTS ... TRUNCATE
- mysql COUNT and Sum with join 2 tables
- Install Navicat on Linux Ubuntu 12.04
- How do I set MySQL temporarily to read-only through the command line?
- How to increment column values with CodeIgniter's update_batch()
- str_to_date is showing NULL when date is available
- Can I use a variable from the GET_ method to fetch MySQL data?
- select ... where id = any value. is it possible?
- Data truncated for column?
- Unable to install MySQL on Windows 10 - Installer hangs indefinitely
- Why can't I just use "HAVING" clause all the time instead of "WHERE"? It works the same basically if you use it before/without "GROUP BY"
- MySQL Workbench: Connecting to database automatically on the startup
- Select rows for a specific date using TIMESTAMP datatype
- GoLang How to load nested objects using GORM
- What COLLATE should i set to use all kind of possible languages?
- MYSQL - SELECT NULL otherwise latest DATE per group
- How do I set up replication from MySQL to MongoDB?
- NULL when value not found using substring_index in MYSQL
- How to convert an entire MySQL database characterset and collation to UTF-8?