• 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

How to map the two arrays with a duplicate value?

I can't delete my image when it is liked because of the foreign key in mysql

Fatal error: [] operator not supported for strings

PDOException: PDO::__construct(): php_network_getaddresses: getaddrinfo failed: no such host known

CSV to PHP class properties

Make survey at laravel 5.4 and MySQL

phpMyAdmin Accepts NULL in the NOT NULL field

XML to CSV with PHP converter [problem with images grabing]

WordPress Subquery returns more than 1 row on SELECT

find in set in laravel ? example

renameColumn migration fails for existing column with columns does not exist error

Select option from dropdown menu with PHP and mySql

How can I make a full text index of the column?

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given [duplicate]

SQL AVG() to 2 decimals

About Contact Privacy policy Terms and conditions