How to add remote DB in phpmyadmin
There are a number of MySQL client but so far phpmyadmin is one of the popular MySQL client used. It's simple to use, effective and provide almost all the required features for day to day development.
How to take MySQL DB back up from the command line
As you know regular backups of DB for a running site are very important. Most of the hosting providers do this for you, but sometimes its also expected from you to do the same.
Command to import DB through the command line in MySQL
#sql injection #php #mysql #security
How to Sanitize Input in PHP
The inputs in Core PHP are venerable to what you call “SQL Injection”, to before putting them to use it’s a mandatory practice to sanitize them
#express js #node #node js #sequelize #mysql
How to create model association in Sequelize - express JS / Node JS
In the very initial days of my work in Node JS if faced this issue. Though Sequelize provide a great ORM for MySQL but the association within the models is a bit tricky.