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 escaped content
* 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
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
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 up
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.
Anton
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
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 load