How to insert a file in MySQL database?

by

File size by MySQL type:

  • TINYBLOB 255 bytes = 0.000255 Mb
  • BLOB 65535 bytes = 0.0655 Mb
  • MEDIUMBLOB 16777215 bytes = 16.78 Mb
  • LONGBLOB 4294967295 bytes = 4294.97 Mb = 4.295 Gb

Yet, in most cases, I would NOT recommend storing big blobs of bytes in database, even if it supports it, because it will increase overall database size & may cause real performance issues. You can read more on topic here. Many databases that care about consistent performance won’t even let you do such thing. Like e.g. AWS DynamoDB, which is known to perform extremely well at any scale, limits single item record to 400KB. MongoDB does allow 16MB, which is also already too much, imo. MySQL allows all 4GB if you wish. But again, think twice before doing that. The case where you may be OK to store big blob of data with these column types would be – you have small traffic database and you just want to save all the stuff in one place for faster development. Like internal system in a small company.

More Related Contents:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Error Code: 2013. Lost connection to MySQL server during query
  3. MySQL Trigger after update only if row has changed
  4. difference between primary key and unique key
  5. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  6. MySQL Query to select data from last week?
  7. Using an Alias in SQL Calculations
  8. Can a table field contain a hyphen?
  9. Adding a leading zero to some values in column in MySQL
  10. How do I add a custom CHECK constraint on a MySQL table?
  11. View’s SELECT contains a subquery in the FROM clause
  12. Check for x consecutive days – given timestamps in database
  13. MySQL Insert Into from one Database in another
  14. How do I get the ID of multiple inserted rows in MySQL?
  15. How to insert data to MySQL with auto-incremented column(field)?
  16. Case statement in MySQL
  17. Replace Into Query Syntax
  18. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  19. Laravel join with 3 Tables
  20. Remove special characters from a database field
  21. Difference between two table structure
  22. MySQL query, MAX() + GROUP BY
  23. How to get multiple records against one record based on relation?
  24. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  25. Foreign key constraints: When to use ON UPDATE and ON DELETE
  26. How to use a user variables in MySQL LIKE clause?
  27. How to speed up sql queries ? Indexes?
  28. MySQL: Computed Column
  29. Optimistic locking in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment