Ritika

In this article, we will see how to delete the rows from MySQL tables associated with joins particularly, Syntax Delete one table with join in Example1 Delete multiple tables with join in Example2 Delete with join for specific conditions in Example3 Generally, DELETE with JOINS is used when we want to delete rows from one […]

This article will see how to remove the whitespaces from all the column values in a MySQL column. Table of Contents Remove all the whitespaces from the entire column values Remove the whitespaces from the start or end of the entire column values Let us get started by making the sample data table named student_name_details

This article will see how to remove characters from a column value of string datatype in a MySQL table. Table of Contents Remove characters from string using REPLACE() Remove characters from string using TRIM() Remove characters from string using SUBSTRING() Let us get started by making the sample table student_enroll_data and inserting a few rows

This article will see how to increase the size of a VARCHAR datatype column for a MySQL table. Also, we will ensure that we do not lose or break the column’s existing data. Table of Content Syntax ALTER statement MODIFY to increase column size ALTER statement CHANGE to increase column size Let us get started

This article will see how to change columns’ order in a MySQL table without losing the data already present in the column. Table of Contents Syntax for MySQL change column order MySQL change column order AFTER MySQL make column FIRST Using CHANGE clause to change column order of a table in MysQL Let us get

This article will see how to convert the column type to VARCHAR without losing the data. Table of Contents: Change column type to VARCHAR without losing data : MODIFY clause Change column type to VARCHAR without losing data : CHANGE clause We will get started by creating a sample table student_enroll_data. Let us insert some

In this article, we will see how to rename a column in a MySQL table. Table of Contents MySQL: Rename the column MySQL change column name without losing the data Let us get started by making the sample data. We will be creating a table named student_enroll_data. Action Output:- As we can see in image_1, table

This article will see how to change or modify the datatype of a column in MySQL. Table of Contents Change datatype of a column without losing data: MODIFY Change datatype of a column using Modify : Syntax Change datatype of a column using Modify: Example Change datatype of a column without losing data: CHANGE Change

In this article, we will discuss why Error 1264 occurs and how to resolve it.  Table of Contents Introduction Error code 1264. out of range value for column at row 1 Error code 1264. out of range value for column decimal Introduction MySQL server throws the error 1264 if the MySQL query or statement stores a value

There is often a requirement to loop through rows of a MySQL table and process the data from each row. In this article, we will be doing similar operations to understand better how to loop through rows of a table. Table of Contents: Introduction MySQL loop through rows and INSERT MySQL loop through rows to