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.
Have you faced a situation when you need to find the first day and last day of a month? Such scenarios occurs when we do some kind of enterprise application when accounting or billing modules comes into the picture.
And YES its important as well. Lets find out in some of the technologies.
Sometimes we have to send the dates from front end. Lets say by default you have to set date range components from 1st day of this month to current date. So here is the hack.
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.