Hello,
i'm new to maxdb and databases and trying to learn
both at the same time.
i have a table, as shown below and would like to load
a couple of mp3 files in this table:
CREATE TABLE "DBA"."BINARIES"
(
"BINARYID" Integer NOT NULL
DEFAULT SERIAL (1),
"BINARYFILE" Long BYTE,
"TITLE" Varchar (64) UNICODE NOT
NULL DEFAULT USER,
PRIMARY KEY ("BINARYID")
By reading past posts of the list i found that i gotta
use long byte for binary data.
however, i'm not sure on how to do the syntax for the
loader. i know i have to use a 'long-file' but not
sure how to put it together.
the primary key is 'SERIAL' so it doesn't need a value
right?
if we asume that the mp3 files have titles 'song1' and
'song2' and the files
are c:\music\tune1.mp3 and c:\music\tune2.mp3, could
someone please
give me an example on how to arange the files for the
loader command?
so far i have used the loader to import data from txt
files, but this case
with the binary files has confused me a bit.
thank you for your help,
Regards
Matt
__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
