List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:May 6 1999 2:20pm
Subject:Re: LOADING from a file
View as plain text  
"Sandrine C." wrote:
> 
> Hello !
> 
> Just wanted to know hot to do when you want to load a table : What is the
> 'look' of the filr
> 
> For example : if i have a simple table like
> Name VARCHAR   Birth DATE
> 
> How should be the file to load??
> 
> Thanks

Hi Sandrine

The file to load via LOAD DATA INFILE or mysqlimport should look like this:
"John"	1974-03-33
"Mary Ann"	1981-04-25
...

a) The columns of one row are by default seperated by an <tab> character.
b) Each row ends with a <newline> character.
c) Strings are enclosed in doublequotes ".
d) If you want either of backslash \, quote ', double quote " in your strings, you have to
escape them by a backslash.
In order to get the string:
 abc\def'cgk"poq
you have to write:
 abc\\def\'cgk\"poq
e) If you want <newline> and/or <tab> characters inside your strings, you have
to use:
 \n for <newline>
 \t for <tab>

If you want another format, you can specify other field and line seperation strings.

Tschau
Christian

Thread
LOADING from a fileSandrine C.6 May
  • Re: LOADING from a fileChristian Mack6 May