MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka stáhnout pdf (Strana 560)

100

101

7 Functions — Alphabetical List

7-130

[13] [ 1700] [14.5000] '2009-05-24 10:58...'

Assign multiple rows of data to the cell array data. Each row contains data

for productNumber, Quantity, and Price. The first row data for insertion is

productNumber equals 7778, Quantity equals 125, and Price equals 23.00.

data = {7778,125,23.00,datestr(now,'yyyy-mm-dd HH:MM:SS');...

7779,1160,14.7,datestr(now,'yyyy-mm-dd HH:MM:SS');...

7780,150,54.5,datestr(now,'yyyy-mm-dd HH:MM:SS')};

Create a cell array containing these column names:

• productNumber

• Quantity

• Price

• inventoryDate

tablename = 'inventoryTable';

colnames = {'productNumber','Quantity','Price','inventoryDate'};

Insert the data into the inventoryTable.

fastinsert(conn,tablename,colnames,data)

For details about inserting data in bulk, see these sample files for different database

vendors that demonstrate bulk insert:

• matlabroot/toolbox/database/dbdemos/mssqlserverbulkinsert.m

• matlabroot/toolbox/database/dbdemos/mysqlbulkinsert.m

• matlabroot/toolbox/database/dbdemos/oraclebulkinsert.m

Display the data in the inventoryTable table after insertion.

curs = exec(conn,'select * from inventoryTable');

curs = fetch(curs);

curs.Data

ans =

...

[ 13] [ 1700] [14.5000] '2009-05-24 10:58...'

[7778] [ 125] [ 23] '2014-10-23 10:21...'

1 2 ... 555 556 557 558 559 560 561 562 563 564 565 ... 683 684

Komentáře k této Příručce

Žádné komentáře

MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka Strana 560

Komentáře k této Příručce

Související produkty a manuály pro Software MATLAB DATABASE TOOLBOX RELEASE NOTES