MATLAB DATABASE TOOLBOX RELEASE NOTES Betriebsanweisung PDF herunterladen (Seite 657)

100

101

setdbprefs

7-227

conn = database('MySQL','username','pwd');

Specify NaN for the NullNumberWrite format.

setdbprefs('NullNumberWrite','NaN')

Numbers represented as NaN in the MATLAB workspace are exported to databases as

NULL.

Select data in the table inventoryTable.

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

curs = fetch(curs);

curs.Data

ans =

...

[14] [2000] [19.1000] '2014-10-22 10:52...'

[15] [1200] [20.3000] '2014-10-22 10:52...'

[16] [1400] [34.3000] '1999-12-31 00:00...'

Specify data ex_data to export into inventoryTable. ex_data contains a NaN. For the

inventory date, specify the date as the current moment.

ex_data = {24,NaN,30.00,datestr(now,'yyyy-mm-dd HH:MM:SS')};

Insert ex_data into the database using fastinsert with column names:

productNumber, Quantity, Price, and inventoryDate.

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

fastinsert(conn,'inventoryTable',colnames,ex_data)

Select data in the table inventoryTable to see the last row with NaN data.

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

curs = fetch(curs);

curs.Data

ans =

...

[15] [1200] [20.3000] '2014-10-22 10:52...'

[16] [1400] [34.3000] '1999-12-31 00:00...'

1 2 ... 652 653 654 655 656 657 658 659 660 661 662 ... 683 684

Kommentare zu diesen Handbüchern

Keine Kommentare

MATLAB DATABASE TOOLBOX RELEASE NOTES Betriebsanweisung Seite 657

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software MATLAB DATABASE TOOLBOX RELEASE NOTES