Hello, I try with DATAUPDATE to fill a long raw field with binary data. With a simple primary key this work without any problems (e. G.)
----------------------- File: fill_table.sql ----------------------- DATAUPDATE TABLE MyTable KEY MyPrimaryKey 1 SET MyLongTextField 2 INFILE 'MyFile.data' COMPRESSED LONGFILE MyLongTextField BINARY ----------------------- File: MyFile.data ----------------------- "1","\MyPath\MyFileWithLotOfData_1.data" "2","\MyPath\MyFileWithLotOfData_2.data" So far so good! That means I've got a primary key witch identifies the dataset clearly In this case is the insert of the data no problem. In another table I've got a compound primary key and that triad build up the SQL-statement as follows: ----------------------- File: fill_table.sql ----------------------- DATAUPDATE TABLE MyTable KEY MyPrimaryKey 1 KEY MyPrimaryKey 2 SET MyLongTextField 3 INFILE 'MyFile.data' COMPRESSED LONGFILE MyLongTextField BINARY The File with the references looks as follows: ----------------------- File: MyFile.data ----------------------- "1","3","\MyPath\MyFileWithLotOfData_1.data" "2","7","\MyPath\MyFileWithLotOfData_2.data" This unfortunately doesn't work. I always get an error message: "Invalid end of SQL-Statement" I already had a look in the ReplicationManager Documentation and saw that it works. Unfortunately thaws no example for a compound primary key. I have already tried several combinations but this never end it up in the result I wanted to have. Thanks Christian Herrmann -- GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 EUR/Monat...) jetzt 3 Monate GRATIS + 3x DER SPIEGEL +++ http://www.gmx.net/derspiegel +++ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
