If you are here it means you have an interest in computer science or want to land in an IT company. If you have done your education in computer science then this journey might be easy for you but if… Continue Reading →
If you are most comfortable in the MySQL database but some of your data is in the MS SQL (Microsoft SQL Server) then you need to migrate the MS SQL database to the MySQL database. Fortunately, we have a MySQL… Continue Reading →
We see this error when mysql user doesn’t have permission to execute the list_drop Function inside sys schema of mysql. To fix this error we need to grant the privilege for the same. Login as the root user. Run the… Continue Reading →
Many times, we need to create a random application id with some specific format and that should be unique. In this example, we are going to create an application ID and that should follow the below conditions. It should be… Continue Reading →
Sometime, we need to check the list of processes running inside database or check the status of query. Various database provides their own way to check it. MySQL:If you are on MySQL database then run the below sql to check… Continue Reading →
Run the below SQL to check if your specified column have any other character other than digit. select * from database.table_name where column_name regexp ‘[^0-9]’;
© 2024 My Beliefs
Write us at [email protected]
