MySQL? ???? ?? ??? ? ??? ? ???, ?? ? ????? ?? ?? ???? ???? ???? ??? ??? ???????? ???? ?? ?? ????.

MySQL? ??? ??? ? ????? ??? ? ??? ??????? ????!

MySQL? ?? ??? ??? ? ????? ??? : ?????. ??? ????? ?? ?? ???? . ????? MySQL? Blob ??? ???? ?? ?? ???? ?? ? ????. ??? ???? ???? ???? ??? ??? ???? ????. ????? ?? ???? ?? ????. ? ?? ??? ?????? ???? ???????.

?? ?? ??? ??? ???. MySQL? ??? ??? ???????, ??? ??, ??, ?? ?? ?? ??? ? ???? ???? ? ?????. ??? ??? ????? ????? ?? ??? ?? ?? ?? ? ????? ?? ??????. ??? ???? ?? ??? ??????? ??? ???? ??? ??? ??? ?? ????.

Blob Type ?? ?? ??? ??? ?? ?????. ??? ??? ?? ????? ?? ?? ??????? ????. ? ??? ?? ??????.

 <code class="python">import mysql.connector import base64 mydb = mysql.connector.connect( host="localhost", user="yourusername", password="yourpassword", database="mydatabase" ) mycursor = mydb.cursor() def store_image(image_path, table_name, column_name): with open(image_path, "rb") as image_file: encoded_string = base64.b64encode(image_file.read()) sql = f"INSERT INTO {table_name} ({column_name}) VALUES (%s)" val = (encoded_string,) mycursor.execute(sql, val) mydb.commit() # Example usage store_image("myimage.jpg", "images", "image_data")</code>

? ??? ?? ???? ?? Base64 (?? ? ??? ??? ??)? ??? ? ?? ??????? ?????. ?? ????? ??? ??? ??? ????.

• Performance Bottleneck : ?????? ?? ??? ?? ??? ?? ?? ?? ??? ? ????. ?? ??? ???????? ?? ???? ?? ?? ???? ???????? ???????. ??? ???????
• ?????? BLOAT : ??? ??? ????? ?? ??????? ?? ???? ?????? ??? ?? ?? ??? ??? ??? ?? ???? ?????? ??? ??? ??? ?????? ??? ?????.
• ?? ? ?? : ?? ?? ?? ???? ?????? ??? ?????? ?? ? ?? ??? ?? ?????.
• ??? ??? ??? : ???? ??? ?? ?? ??????? ?? ???? ??? ??? ?? ?????? ?? ?? ?????? ??? ?????.

???? ?? ??? ?????? ?? ??? ???? ! ?? ??? (? : Amazon S3, Azure Blob Storage ?? ? ???? ???)? ???? ?? ? ?? ??????? ???? ?? ?? URL ? ??????. ??? ???? ??????? ???, ??? ?? ? ??? ?? ??? ??? ? ???? ???? ? ??? ????.

?? ? ?? ? :

 <code class="python">import mysql.connector import os mydb = mysql.connector.connect( host="localhost", user="yourusername", password="yourpassword", database="mydatabase" ) mycursor = mydb.cursor() def store_image_path(image_path, table_name, column_name): # Save the image to a designated folder and get the relative path image_name = os.path.basename(image_path) destination_folder = "images/" # Create this folder beforehand destination_path = os.path.join(destination_folder, image_name) os.rename(image_path, destination_path) #Move the image to the folder relative_path = os.path.relpath(destination_path) sql = f"INSERT INTO {table_name} ({column_name}) VALUES (%s)" val = (relative_path,) mycursor.execute(sql, val) mydb.commit() # Example usage store_image_path("myimage.jpg", "images", "image_path")</code>

??? ??? ??? ???? ??? ???? ??? ? ?? ?? ? ????. ??? ??? ??? ???? ??? ???????. MySQL? ????? ?? ? ??? ??? ???, ???? ???? ??? ? ????.

? ??? MySQL? ??? ??? ? ????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!