How To Archives - Page 3 of 3

How to List all Forign Keys of a SQL Table

By Arfan YoushufPosted on October 20, 2022October 15, 2023Posted in How ToNo Comments

List Forign keys of a table SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = ‘<database>’ AND REFERENCED_TABLE_NAME = ‘<table>’; List Forign keys of a table column SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = ‘<database>’ AND REFERENCED_TABLE_NAME = ‘<table>’ AND REFERENCED_COLUMN_NAME = ‘<column>’; Drop a Forign Key from a Table MySQL: ALTER TABLE Orders DROP […]

How to Completely Uninstall Nodejs, npm and node in Ubuntu

By Arfan YoushufPosted on October 19, 2022February 22, 2023Posted in How ToNo Comments

sudo apt-get remove nodejs sudo apt-get remove npm Then go to /etc/apt/sources.list.d and remove any node list if you have. Then do a sudo apt-get update Check for any .npm or .node folder in your home folder and delete those.

How to Convert Camel Case to Snake Case JavaScript

By Arfan YoushufPosted on October 18, 2022December 20, 2022Posted in How To, programmingNo Comments

let message = ‘helloWorld’ let convertedMessage=message.replace(/[A-Z]/g, letter => `_${letter.toLowerCase()}`); console.log(convertedMessage); output -> hello_world

Most Used Cron Expressions

By Arfan YoushufPosted on October 16, 2022January 25, 2023Posted in How ToNo Comments

Cron Job Every Minute * * * * * Cron Job Every Hour 0 * * * * Cron Job Every Day Midnight 0 0 * * * Cron Job Every 5 Minute */5 * * * * Cron Job Every 2 Hours 0 */2 * * * Cron Job Every Week 0 0 * […]

Create a New User in PostgreSQL

By Arfan YoushufPosted on October 14, 2022October 16, 2022Posted in How ToNo Comments

Note: This post only provides the key commands of the postgreSQL as a easy way for developers. If you need to learn in depth, please refer to the official documentation Create a new user in PostgreSQL CREATE USER <name> WITH PASSWORD ‘<password>’; If the user already exists, add the password by using ALTER USER: ALTER USER […]

How To Install Docker on Ubuntu

By Arfan YoushufPosted on October 13, 2022December 9, 2022Posted in How To

Update the apt package index and install packages to allow apt to use a repository over HTTPS: sudo apt-get update sudo apt-get install ca-certificates curl gnupg lsb-release Add Docker’s official GPG key: sudo mkdir -p /etc/apt/keyrings curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg –dearmor -o /etc/apt/keyrings/docker.gpg Use the following command to set up the repository: echo “deb [arch=$(dpkg –print-architecture) […]