MySQL

How does data backup work for databases?
How to backup databases
  • Security

Backing up your data is a popular option for securing your database. In order to create backup copies, you need additional hardware and to install a suitable backup structure. How do you secure your own network and web server against attacks and proceed to protect your databases?

How to backup databases
What is MySQL
What is MySQL? Definition and functions
  • Know-how

Databases are required for almost every web application. Whether you want to manage and store customer or employee data, there’s hardly any way around a database. And with MySQL, creating databases is super easy. Let’s take a closer look at what MySQL is, its features, and application areas.

What is MySQL? Definition and functions
MySQL version
How to check and update your MySQL version
  • Technical matters

Your database management system is not always kept up to date automatically. If this is the case, you should definitely perform the necessary steps manually for the sake of security. We’ll explain how you can check your MySQL version and what steps you can take to bring it up to date.

How to check and update your MySQL version
MySQL vs. MongoDB
MySQL vs. MongoDB, which database is better?
  • Technical matters

Would you rather relational database management or a flexible NoSQL solution? When choosing the right tool for your data, it’s worth comparing MongoDB vs. MySQL. We’ll show you how the two software solutions differ from each other, what advantages and disadvantages they offer and who could win the MySQL vs. MongoDB duel.

MySQL vs. MongoDB, which database is better?
SQL injection: Fundamentals and safeguards
SQL Injection
  • Security

There are daily reports on how security gaps in applications are exploited – because hardly a day goes by without a new gap being discovered or a known gap being closed. One attack method, which has always been based on exploiting such weak points, is called SQL injection. But what is actually hidden behind the malicious database exploitation and how can you protect your database system from it?

SQL Injection
MySQL REPLACE
How to replace substrings with MySQL REPLACE
  • Technical matters

Even when you’re careful, spelling errors in a table can’t always be avoided. Outdated information can also creep in. The solution is MySQL REPLACE. This command lets you to replace substrings in a string and quickly fix errors. We’ll show you how it works and how MySQL REPLACE is structured.

How to replace substrings with MySQL REPLACE
MySQL DELETE
How to delete rows from a table with MySQL DELETE
  • Technical matters

With MySQL DELETE you can delete one, several, or all rows from a table. Once you’ve mastered the command, you’ll be able to always keep your table up to date. We’ll show you how MySQL DELETE works, when to use it, and what options it offers.

How to delete rows from a table with MySQL DELETE
MySQL DATEDIFF
How to calculate date differences with MySQL DATEDIFF
  • Technical matters

MySQL knows several time functions. A particularly useful command is MySQL DATEDIFF. This function calculates and outputs the time between two dates. Using practical examples, we’ll show you how MySQL DATEDIFF works, how the function is structured, and what you can use it for.

How to calculate date differences with MySQL DATEDIFF
MySQL DATE
How to extract a date with MySQL DATE
  • Technical matters

Especially in accounting, it can be very useful to extract a date from a time specification. The command that you’ll need for this is MySQL DATE. Find out what MySQL DATE is, how to use the function, and what its advantages are. We’ll also explore related commands and alternative date formats.

How to extract a date with MySQL DATE
MySQL CONCAT
How to connect strings with MySQL CONCAT
  • Technical matters

If you want to combine several strings into one unit, then MySQL CONCAT is the right command. Using simple examples, we’ll show you what MySQL CONCAT is, how the command is written, and what you can use it for. We’ll also introduce the MySQL CONCAT_WS variant with examples.

How to connect strings with MySQL CONCAT