Tech Library For Developers
In this post, we will explore some SQL query return data from multiple tables which we can perform using join in Mysql, and based on the common columns we can retrieve the data from multiple tables, So for the same we have taken an example below and performed the desired operation. Return Data From Multiple … Read more
In this post, we will learn the difference between INSERT IGNORE” vs “INSERT ON DUPLICATE KEY UPDATE” where both of them are used for inserting the data in a table with a slit difference that is in case of insert ignore we ignore the record which violates the rule or contain the table, for example, … Read more
In this post, we will learn how to SQL split values to multiple rows which we can perform using the union operator and the select statement of MySQL. For the same, we have given an example below. Use Of Union As we know in SQL, you can split value in a column into multiple rows … Read more
In this post, we will learn How can I do ‘insert if not exists in MySQL and update if exist where for data or record to add new if it does not exist we can perform using insert into, Whereas we can make changes in existing data or we can update the existing data by … Read more
In this post, we will learn How to do a regular expression replacement in MySQL Where regexp replaces () is used to replace a pattern in a string with another string using a regular expression which we will see as an example here. Regular Expression Replacement For replacing a pattern in a string with another … Read more
