Tag: MySQL
Learn how to – Install MariaDB 10.6 on Ubuntu 18.04 and CentOS 7
Learn how to – Install MariaDB 10.6 on Ubuntu 18.04 and CentOS 7. This guide is to help you get MariaDB 10.6 running on CentOS 7 / Install MariaDB 10.6 on Ubuntu 18.04 server?. As of this writing, the latest stable release of MariaDB is 10.6. The default version of MariaDB installed on CentOS 7 is …
Learn how to – Install MariaDB 10.6 on Ubuntu 18.04 and CentOS 7Read More
Learn how to – How to Reset RDS Master User Password on AWS
Learn how to – How to Reset RDS Master User Password on AWS. The Amazon RDS service allows you to reset your database instance master user password using their API. In this guide, I’ll walk you through the steps to reset RDS Master User Password. If you don’t remember your AWS RDS instance master username, it …
Learn how to – How to Reset RDS Master User Password on AWSRead More
Learn how to – Find Database Sizes in MySQL/MariaDB Database Server
Learn how to – Find Database Sizes in MySQL/MariaDB Database Server. Are you trying to find which databases in your MySQL/MariaDB database server has large tablespace?. People have varying reasons for finding database sizes in MySQL/MariaDB. It could be for data truncation, data archiving, table optimizations among many other applications. In this how-to guide, I’ll …
Learn how to – Find Database Sizes in MySQL/MariaDB Database ServerRead More
Learn how to – Install MyWebSQL on RHEL 8 / CentOS 8
Learn how to – Install MyWebSQL on RHEL 8 / CentOS 8. How do I install MyWebSQL on RHEL 8 / CentOS 8?. MyWebSQL is an open source web-based WYSIWYG Database client written in PHP for performing Database operations. It offers features similar to those of phpMyAdmin. MyWebSQL has support for MySQL, PostgreSQL and SQLite …
Learn how to – Install MyWebSQL on RHEL 8 / CentOS 8Read More
MYSQL: CREATE A DATABASE
A database is a defined collection of logical, meaningful data, for example, a database of employees to store the name, addresses, employee numbers, and other relevant records of employee information. In this article, we will be discussing about creating databases in MYSQL, particularly the following topics:– MYSQL CREATE DATABASE – SYNTAX and EXAMPLE MYSQL CREATE …
MYSQL: UNION – tutorial with examples
We can use the UNION clause in MYSQL when we want to combine the results from multiple select queries and display the combined result in the output. In this article we will be discussing below topics, MYSQL: UNION QUERY SYNTAX MYSQL: UNION QUERY EXAMPLE MYSQL: UNION RESTRICTIONS MYSQL: UNION DISTINCT MYSQL: UNION ALL MYSQL: UNION …
MYSQL INSERT INTO
INSERT keyword in MYSQL is used to add the data to tables, specifically new rows. In this article, we will be talking about how to insert records in the tables. Table of Contents MYSQL INSERT INTO TABLE INSERTING MULTIPLE ROWS IN MYSQL MYSQL INSERT INTO SPECIFIC COLUMNS MYSQL INSERT INTO TABLE This is the most …
MYSQL INSERT WITH SELECT
In previous articles we learned to insert data into a table, feel free to checkout the article MYSQL INSERT INTO. This article will discuss how to insert data into a table by selecting the data from some other source, for example, another table. Table of Contents Advertisements MYSQL INSERT FROM SELECT: SINGLE TABLE MYSQL INSERT …
MySQL select row with max value
A lot of times, we need to get the rows that have maximum value in a column. There can be different requirements around the same, and hence there are various solutions. In this article, we will look into how to select only rows with maximum value on a column using, Max() function Left JOIN MySQL …
MySQL select row with max value for each group
While working with databases, we get many situations where we need to get records with max value for each group of grouped SQL results. While there are many solutions to it, we will be discussing a few of them. Table of Contents GROUP BY : MySQL select row with max value JOIN : MySQL select …