User`s guide

7 Functions — Alphabetical List
7-92
tablename = 'salesVolume';
datainsert(conn,tablename,colnames,data)
Display inserted data in salesVolume.
curs = exec(conn,'select * from salesVolume');
curs = fetch(curs);
curs.Data
ans =
Columns 1 through 8
...
[510099] [ 235] [1800] [1040] [ 900] [ 750] [ 700] [ 400]
[899752] [ 123] [1700] [ 823] [ 701] [ 689] [ 621] [ 545]
[777666] [ 0] [ 350] [ 400] [ 450] [ 250] [ 450] [ 500]
Columns 9 through 13
...
[350] [ 500] [ 100] [ 3000] [18000]
[421] [ 495] [ 650] [ 4200] [11000]
[515] [ 235] [ 100] [ 300] [ 600]
The last row contains the inserted data.
Close the connection.
close(conn)
Input Arguments
conn — Database connection
database connection object
Database connection, specified as a database connection object created using database.
tablename — Database table name
string
Database table name, specified as a string denoting the name of a table in your database.