MATLAB DATABASE TOOLBOX RELEASE NOTES Guida Utente Scaricare il pdf (Pagina 520)

100

101

7 Functions — Alphabetical List

7-90

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

Display the last rows in inventoryTable before insertion of data.

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...'

Create cell array of column names for the database table inventoryTable.

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

Define the cell array of input data to insert.

data = {50 100 15.50 datestr(now,'yyyy-mm-dd HH:MM:SS')};

Insert the input data into the table inventoryTable using database connection conn.

tablename = 'inventoryTable';

datainsert(conn,tablename,colnames,data)

Display inserted data in inventoryTable.

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...'

[50] [ 100] [15.5000] '2014-10-22 11:29...'

The last row contains the inserted data.

Close the connection.

1 2 ... 515 516 517 518 519 520 521 522 523 524 525 ... 683 684

Commenti su questo manuale

Nessun commento

MATLAB DATABASE TOOLBOX RELEASE NOTES Guida Utente Pagina 520

Commenti su questo manuale

Prodotti e manuali riguardandi Software MATLAB DATABASE TOOLBOX RELEASE NOTES