The best programming blog.

Covering a wide array of programming topics.

Delete a user in MySQL if exists

Below is the query to delete the user account in MySQL by checking if exists before: Replace YourUser with the username of the user which you want to delete in the above query.More

How to delete a MySQL user

Below is the query to delete a user account in MySQL: In the above query, replace UserNameOfTheUser with username of the user account you want to delete.More

MySQL drop database if exists

Below is the query in MySQL to drop the database by checking if exists before: Replace YourDbName with your own db name in the above query.More

Exclude folders files in ArchiveFiles task in Azure Devops

While running the ArchiveFiles task in Azure Devops pipeline if you want to exclude certian folders and files then you can follow the following stps: Add a CopyFiles task just before the ArchiveFiles task. The tasks order will look like this: In the above example the files with extenions md, yml and the folder git…More

How to check Ionic version

Steps to check the Ionic version in an Ionic project: Open your project in VSCode. Open Terminal in VSCode. Type the following command : The terminal will show the output of the version being used in your project. Example: the above results “6.19.0” is the version of Ionic installed.More

NullInjectorError: No provider for Service! Angular

Error while calling a page in Angular: The solution is to add the service in the providers section in your module. Go to the module where you want to use that service and add the service as following: In the above code the YourService was added like this in the providers:More

How to change username of your account in Mac

Go to Sytem Preferences > Users & Groups Click the lock to make changes: Right the click the user and select Advanced Options … Modify the required values to replace teh old account with the new one: Click OK button. Restart the Mac. Log on to the modfied account.More