"Nguyen, Phong" <[EMAIL PROTECTED]> wrote on 08/09/2005 01:52:58 PM:
>
> All,
> Could you tell me how to import data (file.txt)with BLOB column to
mysql?
>
> Thank you
>
> Nguyen
>
>
The "short answer" is: you escape the content of the file and make one big
INSERT statement out of it. The e
Armin,
1)When you say that the records are duplicate, do you mean the record number(first
field) or or do you mean the entire record is a duplicate?
2)Now to load a file made out of comma separated fields into a table that was created
in the same field
format, here are 2 ways:
a)mysql> USE
* Armin
> I've got two problem with mysql , maybe it is not a real
> 'problem' but i need help hardly ! :)
>
> 1 > in a table , we got many record ( 1400 ) , some of them are
> equal , i want to delete just one of them , in other word , i don't
> want two record equal .
Take a look at SELECT
Hi Riccardi,
>
> I want to import data from text file that contains decimal number
> (occasionaly with 9 decimal) but mysql import only 2 decimal.
> My columns is set to DECIMAL(6,9)
> Hi, Moreno
>
try
DECIMAL(15,9)
because I think the first argument specifies the total number of digits.
Riccardi Moreno wrote:
> I want to import data from text file that contains decimal number
> (occasionaly with 9 decimal) but mysql import only 2 decimal.
> My columns is set to DECIMAL(6,9)
Someone correct me if I am wrong: The '9' is how many decimal places after
the period you want and eats u
Dear Chip,
you cannot use reserved words as column names. You have "password" as a
col name which is a reserved word in SQL. The error derives from there,
only MySQL gets it wrong and points you into the wrong direction as to
where to search.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iC
Date |Mon, 6 Aug 2001 13:48:41 -0700
>From |[EMAIL PROTECTED]
Hello!
C> I have a table I want to import some records into. The table has 4 columns
C> -
C> user_id, name, account, password.
C> The file I have to be imported has 3 columns -
C> password,name,account.
C> I have been trying to use lo
