User`s guide

7 Functions — Alphabetical List
7-134
...
[400876] [3000] [2400] [1500] [1500] [1300] [1100] [ 900]
[400999] [3000] [1500] [1000] [ 900] [ 750] [ 700] [ 400]
[888652] [ NaN] [ 900] [ 821] [ 701] [ 689] [ 621] [ 545]
Columns 9 through 13
...
[867] [ 923] [1100] [ 4000] [32000]
[350] [ 500] [1100] [ 3000] [12000]
[421] [ 495] [ 550] [ 4200] [12000]
Insert data using the columns denoted by colnames into the salesVolume table.
tablename = 'salesVolume';
colnames = {'stockNumber','January','February'...
'March','April','May',...
'June','July','August',...
'September','October','November',...
'December'};
fastinsert(conn,tablename,colnames,data)
Display the data in the salesVolume table after insertion.
curs = exec(conn,'select * from salesVolume');
curs = fetch(curs);
curs.Data
ans =
Columns 1 through 8
...
[400999] [3000] [1500] [1000] [ 900] [ 750] [ 700] [ 400]
[888652] [ NaN] [ 900] [ 821] [ 701] [ 689] [ 621] [ 545]
[777666] [ 0] [ 350] [ 400] [ 450] [ 250] [ 450] [ 500]
Columns 9 through 13
...
[350] [ 500] [1100] [ 3000] [12000]
[421] [ 495] [ 550] [ 4200] [12000]
[515] [ 235] [ 100] [ 300] [ 600]