SQL Query : Part 1
You are probably thinking that this is going to be another sql query tutorial. Well the answer is both yes and no. I am tired of searching and reading all those sql tutorials again and again where each of this tutorials explain all those concept from top to bottom, which I don't need. We programmers easily forgot sql query syntax but not the concept. So I created my own list to save a lot of searching time. I am not posting all queries in a single post. I had divided all queries into several parts. This is the first part. I am using mysql for the RDMS. I also includes some common mysql command along with sql queries. This post only contains queries which includes database creation, table creation, view data from table. Start mysql server mysql -u root -p This command will prompt for password, enter the password you set for your local mysql server. Resetting root user password for mysql server ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass...