Mysql

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 […]

This article will look into adding a primary key to an existing table with and without data. We will be illustrating the concept using different examples. Table of Contents:- MySQL add primary key to existing empty table MySQL add primary key to existing table with data Let us get started by preparing the sample data.

This article will look into how to get the data from MySQL tables where a column contains a particular string. We will be illustrating the concept using various examples and different methods. Table of Contents:- MySQL query string contains using ‘%’ wildcard MySQL query string contains using LOCATE MySQL query string contains using INSTR Let

This article will see how to get rows from a MySQL table based on the string length() function. We will be illustrating the concept with various examples. length(str) function in MySQL returns the length of the string(str) passed in as parameter. Let us get started by creating the sample data. We will be creating a table, employee_name_details,

This article will see how to update multiple columns of a MySQL table in a single query. We will be illustrating the concept with various examples. Table of Contents:- MySQL update set multiple columns for a single row MySQL update set multiple columns for multiple rows Let us get started by making the sample data.

This article will see how to update multiple rows with different values of a MySQL table in a single query. We will be illustrating the concept with various examples. Let us get started by making the sample data. We will be creating a table, sale_person_data, followed by inserting a few rows to it. Execute select *

This article will update columns in a MySQL table with values from another table using different methods. Table of Contents:- Update column with value from another table using JOIN Update column with value from another table using INNER QUERY Update column with value from another table using CURSOR Let us get started by creating the

This article will look into how to update rows to a MySQL table using the INNER JOINs. INNER JOINs help us retrieve records from more than one table having a condition satisfied by both and are logically related to each other. Let us get started by making the sample data. We will be creating two tables, employee_designation and employee_rating, followed by inserting a

This article will look into how to insert rows to a MySQL table using the JOINs. JOINs help us retrieve records from more than one table that is logically related to each other. Let us get started by making the sample data. We will be creating three tables employee_designation, employee_rating, and employee_details, followed by inserting a few rows

This article will look into how to select * from a table except for one column. We will be discussing two ways to get all the columns of a table except one. Table of Contents:- Select * except one column from a MySQL table using temporary tables Select * except one column from a MySQL