|
At this point you have created a new database and have selected it for use. The next step is to create a table to receive the data. To do this you need to use the Create Table command.
In the example below we will create a table to recieve some MySpeed variables and one to receive some of the MyVoIP variables.
At the command prompt type the following:
create table myspeed (testid varchar(80), dspeed varchar(80), uspeed varchar(80), qos varchar(80), rtt varchar(80), maxpause varchar(80), date varchar(80));
The above command first creates a table called myspeed (create table myspeed). The second part creates different columns in the table that will be used to receive data from the server. The columns that statement above creates are as follows:
- testid
- dspeed
- uspeed
- qos
- maxpause
- date
Each columns has a max character settings of 80 (varchar(80)). This setting can be set lower but for this example it has been set high.
You can view the table within the command prompt. To do this type show tables; at the command prompt. This will list the table(s) you have within the selected database, and will look something like the image below:
To view the columns created in the table type describe myspeed; at the command prompt. This will show you the myspeed table you just created, and will look similar to the screen below:
The next stage in this example is to create a new table for the MyVoIP variables.
At the command prompt type the following:
create table myvoip (testid varchar(80), jitter varchar(80), djitter varchar(80), loss varchar(80), dloss varchar(80), date varchar(80));
This again creates a table called MyVoIP with the column names shown above.
Now you have two tables set up to receive data from your MyConnection Server. The next step is to set up an SQL profile on your MyConnection Server to pass data to these tables every time a MySpeed or MyVoIP test is performed.
|
