load text data into table : Load Data Into Table : Backup Load SQL / MySQL

Ajax
Ajax Examples Ajax Tutorials Scripts and Programs
Javascript
Javascript Examples Tutorials DHTML Tutorials Javascript References Scripts and Programs
HTML
HTML Tutorials HTML References HTML DOM 0 References HTML DOM 2 References
CSS
CSS Tutorials CSS References
PHP
PHP Source Code PHP References Scripts and Programs
C#
C# Source Code C# Examples

SQL / MySQL » Backup Load » Load Data Into Table »

load text data into table



LOAD DATA INFILE '/textFileName.txt'
INTO TABLE quackers
FIELDS TERMINATED BY ';'
LINES TERMINATED BY 'rn'
IGNORE 1 LINES;

/*
      Colons, by using ':'

      Semicolons, by using ';'

      Spaces, by using ' '

*/