This tutorial explains about MySQL UPSERT command with the help of simple examples. An upsert is a smart operation that turns into an INSERT or UPDATE whichever is applicable. Also, it is an atomic transaction, which means completed in a single step. Let’s understand – If a record is new, then UPSERT triggers an INSERT. [...]

The post MySQL UPSERT | INSERT or UPDATE appeared first on TechBeamers.

This tutorial explains about MySQL UPSERT command with the help of simple examples. An upsert is a smart operation that turns into INSERT or UPDATE whichever is applicable. Also, it is an atomic transaction, which means complete in a single step. Let’s understand – If a record is new, then UPSERT triggers an INSERT. But, […]

The post MySQL UPSERT | INSERT or UPDATE Whichever is Applicable appeared first on TechBeamers.

This tutorial explains MySQL DATE data type and walks you through some of the standard date functions. It will help you use and handle dates more efficiently with MySQL. MySQL DATE data type The DATE is a temporal data type for accessing and setting dates by applications. It accepts DATE values only in YYYY-MM-DD format. [...]

The post MySQL Date and Date Functions appeared first on TechBeamers.

This tutorial explains about MySQL DATE data type and walks you through some of the standard date functions. It will help you use and handle dates more efficiently with MySQL. MySQL DATE is a temporal data type for accessing and setting dates by applications. It accepts DATE values only in YYYY-MM-DD format. And MySQL doesn’t […]

The post MySQL Date and Date Functions appeared first on TechBeamers.

This tutorial explains MySQL LOWER()/LCASE() functions which convert the upper case characters of a string to the LOWER case. We’ll describe the functioning of this method with the help of simple examples. 1. LOWER()/LCASE() Syntax 2. LOWER()/LCASE() to convert text to lower case 3. LOWER()/LCASE() on table data 4. LOWER()/LCASE() on binary text Let’s now [...]

The post MySQL LOWER() and LCASE() Functions Explained appeared first on TechBeamers.

This tutorial explains MySQL LOWER()/LCASE() functions which convert the upper case characters of a string to the LOWER case. We’ll describe the functioning of this method with the help of simple examples. 1. LOWER()/LCASE() Syntax 2. LOWER()/LCASE() to convert text to lower case 3. LOWER()/LCASE() on table data 4. LOWER()/LCASE() on binary text Let’s now […]

The post MySQL LOWER() and LCASE() Functions Explained appeared first on TechBeamers.

This tutorial explains MySQL UPPER()/UCASE() functions which convert the lower case characters of a string to upper case. We’ll describe the functioning of this method with the help of simple examples. 1. UPPER()/UCASE() Syntax 2. UPPER()/UCASE() to convert text to upper case 3. UPPER()/UCASE() on table data 4. UPPER()/UCASE() on binary text Let’s now go through each of the section one by one. MySQL UPPER()/UCASE() Functions As stated initially, UPPER() is a built-in MySQL function which changes a string value to upper case. So, let’s now see the details and check out how can we use it. Syntax Below is

The post MySQL UPPER() and UCASE() Functions Explained appeared first on Learn Programming and Software Testing.

The ability to import data in parallel is now a feature of the new MySQL Shell.  And you can run it from a command line instead of from within an interactive shell.

How Does It Work?
The importTable utility, new on MySQL Shell 8.0.17,  analyzes the input file, divides that file into chunks, and then uploads that data using parallel connections.  This is much faster than the LOAD DATA statement. You get the ability to define how the data is delimited as far a field and lines are defined.  And it works on DOS CSVs, Unix CSVs, TSVs, and JSON if that JSON is in one document per line mode. You also can adjust the number of threads, number of bytes sent per each chunk, and the maximum rate of data transfer per thread so you can balance the load on the network and the speed of data …

Some time ago, I was building a new MySQL DB server (5.7.25) and like all DBAs, I have a template of my.cnf that I use for the new instances after changing a few variables based on the instance resources, replication … etc. I had MySQL installed but I struggled on having the service started!

MySQL failed to start, no errors were printed at all in the MySQL error log – or the log was not created from the first place – even no errors in the system log and I had no clue what was going on!

After some digging in, I found the bad guy! The variable secure_file_priv referred to a directory that didn’t exist. When I had the directory created, everything was fine and the service started.

I tried to repeat the same scenario in MySQL 8 and it was much better. The error log indicated the root cause of the issue as below:
2019-03-25T23:39:59.810992Z 0 [ERROR] [MY-010095] [Server] Failed …