I think, Through the command line mode it is impossible. For this you have to write a program which open and reads the (binary) data in file and inserts it to the sqlite database.
Thanks, Lloyd On Tue, 2006-11-28 at 13:36 +0800, LuYanJun wrote: > Can anybody give a simple example for domestrating ? > I am puzzled by this topic, how does a music file be sotred in DB as BLOB > type? > > TKS. > ----- Original Message ----- > From: "Alex Roston" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Sent: Saturday, October 28, 2006 4:35 AM > Subject: Re: [sqlite] Music Files > > > > At one point there was a project that did something like this, and it > > was called Route66. I think it used mysql, perl and a player called > > splay. You might google it. > > > > Alex > > > > sebcity wrote: > > > >>Is it possible to store mp3 files in a SSQLite database? would they be able > >>to be played from the database? How would you save them? > >> > >> > > > > > > ----------------------------------------------------------------------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > > > ______________________________________ Scanned and protected by Email scanner ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------