mysql_library_init() and threading

I'm using the C API to write a client, and I'm having trouble getting my connection to work in a worker thread. I'm confused by manual's tutorial for threading. I don't believe I need any of the thread-safe measures, because while the worker thread is running, the main thread doesn't make any My

Re: How to use API to write blobs

> On Sat, Dec 27, 2003 at 11:09:54AM -0500, Angus March wrote: > > > On Fri, Dec 26, 2003 at 09:35:42PM -0500, Angus March wrote: > > http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_query > > > > The quote I'm thinking of is: >

Re: How to use API to write blobs

> On Fri, Dec 26, 2003 at 09:35:42PM -0500, Angus March wrote: > > > Angus, > > > > > > On Fri, Dec 26, 2003 at 08:26:38PM -0500, Angus March wrote: > > > > I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a > > very

Re: How to use API to write blobs

> Angus, > > On Fri, Dec 26, 2003 at 08:26:38PM -0500, Angus March wrote: > > I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a very > > vague error: something about a problem "near '' on line 1". I'm forumating >

How to use API to write blobs

I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a very vague error: something about a problem "near '' on line 1". I'm forumating the query string w/ sprintf(query, "INSERT INTO support_files (session_id,file_type,file_body) VALUES (%ld,%ld,", sessionID,fileType); Then w/calls

Re: SELECT rows from multiple tables and order all by last added

results of two queries? Thanks list for your patience. Angus - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 10, 2002 3:57 AM Subject: re: SELECT rows from multiple tables and order all by last added &

SELECT rows from multiple tables and order all by last added

so that output rows from each table are listed in the order they were added to the DB. Is this possible? I dont think it's a JOIN because the tables are not related in any way? Thanks for your help. Angus Fraser - Before

Query fails

CREATE TABLE MSJOURNL (ACCT INT(3), DESC CHAR(29), DTE DATE) This query fails when MySQL encouters DESC. Changing DESC to DESCRIP causes the query to work. I'm wondering if filtering for the reserved word DESCRIBE causes DESC not to be legal for use in field names?