Mysql

Error Code: 1364 [Solved] Field doesn’t have a default value

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 …

Error Code: 1364 [Solved] Field doesn’t have a default value Read More »

MySQL Update with Inner Join

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 …

MySQL Update with Inner Join Read More »

Scroll to Top