Search In
In the following article we will go through a solution to a very common requirement of getting count of duplicate rows from SQL server table.
Let us first create a table and add sample data to this table. Col1 in the table is an identity column.
CRE
Hello friends,
I am here for share the solution of a MySQL problem.
If you want to change the data type of a column from varchar or any other one to date, you should need to use following query-
UPDATE `tbl` SET `date1` = STR_TO_DATE(`date1`, '%d-%
This is a little difficult to explain, so if there is any questions asking me to clarify, I will be happy to do so.
An example with ideas: Imagine that there are five squares in a series. Each square can either be red or white. I would lik
How to crawl many pages at one page hit:
I was facing issues for getting the data from multiple urls by loop. The problem is that in the first loop I was getting the data by function Cron, but when second page was called by Cron function then I was
It is common knowledge to every businessman out there that data is the lifeline of a business. Any decisions or investments for the future of the company are taken after a thorough analysis of data collected through the various channels. Nowadays, ef
Hadoop Framework is used to manage big data in the best and most effective way possible. When it comes to big data, there is great potential wasted in the concept that IT companies achieve great results via phases of predictive data analysis and mode
The primary concern of a personal user to large enterprises regarding data is maintaining security. For this purpose, users store files in Google Drive, Dropbox, Microsoft OneDrive and many other so their data is more secure. Data in Cloud
If you want to rename the file name at the time of upload, it is a right place to know the solution. Let's discuss this requirement.
We all know there are many hooks available in Wordpress. We will use the filter named sanitize_file_name. You can si
If you are facing an error while executing batch for staging process in MDM Hub (Error executing job: SIP-11008, SIP-11141)
Error Description : SIP-11008 :Failed running Cleanse: com.siperian.mrm.cleanse.api.CleanseException: SIP-11141: Exception i
Many people used to think big businesses could only benefit from using big data. They are very wrong. Businesses of all sizes can effectively use technology and big data to help boost their sales and become more successful. In the past 10 years or mo
