Withdata Software

Tag: Mysql

  • How to Store PDF Files in MySQL BLOB Fields: A Comprehensive Guide for Developers & DBAs

    PDF files are ubiquitous in modern business workflows—from invoices and contracts to reports and documentation. Storing these files directly in a MySQL database (rather than on a file system) offers unique advantages: centralized data management, seamless backup/restore workflows, and tight integration with relational data. However, storing PDFs in MySQL BLOB (Binary Large Object) fields is…

  • Store video files in MySQL BLOB

    Video files can be stored as MySQL BLOB data. 1. Core Compatible Type & MySQL BLOB Fundamentals MySQL supports four BLOB subtypes tailored for storing binary data of different sizes, making it flexible for video storage across various formats (AVI, MP4, WMV, MOV, MPEG, FLV, etc.). For mainstream video files, LONGBLOB (max 4GB) is the…

  • Store audio files in MySQL BLOB

    Audio (MP3, WAV, Ogg, WMA, M4A, AAC, etc.) files can be stored as MySQL BLOB data. 1. Key Overview MySQL offers multi-level BLOB types (TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB) for storing mp3/wav/ogg audio files (up to 4 GB max with LONGBLOB). Storing audio as BLOB integrates audio data with business records (e.g., voice messages linked to…

  • Store images in MySQL BLOB

    MySQL BLOB Type Features MySQL provides 4 graded BLOB types for different image sizes (all store binary data) TINYBLOB: Up to 255 bytes (ideal for small icons/thumbnails) BLOB: Up to 65,535 bytes (~64KB, for small images) MEDIUMBLOB: Up to 16,777,215 bytes (~16MB, for medium-resolution photos) LONGBLOB: Up to 4,294,967,295 bytes (~4GB, for high-resolution/large images) All…

  • MySQL BLOB

    In MySQL, the BLOB (Binary Large Object) data types are used to store large amounts of binary data, such as images, audio, and video files. MySQL provides four different BLOB data types, each with different maximum storage capacities: TINYBLOB: Can store up to 255 bytes of binary data. BLOB: Can store up to 65,535 bytes…

  • Upsert data from CSV to MySQL table via command line on MacOS

    Want to upsert data from CSV file to existing MySQL table via command line on MacOS? Using my-cmd, a Command-Line client for MySQL, you can upsert(merge) CSV/TSV/TXT data to MySQL (MariaDB, Percona) table easily and fast. Support Windows, Linux, and MacOS. Download my-cmd MacOS version my-cmd.darwin-amd64.zip my-cmd.darwin-arm64.zip No need to install MySQL client library. Convenient…

  • Upsert data from CSV to MySQL table via command line on Linux

    Want to upsert data from CSV file to existing MySQL table via command line on Linux (Ubuntu/RedHat/CentOS…)? Using my-cmd, a Command-Line client for MySQL, you can upsert(merge) CSV/TSV/TXT data to MySQL (MariaDB, Percona) table easily and fast. Support Windows, Linux, and MacOS. Download my-cmd Linux version my-cmd.linux-386.zip my-cmd.linux-amd64.zip my-cmd.linux-arm64.zip No need to install MySQL client…

  • Upsert data from CSV to MySQL table via command line on Windows

    Want to upsert data from CSV file to existing MySQL table via command line on Windows? Using my-cmd, a Command-Line client for MySQL, you can upsert(merge) CSV/TSV/TXT data to MySQL (MariaDB, Percona) table easily and fast. Support Windows, Linux, and MacOS. Download my-cmd Windows version my-cmd.windows-386.zip my-cmd.windows-amd64.zip No need to install MySQL client library. Convenient…

  • Update MySQL table through CSV via command line on MacOS

    Want to import CSV to update rows in MySQL table via command line on MacOS? Using my-cmd, a Command-Line client for MySQL, you can import CSV/TSV/TXT data to update existing MySQL (MariaDB, Percona) table easily and fast. Support Windows, Linux, and MacOS. Download my-cmd MacOS version my-cmd.darwin-amd64.zip my-cmd.darwin-arm64.zip No need to install MySQL client library.…

  • Update MySQL table through CSV via command line on Linux

    Want to import CSV to update rows in MySQL table via command line on Linux (Ubuntu/RedHat/CentOS…)? Using my-cmd, a Command-Line client for MySQL, you can import CSV/TSV/TXT data to update existing MySQL (MariaDB, Percona) table easily and fast. Support Windows, Linux, and MacOS. Download my-cmd Linux version my-cmd.linux-386.zip my-cmd.linux-amd64.zip my-cmd.linux-arm64.zip No need to install MySQL…