Video into BLOB?

[DavJans]

Is there a way for me to put a video file into a MySQL BLOB?

[DavJans]

I tried this, didn't get an error but it doesn't do anything.

Code: Select all

UPDATE Books SET book = LOAD_FILE("U:\\Books\\In-Memory Data Grids for Dummies.pdf") WHERE id = 1

[DavJans]

I also changed it into a LONGBLOB

[FourthWorld]

How did you confirm nothing happened, and what does the LiveCode you're using to check for errors look like?

Offhand, with the switch to LONGBLOB the only other part I might check would be the ID.

While only a subset of LiveCode devs use MySQL, 100% of MySQL users do. I'd guess a quicker answer may be findable among MySQL resources, such as this one I found searching with DuckDuckGo for "storing video in MySQL blob":

https://stackoverflow.com/questions/103 ... sing-mysql

[DavJans]

I have not done anything with livecode yet, just using MySQL Workbench to get the query working first. I found that same stackoverflow and that's where I started but couldn't get it to work. I get that this may not be the best place for a MySQL question but the community is awesome.

No syntax error no change

Screenshot 2022-08-09 113029.jpg (5.27 KiB) Viewed 1636 times

[FourthWorld]

I'm glad you like it here. It's a good crew. It's even better when we find solutions.

May I ask why you want the video in the DB file? Most folks just store the path in the DB and keep their media in separate files. Not only does this help keep the DV structure lean and tidy, it opens up options for streaming the media from the server.