MySQL Could not load assembly MySQL-Generating Row Number for each row Thank you for landing here In a development work environment as a developer or database administrator may expect the query results to have sequential number or running number like 1,2,3,4, etc for each row . There are databases have their own way of handlingContinue reading “MySQL – Generating Row Number for Each Row”
Tag Archives: MySQL
How to find second highest value in table ?
How to find second highest value in table ? SQL Server Find the highest employee salary SELECT EmpId, SalaryFROM(Select EmpId, Salary, ROW_NUMBER() OVER(ORDER BY Salary Desc) AS Salary_OrderFROM Employee) resultsWHERE results. Salary_Order = 1 ; Find the 2nd highest employee salary SELECT EmpId, SalaryFROM(Select EmpId, Salary, ROW_NUMBER() OVER(ORDER BY Salary Desc) AS Salary_OrderFROM Continue reading “How to find second highest value in table ?”
SOLVED Could not load file or assembly ‘Renci.SshNet – MySQL
Solved Could not load file or assembly ‘Renci.SshNet, Version=2016.1.0.0, Culture=neutral, PublicKeyToken=1cee9f8bde3db106’ or one of its dependencies ? The Solution is right below Working with MySQL database, have you realized all the while the MySql connection is lost for no reason? Now you go to visual studio project libraries you will find MySQL client dll stillContinue reading “SOLVED Could not load file or assembly ‘Renci.SshNet – MySQL”
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
How to fix Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding Finding Root Cause: When using MySQL database and .NET /Connector with a thousands of rows to do an INSERT IGNORE command results in timeout expired exception. Usually we tend to suspect on the connectionContinue reading “Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.”
Install the Google Publisher Toolbar
(adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: “ca-pub-9111247652808147”, enable_page_level_ads: true }); Google Publisher Toolbar To use the Google Publisher Toolbar you’ll need to install it and allow it access to the Google Account associated with your account. Browse to the Google Publisher Toolbar (by Google) page. Click Add to Chrome. In the dialog that appears, click Add Extension. The GoogleContinue reading “Install the Google Publisher Toolbar”
How to find first and last occurrence of any char or word in sql query?
How to find first and last occurrence of any char or word in sql query? Find First occurrence of any character or word in the string : In the given below example, we need to search for the first occurrence of word ‘the’ in the sentence. DECLARE @String AS VARCHAR(100) DECLARE @strSearch AS VARCHAR(100) SET @String =’Hi SQL SERVER is fromContinue reading “How to find first and last occurrence of any char or word in sql query?”
How to change MySQL root password?
How to change MySQL root password? Steps by Step Open MySQL Command Line Client To remove a password SET PASSWORD FOR root@localhost=PASSWORD(”); To add a password SET PASSWORD FOR root@localhost=PASSWORD(‘root’); Demo image is below
SQL Server Instance Connection Error
SQL Server Instance Connection Error ERROR A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – The remote computer refusedContinue reading “SQL Server Instance Connection Error”
Arjun's Blog 