How to automate create Function App with Blob Trigger and Sendgrid Notification through Azure Arm Template and deploy
In previous post (Trigger Email on Blob Trigger), we saw how we can create such…
April 25, 2020
In a mysql table, I wanted to replace the hostname of the image URLs. And, it will be an update statement which will update all such records.
update `TABLE_NAME` set COLUMN_NAME = REPLACE (COLUMN_NAME, 'STRING_TO_SEARCH',
'STRING_TO_REPLACE_WITH') WHERE COLUMN_NAME like '%STRING_TO_SEARCH%';
In above query:
Note that in above query, where clause is suppose to filter out the target set of strings on which you want to work upon.
Now, if you notice that since REPLACE function will anyway has to do the search operation, what is the need of where clause. In reality, it is actually slowing down the system. Its not optimized. You can simply remove the where clause, and do something like:
update `TABLE_NAME` set COLUMN_NAME = REPLACE (COLUMN_NAME, 'STRING_TO_SEARCH',
'STRING_TO_REPLACE_WITH')
In previous post (Trigger Email on Blob Trigger), we saw how we can create such…
Introduction I had to develop a small automation to query some old mysql data…
Code that I have is: It was: I changed it to: So, I needed to change button type…
Each jar file has a manifest file in META_INF/MANIFEST.MF I have to read each…
Introduction Drupal is an awesome CMS. Drupal content type form, allows you to…
Introduction In the ReactJS project, you are having aa parent component and a…
In this post, we will see some of the frequently used concepts/vocabulary in…
System design interview is pretty common these days, specially if you are having…
Introduction You are given an array of integers with size N, and a number K…
Graph Topological Sorting This is a well known problem in graph world…
Problem Statement Given a Binary tree, print out nodes in level order traversal…
Problem Statement Given an array nums of n integers and an integer target, are…