MySQL

How to check the MySQL version

How to check the 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 the MySQL version
How to use MySQL DATE

How to use 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 use MySQL DATE
MySQL vs. MongoDB

MySQL vs. MongoDB

  • 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
How to delete rows from a table with 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
How to import a MySQL/MariaDB Database

How to import a MySQL/MariaDB Database

  • Technical matters

Learn basic MySQL/MariaDB disaster recovery and preparedness: How to import databases from an exported MySQL dump file.

How to import a MySQL/MariaDB Database
How to use the MySQL DATEDIFF Function

How to use the MySQL DATEDIFF Function

  • 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 use the MySQL DATEDIFF Function
Joomla – The open source CMS

Joomla – The open source CMS

  • CMS

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.

Joomla – The open source CMS
SQL JOIN

SQL JOIN

  • Technical matters

A major strength of the relational database model is that information is stored in separate database tables structured according to semantic relationships. This concept, known as normalization, is the basis for data storage that is as redundancy-free as possible, but requires a mechanism with which data from different tables can be merged for queries. The different JOIN types provide users with…

SQL JOIN
Alchemy CMS

Alchemy CMS

  • CMS

While most content management systems are based on the PHP scripting language, Alchemy CMS uses a less common but more dynamic programming language: Ruby. There are also countless add-ons available from Ruby on Rails that can help to extend your web framework to create complex projects like company websites or online shops. Find out what makes this intuitive CMS a good bet for beginners.

Alchemy CMS
We use cookies on our website to provide you with the best possible user experience. By continuing to use our website or services, you agree to their use. More Information.