Posts

Showing posts with the label mysql karma dorji

Mysql tutorial for Beginners Part1

Image
Here I’ll show you all the things that you will need to know to work with mysql programming. So lets get started. I am assuming that you have mysql installed in your PC and we won’t be using any GUI tools, we’ll do all the work in our command prompt which is advisable at the beginning.                                    How to Connect to your Mysql server. Click Start>run> type cmd in the run button> and you will see the command promptIn your command prompt type mysql   -u username –p and   press enter and then you will have to give your password to authenticate that you are a valid user. Or directly open your mysql command line and give your password, which is much more easier. I have shown both the diagrams. Than you will see the following messages “Welcome to the Mysql Monitor…..” You can type help in the command line to see the list of mysql commands. Type : SHOW databases ;   note that all mysql commands should end with a semicolon(;) except for some commands like u