Ritika

In this article, we will see how to add comments to columns while CREATING a table and using the ALTER statement. Comments are used to provide some additional information that helps understand the column’s usage and build an overall understanding of the table usage. Table of Contents:- Add comments to MySQL columns while table creation […]

This article will be looking into how to skip the first 10 results from a query result and return the remaining rows using different ways. Table of Contents: Skip first 10 results from MYSQL query using id key Skip first 10 results from MYSQL query using subquery Skip first 10 results from MYSQL query using

Many times different time zones can create some confusion among the developers. Therefore, there is a need to check the current time zone of MySQL in a lot of cases. In this article, we will learn how to check the current time zone of MySQL. The time zone of MySQL can be retrieved using the

This article will see how to get the last inserted id of a MySQL table using 4 different ways. Table of Contents How to get last inserted id of a MySQL table using max() function How to get last inserted id of a MySQL table using ORDER BY DESC How to get last inserted id

This article will see how to DROP multiple columns from a MySQL table with a single ALTER statement. Multiple columns can be deleted from the MySQL table using a single ALTER statement by separating the DROP keyword and column name list with a comma. SYNTAX:- EXAMPLE:- Let us get started by preparing the sample data. We will

This article will look into getting all the MySQL tables with specific column names from a database schema. We will be illustrating the concept using various examples. Let us get started by preparing the sample data. We will be creating three tables, sale_details, sale_person_designation, and sale_city. Action Output:- The above image shows that all the three

In this article, we will see how to check the MySQL version in different ways. Table of Contents:- MySQL check version query MySQL check version mac MySQL check version workbench MySQL check version query In this section, we will be looking into how to check the current version of your MySQL server using a query.

This article will discuss how to insert multiple rows in a MySQL table. Let us get started by making the sample data. We will be creating a table named employee_details. Action Output:- We will now insert multiple rows into the employee_details table but let us first look into the syntax. Syntax:- name_of_your_table: is the table for inserting

This article will add a primary key to multiple columns while creating a table and existing tables with data. We will be illustrating the concept using different examples. Table of Contents:- Add primary key multiple columns to new table Add primary key multiple columns to existing table with data and existing primary key Primary keys

In this article, we will discuss why Error 1364 occurs and how to resolve it.  Table of Contents Introduction Error code 1364 resolution with AUTO_INCREMENT Error code 1364 resolution with DEFAULT value Introduction MySQL server throws the Error 1364 if the query or statement tries to insert a row without a value for a particular column defined as NOT