Re: Copying Binary data from one table to another

normanp wrote:
Hi,

I have these tables with binary data stored in tinyblobs and blobs in
MySql. In my application I sometimes need to copy them to another
table. Not all the data, maybe just a column or two. So I first
select the data into a record set and then loop and insert it (its
the only way can do it)

I've never worked with mysql, but this statement would make me absolutely
reject it as a database-of-choice if I was ever considering it. Are you sure
this is the only way? Can't you do a simple "INSERT INTO tablename (<column
list>) SELECT <column list> FROM othertable" in MySQL?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Copying Binary data from one table to another
    ... only if you use parameters for user inputs - in other words don't ask the ... I'm not sure of the syntax used in MySQL to update a ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Copying Binary data from one table to another
    ... I'm not sure of the syntax used in MySQL to update a ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Copying Binary data from one table to another
    ... I have these tables with binary data stored in tinyblobs and blobs ... I've never worked with mysql, but this statement would make me ... [Please do not toppost on usenet] ...
    (microsoft.public.inetserver.asp.db)
  • Re: Subscript out of range: 3 Need Help
    ... > I am not having to much luck in the DB's query tool. ... You may need to find a MySQL newsgroup or forum to find out the proper ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: Problem retrieving results from database
    ... If you execute both of these statements, the first row never gets echo'd. ... and then copying and pasting the query into the mysql commandline client and checking what the actual result is. ... is a spam trap. ...
    (comp.lang.php)
Loading