This section helps you to get familiar with basic MySQL including managing MySQL database and manipulating data using various SQL statements such as INSERT, DELETE, UPDATE and SELECT.
To run mysql on command prompt follow the below steps:
Click your wamp server icon>MySQL>MySQL Console Or You can follow below display:
Or you can also run mysql from your command prompt:
1. Run cmd command
2. Type c: or d: on command prompt. This will be based on your WAMP server installations.
3. Assuming you have installed wamp on D: drive.
4. D:\>cd wamp
4. D:\wamp>cd bin
5. D:\wamp\bin>cd mysql
6. D:\wamp\bin\mysql>cd mysql15.1.36
7. D:\wamp\bin\mysql\mysql15.1.36>cd bin
8. D:\wamp\bin\mysql\mysql15.1.36\bin>mysql.exe -u root
2. Type c: or d: on command prompt. This will be based on your WAMP server installations.
3. Assuming you have installed wamp on D: drive.
4. D:\>cd wamp
4. D:\wamp>cd bin
5. D:\wamp\bin>cd mysql
6. D:\wamp\bin\mysql>cd mysql15.1.36
7. D:\wamp\bin\mysql\mysql15.1.36>cd bin
8. D:\wamp\bin\mysql\mysql15.1.36\bin>mysql.exe -u root
These are the main steps to run mysql on command line
Now Lets Start Learning MySQL Basic
0 comments:
Post a Comment