Want to import data from CSV file to MySQL via Command Line Interface (CLI) on Linux (Ubuntu/RedHat/CentOS…)? Using my-cmd, a Command Line Interface (CLI) client for MySQL, you can import data from CSV file to MySQL (MariaDB, Percona) easily and fast. Direct Interaction or Scripting ... Read more
Tag Archives: Mysql
Import data from CSV to MySQL via command line on Windows
Want to import data from CSV file to MySQL via Command Line Interface (CLI) on Windows? Using my-cmd, a Command Line Interface (CLI) client for MySQL, you can import data from CSV file to MySQL (MariaDB, Percona) easily and fast. Direct Interaction or Scripting and Automation. No need to ... Read more
Batch update MySQL table TEXT data from files
Want to batch update MySQL TEXT (CLOB) data from files ? Try Withdata DBBlobEditor, a MySQL TEXT (CLOB) editor, Bulk update MySQL TEXT (CLOB) data from files, East and Fast. Can run in GUI mode, Step by step, Just a few mouse clicks. Can run in Command line, for Scheduled Tasks and ... Read more
Store RTF in MySQL TEXT
RTF(Rich Text Format) can be stored as MySQL TEXT data. 1. MySQL TEXT Type Overview MySQL offers multi-level TEXT types: TINYTEXT (255B), TEXT (64KB), MEDIUMTEXT (16MB), LONGTEXT (4GB) MEDIUMTEXT/LONGTEXT are recommended for RTF storage (covers most scenarios). 2. Pure SQL Implementation ... Read more
Store JSON in MySQL TEXT
JSON can be stored as MySQL TEXT data. DBBlobEditor can help you to store JSON as MySQL TEXT data: Batch import JSON files into MySQL TEXT Batch export MySQL TEXT to JSON files ... Read more
Store XML in MySQL TEXT
XML can be stored as MySQL TEXT data. DBBlobEditor can help you to store XML as MySQL TEXT data: Batch import XML files into MySQL TEXT Batch export MySQL TEXT to XML files ... Read more
MySQL TEXT
MySQL doesn’t have a native CLOB (Character Large Object) data type exactly like some other databases such as Oracle. MySQL offers the TEXT family of data types, which can be considered similar to CLOB. The LONGTEXT type can store up to 4GB of text data. Detailed overview of TEXT data type ... Read more
Store Excel spreadsheets in MySQL BLOB
Excel spreadsheets can be stored as MySQL BLOB data. DBBlobEditor can help you to store Excel spreadsheets as MySQL BLOB data: Batch import excel files into MySQL BLOB Batch export MySQL BLOB to EXCEL files ... Read more
Store Word documents in MySQL BLOB
Word documents can be stored as MySQL BLOB data. DBBlobEditor can help you to store Word documents as MySQL BLOB data: Batch import Word files into MySQL BLOB Batch export MySQL BLOB to Word files ... Read more
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 ... Read more