Tag: Mysql
-
Upsert data from TXT (“|” pipe delimited text) file to MySQL without programming
Want to upsert data from TXT (“|” pipe delimited text) file to MySQL ? Upsert: inserts rows into a table if they do not already exist, or updates them if they do. Using FileToDB, a native GUI tool, you can upsert data from TXT (“|” pipe delimited text) file to MySQL (MariaDB, Percona) easily and…
-
Upsert a row Into Mysql Table
In Mysql, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. INSERT INTO employees(id, name, hire_date ) VALUES (1, ‘John’, ‘2016-11-29′ ) ON DUPLICATE KEY UPDATE name=’john’, hire_date=’2016-11-29′ In SQL Server, https://www.withdata.com/blog/sql-server/replace-update-or-insert-a-row-into-sql-server-table.html In…
-
Create Excel report from MySQL database
Want to create Excel report from MySQL database? Using MysqlToExcel, you can generate excel report from MySQL easily and fast, no need to program, no need learn VBA, just a few mouse clicks! Support connect to MySQL through SSH tunnel. Here you can download and install MysqlToExcel. Create an Excel report based on MySQL Click…
-
Batch import RTF files into MySQL BLOB without programming
Want to batch import RTF (Rich Text Format) documents into MySQL TEXT (CLOB) or BLOB column? Using MyLobEditor, you can import bulk rtf files into MySQL TEXT (CLOB) or BLOB easily and fast, just a few mouse clicks. Here you can download and install MyLobEditor. Batch import RTF documents to MySQL TEXT (CLOB) column Click…
-
Some ETL (Extract-Transform-Load) tools for MySQL
Withdata Software provide some ETL (Extract-Transform-Load) tools for MySQL: FileToDB Load TXT, CSV, TSV, XML, JSON, Excel, SQL, RDF, INI data to MySQL DBToFile Export MySQL data to TXT, CSV, TSV, XML, JSON, Excel, SQL files DBCopier Copy data between MySQL and other rational databases MongoToDB Ease your MongoDB to MySQL converting work DBBlobEditor Edit…
-
Some data import / export tools for Percona
Withdata Software provide some tools for MySQL, all these tools can work for Percona: See how to use these tools work for Percona: Import XML data into Percona (MySQL) Schedule and automate Percona (MySQL) importing XML data task Import data into Percona (MySQL) from MongoDB exported JSON file Import JSON data into Percona (MySQL) Schedule…
-
Parse RDF file and save to MySQL
Want to parse RDF file and save to MySQL ? Want to schedule and automate this importing task? To import Xml format RDF file (.rdf, .owl) to MySQL (MariaDB, Percona), https://www.withdata.com/blog/rdftomysql/mysql-import-rdf.html To import RDF Turtle file (.ttl, .n3) to MySQL (MariaDB, Percona), https://www.withdata.com/blog/rdftomysql/ttl-to-mysql.html To import RDF N-Triples file (.nt, .ntriples) to MySQL (MariaDB, Percona), https://www.withdata.com/blog/rdftomysql/n-triples-to-mysql.html…
-
How to select N random records from a MySQL table
If you want to select N random records from a MySQL table, you need to change the clause as follows: select * from tableName order by rand() limit N For example, to select 5 random customers in the customers table, you use the following query: select * from customers order by rand() limit 5 Some…
-
Some data import / export tools for MariaDB
Withdata Software provide some tools for MySQL, all these tools can work for MariaDB: See how to use these tools work for MariaDB: Import XML data into MariaDB (MySQL) Schedule and automate MariaDB (MySQL) importing XML data task Import data into MariaDB (MySQL) from MongoDB exported JSON file Import JSON data into MariaDB (MySQL) Schedule…
-
Schedule and automate MySQL exporting to files task
Want to schedule and automate MySQL exporting to files task? Using MyToTxt, you can scheduled exporting MySQL data to files task easily, just a few mouse clicks! Here you can download and install MyToTxt. Schedule and automate MySQL exporting to files task 1. Select and run a task from follow list: Export data from multiple…