MySQL Forums
Forum List  »  Newbie

Syntax to INSERT and SELECT records with BLOB column
Posted by: Ed Roberts
Date: October 15, 2021 01:50PM

I am working with C++ in Visual Studio (2019) that uses MySql Connector 8.0.

I need an example of C++ code to insert a record into a table with the following columns:

bytes INT, path CHAR(80), data LONGBLOB

The only thing I don't know how to do is to get contents from a file into the LONGBLOB.

Likewise, I need to know how to SELECT the contents of the LONGBLOB and store these into a file.

Is there anyplace this information is documented. MySql told me that forums are the only documentation! I promise that if I can find answers to these questions I will make an example project that illustrates these questions and many others I have ferreted out. This will be available on github.com.

Options: ReplyQuote


Subject
Written By
Posted
Syntax to INSERT and SELECT records with BLOB column
October 15, 2021 01:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.