Solving Jboss Wildfly Oracle JDBC driver problem, with Dockerfile
Assuming your web application is using oracle, and you are deploying your app on…
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')
Assuming your web application is using oracle, and you are deploying your app on…
Introduction In Azure, assuming you are having a storage container. And, you…
Introduction I have a host running mysql (not on a container). I have to run an…
Introduction In this post, we will see how to fetch multiple credentials and…
Introduction In this post, we will see a sample Jenkin Pipeline Groovy script…
Introduction In this post we will see following: How to schedule a job on cron…
Introduction There are some cases, where I need another git repository while…
Introduction In this post, we will see how to fetch multiple credentials and…
Introduction I have an automation script, that I want to run on different…
Introduction I had to write a CICD system for one of our project. I had to…
Introduction Java log4j has many ways to initialize and append the desired…