Need help in importing database table from csv file

I am trying to import database table from a csv file. The size of csv file is 77 MB.

When i import it through SSH, i get error:


ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1,,,XXXXXX,XXXXXXXXXXXXX.' at line 1


I am not sure why it's giving this error. Everything seems ok.

I have already lost many hours trying to fix it but no luck. So, i need help from some expert to successfully import it.

Please Bid only if you know how to fix it, and have done similar job in past. Need to fix it urgently.

Kemahiran: Pentadbiran Pangkalan Data, Linux, MySQL, PHP, SQL

Lihat lagi: create database schema csv file, sql create table csv file, mysql create table csv file, mysql import csv command line, how to import csv file in mysql using command line ubuntu, import csv to mysql phpmyadmin, how to import table in mysql workbench, mysql stored procedure import csv file, import csv to mysql workbench, mysql create table from csv, import csv file into mysql using php, create sql server table csv file, database query csv file, importing posts form csv file wordpress, updating access database records csv file, create table csv file plsql, create table csv file, godaddy database upload csv file, update access table csv file asp page, php export table csv file

Tentang Majikan:
( 13 ulasan ) Kolkata, India

ID Projek: #19361014

Dianugerahkan kepada:


Hello I can fix this. I have 6 years of experience working as a system admin. You can always contact me to give me more details. Thank you

$40 USD dalam sehari
(35 Ulasan)

28 pekerja bebas membida secara purata $38 untuk pekerjaan ini


Hello, My name is Sergey. I am Freelancer from Saint Petersburg, Russia. I can help you as an experienced programmer to fix your script and import CSV properly. 2000+ successfully completed projects speak for me Lagi

$50 USD dalam sehari
(1791 Ulasan)

Hello. I would like to help you with cvs importing to mysql issue. I have expeience. Please read my feedbaks. Thank you.

$35 USD dalam sehari
(644 Ulasan)

Lets get it fixed. Please check my reviews and then decide on me. Looking for a long term relationship. Thanks, Ajit

$35 USD dalam sehari
(276 Ulasan)

hi there, an expert here with 10-12 years of expertise in db. Let's resolve your issue and get it done ASAP. Thanks.

$35 USD dalam sehari
(35 Ulasan)

Hello. Lots of sysadmin experience here. I'm able to help you and import it for you. I can even do this for less than 35 USD. Just let me know. Thank you.

$35 USD dalam 0 hari
(53 Ulasan)

I want to use my attained talents, my skill set of Python/Django, PHP/Laravel, NodeJS/JavaScript/React, HTML, CSS, SQL, Automation Testing, my 9 years of experience, my enthusiasm, my positive outlook, and my abilitie Lagi

$35 USD dalam 10 hari
(39 Ulasan)

Hello, I can help you fix your PHP script so you can parse the big CSV file without error. Please send me the csv file and PHP script so i can figure out the situation. Regards

$35 USD dalam 0 hari
(10 Ulasan)

I have read the description and I can import database table from CSV file as per your requirements. I have two years of web development experience. I can do it asap. I can do it on your budget.

$35 USD dalam 0 hari
(20 Ulasan)

Over the last 12 years, I have developed a wide range of websites for startup companies, small businesses and product base projects. My core competency lies in complete end-end management of a new website developme Lagi

$35 USD dalam sehari
(7 Ulasan)

Hi Sir I will fix it today itself, in a few minutes. Can I have a look at the file? Regards Navpreet

$35 USD dalam 0 hari
(3 Ulasan)

Hi! hope you are doing well. My name is Walter. I'm a Senior Developer in PHP, MySQL, Javascript. More than 15 years of experience. I can help with your project. Regards

$35 USD dalam sehari
(3 Ulasan)

Dear customer. I have just checked your description. I am sure I have rich experience for your task. To be honest, I have just started working here But I hope you consider your work could be suitable to new freelan Lagi

$35 USD dalam 10 hari
(9 Ulasan)

I have 6 years experience in SQL database as well as good knowledge on CSV format file load to SQL. Hope your file is not corrupted

$35 USD dalam sehari
(5 Ulasan)

I am good in database along with perl, php mysql and powershell Please let me know if you are good to award this project to me

$40 USD dalam sehari
(3 Ulasan)

Hello, if I'm not mistaken, you need to fix a PHP script that uploads csv data to database. I could fix it and would like to see the file and script to find out what the issue is. Looking forward to hearing from you. : Lagi

$35 USD dalam sehari
(5 Ulasan)

Hi, I am expert in web application development and also have experience over 10 years in security and quality assurance fields. I think I can do it for you as soon as possible. In order to see my customers projects Lagi

$35 USD dalam 2 hari
(2 Ulasan)

This can be easily done through SSIS package. Let me know if you want to talk further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies Lagi

$45 USD dalam sehari
(3 Ulasan)

I am experience in your issues. Able to resolve the issue quickly. looking for your response. Thanks

$55 USD dalam sehari
(4 Ulasan)

i have 7+ years of experience working as a database developer. I can fix that import error for sure.

$35 USD dalam sehari
(1 Ulasan)

Hello sir hope you are fine, i am interested in your project because i did many similar projects before and having working experience of 1+ years in this field, i am a professional software engineer and have complete g Lagi

$50 USD dalam 6 hari
(2 Ulasan)