Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
MySQL Articles
Page 11 of 355
How to Use Multiple Databases with docker-compose?
Introduction Docker is a popular platform for deploying and running applications in a containerized environment. It provides an efficient way to package, distribute and run applications with all their dependencies. One of main advantages of using Docker is that it enables use of multiple databases in an efficient way using docker-compose. Docker-compose is a tool for defining and running multi-container Docker applications. It allows you to define configuration of different containers in a single YAML file, which can be used to start, stop and manage containers. In this article, we will discuss how to use multiple databases with Docker-compose. Prerequisites ...
Read MoreHow to format number to 2 decimal places in MySQL?
You can use TRUNCATE() function from MySQL to format number to 2 decimal places. The syntax is as follows −SELECT TRUNCATE(yourColumnName, 2) as anyVariableName from yourTableName;To understand the above syntax, let us first create a table. The query to create a table is as follows −mysql> create table FormatNumberTwoDecimalPlace -> ( -> Number float -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into FormatNumberTwoDecimalPlace values(123.456); Query OK, 1 row affected (0.13 sec) mysql> insert into FormatNumberTwoDecimalPlace values(1.6789); Query OK, 1 ...
Read MoreQuery Statistics in MySQL
The important statistics collected for a performed query, including time, temporary tables, indexes, joins, and more, are gathered in the Query Stats SQL editor results tab (see the following two figures). Requirements Enabled query, and collect performance schema statistics. The performance_schema has statement instrumentation enabled. SQL Editor: Query Stats Visual Explain Plan By utilizing the additional data included in the enhanced JSON format, the visual explain feature creates and presents a visual depiction of the MySQL EXPLAIN statement. All EXPLAIN formats, including the standard format, the raw extended JSON, and the visual query plan, are available in ...
Read MorePerformance Report Controls in Mysql Workbench
The controls listed below can be used to examine and export performance report data (see the following figure) − Export − Export all entries from the current performance report, including all queries and values, together with any associated data (including column headings). opens an export file dialogue. Copy Selected − Copies a single entry from the current performance report together with any related data (and column titles). the system's clipboard is saved. a case in point Query Copy − This function copies the SQL statement that produced the performance report. the system clipboard is saved. Refresh − The performance ...
Read MoreHow to Display System Variables of MySQL Server?
The MySQL system variable values are displayed using SHOW VARIABLES. There is no privilege required for this statement. Only the ability to connect to the server is necessary. Syntax SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] A LIKE clause, if present, tells SHOW VARIABLES which variable names to match. To choose rows based on broader criteria, use a WHERE clause. An optional global or session variable scope modification is accepted by SHOW VARIABLES − The statement displays values for global system variables when GLOBAL is used as a modifier. For new connections ...
Read MoreHow do I disable Strict Mode in MySQL?
The handling of missing or incorrect values in queries that change the data is governed by MySQL Strict Mode. This contains the CREATE TABLE, UPDATE, and INSERT statements. When attempting to process the query with MySQL Strict Mode enabled, which is the default setting, invalid or missing data may result in warnings or failures. When Strict Mode is turned off, the identical query would have its missing or incorrect data modified and would result in a straightforward warning. This could appear to be the desired outcome, but with Strict Mode turned off, certain activities might have unanticipated effects. For instance, ...
Read MoreCollecting MySQL Statistics and Metrics
In this article, we are going to learn about collecting Mysql statistics and Metrics. Performance Dashboard View statistics about server performance in a dashboard. Open a query tab, choose the Management tab, and then click Dashboard in the Performance section of the Navigator sidebar to display the dashboard. The informational structure of the Administration - Dashboard tab is depicted in the following image. Performance: Dashboard Network Status This displays data on network traffic that the MySQL server has transmitted and received via client connections. The incoming network traffic, outgoing network traffic, and client connections are examples of data ...
Read MoreHow to Convert MySQL Table Field Type from BLOB to JSON?
Introduction If you have a table in MySQL with a BLOB field that you would like to convert to a JSON field, it can be done by performing a series of ALTER TABLE statements. The process involves creating a new column with the desired data type (JSON), copying the data from the old column to the new column, dropping the old column, and renaming the new column to the original column name. It's important to note that BLOB fields are used to store binary data, and JSON is a text-based format for representing data. In order to convert a BLOB ...
Read MoreHow to Use the mysql Client and Related Utilities in Linux
Introduction MySQL is an open source relational database management system (RDBMS) that has been popular for over twenty years. It is widely used on Linux systems for both web server solutions and standalone applications. This article will provide an overview of the most commonly used MySQL utilities, including mysql and mysqladmin, along with some examples on how to use them. It's worth noting that the explanations in this article also apply to MariaDB, a popular fork of MySQL created by the original developers, due to concerns that MySQL may not remain open source and intend to maintain high compatibility with ...
Read MoreChallenges of NoSQL
NoSQL databases, which stand for "not only SQL, " are a popular alternative to traditional relational databases. They are designed to handle large amounts of unstructured or semi-structured data, and are often used for big data and real-time web applications. However, like any technology, NoSQL databases come with their own set of challenges. Challenges of NoSQL Data modeling and schema design One of the biggest challenges with NoSQL databases is data modeling and schema design. Unlike relational databases, which have a well-defined schema and a fixed set of tables, NoSQL databases often do not have a fixed schema. This can ...
Read More