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 →
If you get the Error (‘01000’, [01000] [unixODBC][Driver Manager]Can’t open lib ‘ODBC Driver 17 for SQL Server’ : file not found (0) (SQLDriverConnect)) in Mac then run the below command to fix the issue. brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release brew update… 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 →
There are some basic postgres commands, those we use daily basis like listing database, switching database, listing tables etc. Listing Database \l # or \list 2. Switching Database \connect sales # or \c sales 3. Listing Tables \dt
If you are working on Postgres and facing issues of slow queries then tuning the Postgres server can be a good point to optimize the performance by tuning the Postgres database. In this article, we will talk about increasing 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 →
If you want to only extract digits from a string in Postgres, we can do it using regexp_replace. \D tell not digit and ‘g’ stand for global. SELECT NULLIF(regexp_replace(‘OTHERdsfd4 323 2323d42324 3ssf3 432`sfd’, ‘\D’,”,’g’), ”)::numeric AS result — Output: 432323234232433432… 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]’;
© 2025 My Beliefs
Write us at [email protected]
