Tag: MySQL
In this post you will learn how to get the number of MySQL lines in a database. Getting the number of MySQL rows in one table To get the number of rows per table, you use the COUNT(*) operator...
In MySQL 8.0.16 optimizer has improved again! Comparisons of columns of numeric types with constants are checked and stacked or deleted for invalid values or values that are out of...
MySQL 5.7.11 introduced transparent encryption for InnoDB table space, which included support for table space files. Later, encryption for the shared table space was introduced in MySQL...
This article will show you how to create new databases and tables using SQL commands in a mysql client. It is assumed that this tool is running and connected to the MySQL database...
This is the function MySQL GROUP CONCAT and how it can change the work with query results. Especially if the database is the data source for the application. Database I will use the Sakila...
Relational databases are among the most frequently used databases to date, and therefore SQL skills are mandatory for most positions.In this article with SQL interview questions I will...
It takes 2 actions to determine the size of tables in a database from a command line hosted on a MySQL or MariaDB server:1. Connect to the database server with the command: mysql -u root -p...
Enabling profiling is an affordable way to get an accurate estimate of the time the request has been executed. First you need to enable profiling and call show profiles to get an accurate...
We will consider in detail the process of installing the free edition of MySQL 8 Community on the Windows 10 operating system. What is MySQL? MySQL is a free relational database management...
There are official ratings and other analytical data that show DBMS popularity.Some ratings are based on the frequency of reference in search engine queries, ie, if people are more often looking...
IT departments work with a meager budget. Therefore, cost-cutting will allow the company not only to stay afloat, but also to direct the saved money to development.To use the available budget...
The SQL BETWEEN condition allows you to easily check if the expression is in the range of values (inclusive). It can be used in the SELECT, INSERT, UPDATE or DELETE operator. Syntax for BETWEEN...
MySQL data types - When determining the columns of the table for them, you must specify the data type. Each column must have a data type. The data type determines what values can be stored in a...
Microsoft Windows Server 2012 - After four years of development, on September 4, 2012, Microsoft announced the availability of a new version of Windows Server.Historically, the operating...
The INSERT SQL statement is used to insert one or more records into a table. There are two syntaxes for the INSERT statement depending on whether you are inserting one record or more...
Postgresql vs MySQL: MySQL is the most popular relational DBMS, while PostgreSQL is the most advanced and functional. Functions of DBMS MySQL and PostgreSQL Almost any developer will say that...