|
You can train on SQL language using WinMySQL (Pro, 1.02 or higher), connecting yourself to the MySQL
training database hosted on this site. The parameters are :
| MySQL host | : www.winmysql.com |
| TCP port | : 3307 (Warning, it is not the default port !) |
| Database | : training |
| Username | : scott |
| Password | : tiger |
Of course, for trivial security reasons, you have no writing or admin privileges.
Use DESC table_name statement to see the stuctures of the tables
Use SHOW TABLES to list the tables
The training database is built with the following tables :
| emp | : Table of employees |
| dept | : Table of departments (of the company) |
|
|
You may process a live test with a WinMySQL baby application (generated by WinMySQL Professional).
To do it, download a WinMySQL baby application demo file ("demo_wba.zip" or "jukbx_wba.zip") and the runtime ("wmrt.zip").
Unzip "wmrt.zip" into any directory and at DOS prompt (in this directory) execute "WMRT /SET" command line.
Unzip "demo_wba.zip" (or "jukbx_wba.zip") anywhere.
Initiate you Internet connection.
Double-click on the "demo.wba" (or "jukebox.wba") icon to launch the WinMySQL baby demo application.
This demo application will connect to a demo database hosted by our website. To authenticate, use the following
parameters :
Username : scott
Password : tiger
Once connected, click on the "?" button in the navbar to query all the records.
|