Creative Rides

WeddingQuery……. …….. (SQL Style)

CREATE PROCEDURE MyMarriage
BrideGroom Male (25) ,
Bride Female(20) AS
BEGIN
SELECT Bride FROM india_ Brides
WHERE FatherInLaw = ‘Millionaire’ AND Count(Car) > 20 AND HouseStatus =’ThreeStoreyed’
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA) AND Having Brothers= Null AND Sisters =Null

SELECT Gold ,Cash,Car,BankBalanceFROM FatherInLaw ;
UPDATEMyBankAccout SETMyBal = MyBal + FatherInLawBal;
UPDATEMyLockerSET MyLockerContents = MyLockerContents + FatherInLawGold;
INSERT INTOMyCarShed VALUES(’BMW’);
END
GO

Then the wife writes the below query:

DROP HUSBAND;
Commit;

Please wait until MySQL shuts down completely. Then run
 #/usr/bin/mysqld_safe –skip-grant-tables –skip-networking &

 then you will be able to login as root with no password.
 #mysql -uroot mysql

 In MySQL command line prompt issue the following command:
 mysql>UPDATE user SET password=PASSWORD(”letmein”) WHERE user=”root”;
 FLUSH PRIVILEGES;

 mysql>exit

  kill all the mysql processes
 #/etc/init.d/mysql stop

 Start MySQL again
 #/etc/init.d/mysql start

At this time your root password is reset to “letmein” and MySQL will now
know the privileges and you’ll be able to login with your new password:
 mysql -uroot -pletmein mysql

Congratulations you have sucessfully changed your new password