I am wondering if anyone of you forgot your mysql db password for root user? Because I did.. LOL!!
So whats the bad thing with this? Oh! dear! its pretty bad because root user is the super admin for your DB and if you cant go through this.. you are screwed. You can’t manage DBs, cant manage users, permission and list is endless.
Here I found a simple way to reset your root password.
Sometimes we all need to insert multiple rows into our database. Data can come from various sources like feeds, excel sheets etc.
So how to do that?
Goal: Insert multiple rows in efficient way.
We all are familiar with selecting the rows which has common data in multiple tables. And yes using joins are the most popular solution among the developers.
Now question is how to select rows which doesn’t exists in other tables.
lets say there are two tables employee and department.