• Categories
    • PHP
    • phpMyAdmin
    • PHPMailer
    • FFMpeg
    • PHPEXcel
    • PHPDoc
    • PHPUnit
    • CakePHP
    • CakePHP 2.0
    • Cake PHP 2.1
    • CakePHP Model
    • Facebook PHP SDK
    • composer-php
    • PHP 7
    • PHP GD
    All Categories
  • About

Error while importing CSV file in database

mysqlcsvphpmyadmin


PHP Snippet 1:

LOAD DATA INFILE '/path/to/test.csv'
INTO TABLE tmp
FIELDS TERMINATED BY ';'
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(id,test);

Related Snippets

Using if(isset($_POST['submit'])) to not display echo when script is open is not working

Laravel - How to properly generate unique slugs from article titles?

How to test a php login connected to a mysql db through xampp?

Error loading MySQLdb Module 'Did you install mysqlclient or MySQL-python?'

MySQL order by field in Eloquent

CONCAT columns with Laravel 5 eloquent

The sum of the user's points

Creating command to backup MySql database in Laravel

phpmyadmin : Depends: php-twig (>= 2.9) but 2.6.2-2 is to be installed. WHAT?

MySQL upgrade causing unexpected results on simple WHERE clauses

How to loop sql table data inside a html table

Pages are working fine on localhost but not running on the hosting server

Live search query using JS and PHP for QA forum

SQL to convert multiple rows into a single row of variable length

Laravel Unknown Column 'updated_at'

About Contact Privacy policy Terms and conditions