MySQL: install, manage, backup, update, customize
Say, you need to get a single top order number from a related table. You might use this TOP 1 syntax: , ISNULL((SELECT TOP 1 D1.CDDOCO FROM CRPDTA.F1721 D1 WHERE D1.CDNUMB = FANUMB AND D1.CDCDTE > @TODAY ORDER BY D1.CDDOCO DESC), ”) [Top contract] However, if your output returns over […]
This article is written for those who need to test/evaluate features of new WordPress release on a local machine before rolling it out to all the serves. This article describes running PHP on IIS 7.5 through FastCGI. For best results, reader is required to be able to start and stop […]
You have several instances of SQL Server (Express) installed and you need to remove/uninstall just one of the instances. Here are the steps tested in Windows 10 with SQL Server 2019 Express —01— Open App & Features —02— Find MS SQL Server 2019 (64-bit) and click Uninstall: —03— Confirm […]
This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List […]
After synchronizing your laptop with corporate policies you might notice that multiple black command windows will popup on a regular basis that might even look like some virus. You are in luck if you hade ADMIN rights on your laptop. You can easily go to registry and delete all references […]
I am running PHP on IIS 7.5. This is a Windows 2012 Server. Fresh clean install every time. The only way to access and delete these TEMP files are by using a command prompt. And this deletion procedure will run for several DAYS . . . The Problem The story […]
This was exciting. After years of neglect, I have decided to examine, who is registering on my WordPress site, and what is that they are doing. I knew that most of them are just a result of robot activities, and they are just a dead weight in the database (useless […]
Julian date is stored in YYYDDD format, for example 12/31/99 will be stored as 99365 and 01/01/2017 will be stored as 117001. If you need to convert the date from YYYDDD to any conventional date format like dd/mm/yyyy in SQL use steps below. The idea is to convert year and […]
Scenario Here is a recipe on how to concatenate a field from multiple records into one field. There are two pre-conditions for this method to work: First. Your source file needs to have an equivalent of a line number field. This should be a numeric field indicating the sequence in […]
Exciting voyage began on TU 2021-02-16. After months of WordPress (WP) warning about outdated PHP version, it was time to open a new Amazon Linux 2 instance and install all the latest gadgets. This major upgrade triggered many errors and problems. I needed a place to store and accumulate the […]
Task You already have a working WordPress (WP) site. Now, you need to add one more site with a new MySQL database. This document describes how to add one more database and install a new WP site on the same server. Download Download latest WordPress ZIP package (3.X) and unzip […]
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor