Jan Jozwiak writes:
> Hi
>
> I am a newbi at using MySQL. I have a littel company witch is selling
> computer-parts, but I need a database to get it all in order. I tryed for
> a week to get it to run, with out any luck. I have a text file that i want
> to import:
>
> File:
> "name1","name2",....,"name8"
> "name1","name2",....,"name8"
> ..
> ..
>
> Can enyone help me get startet
>
>
> PS: I use Linux RH60, kernel 2.2.10, MySQL-3.22.25
>
> Best regard
> Jan Jozwiak, Denmark jozwiak@stripped | jan@stripped
>
>
>
Hi!
You can do it two ways, by LOAD DATA INFILE or mysqlimport.
Manual on both subjects is very well written !
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped|
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+