This Python 3 script is designed to take CSV file data pasted into the csv_data variable and generate SQL insert statements that can be used to insert the data into a MySQL database. The script is easy to use and can save you a lot of time when working with large amounts of data.
2023-05-08 (first published: 2023-05-05)
5,829 reads
In this blog, we’re going to walk you through how to solve the issues posed by that concern. At the end of the article, we’ll also walk you through some DDL operations to load test data.
2023-03-15
mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because it’s very basic and quite powerful – mysqldump database backup tool is command line-based, very simple and very straightforward to use. As far as MySQL or its flavors (MariaDB and Percona Server) are concerned, this command line-based tool is one of the top choices for junior and senior database engineers across the world alike.
2022-11-09
In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that fall into the category of data manipulation language (DML), a subset of statements used to query and modify data. Another DML statement is the INSERT statement, which lets you add data to MySQL tables, both permanent and temporary. This article covers the INSERT statement and the different ways you can use it to add data.
2022-11-02
Use SELECT statements to query a MySQL database. In this article, Robert Sheldon explains how.
2022-09-07
There’s more to security in MySQL than user account privileges. In this article, Lukas Vileikis explains the other components of MySQL security
2022-08-01
There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and user privileges.
2022-06-27
Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.
2022-06-08
Stored functions in MySQL return a scalar value and can be used in a SQL statement. In this article, Robert Sheldon explains how to create and use a MySQL stored function.
2022-06-06
Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL.
2022-05-16
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers