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.
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.
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.
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.
There is much more going on behind WordPress blogs than the average visitor is aware of. In addition to texts, pictures and other graphics, it is primarily the behind-the-scenes aspects like plugins and user settings that make the site what it is. All of these features have to be taken into account when migrating from A to B. Thanks to tools like migration plugins, moving your WordPress blog to a...
MySQL is the most used database management system in the world. This open source software has been available for productive use since 1995 and is generally considered a standard solution for users of relational databases. This could change in the near future. MariaDB, a community-developed fork of MySQL is catching up on its predecessor and is consequently becoming an increasingly attractive...
Over the past few years, Joomla has established itself as one of the most popular content management systems. This is thanks to its extensive basic functions and large number of extensions developed by the Joomla community. Its functions and design modifications give Joomla projects the crucial final flourishes and even enable you to run an online shop on this open source CMS.
MySQL/MariaDB is one of the most popular relational databases. Under Linux, it is easy to install and manage via the terminal. Find out how to install Mysql with this article’s step by step instructions. We will also show you the basic commands so that you can create your first custom database. What are you waiting for?
Open source databases are a much cheaper and often very reliable alternative to the well-known commercial providers. Even large corporations therefore now rely on these free options. But which system is suitable for which purpose? How do open source databases perform in terms of handling large amounts of data? We created a comparison of popular databases.
Learn basic MySQL/MariaDB disaster recovery and preparedness: How to import databases from an exported MySQL dump file.
Provide powerful and reliable service to your clients with a web hosting package from IONOS.
View packages
