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

100

101

Delete Data from Databases

6-17

...

[10] [ 723] [ 24] '2012-03-14 13:13...'

[11] [ 567] [ 0] '2012-09-11 00:30...'

[12] [1278] [ 0] '2010-10-29 18:17...'

The record with product number 13 is missing.

Delete a Record Using a MATLAB Variable

Define a MATLAB variable productID by setting it to the product number 12.

productID = 12;

Delete the data using the MATLAB variable productID. Build an SQL statement string

that combines the SQL for the delete operation with the MATLAB variable. Since the

variable is numeric and the SQL statement is a string, convert the number to a string.

Use the num2str function for the conversion. Concatenate the delete SQL statement and

the numeric conversion using the square brackets.

curs = exec(conn,['delete * from inventoryTable where '...

'productNumber = ' num2str(productID)]);

Display the last rows in the table inventoryTable after the deletion.

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

curs = fetch(curs);

curs.Data

ans =

...

[ 9] [2339] [ 13] '2011-02-09 12:50...'

[10] [ 723] [ 24] '2012-03-14 13:13...'

[11] [ 567] [ 0] '2012-09-11 00:30...'

The record with product number 12 is missing.

Close the Cursor and Database Connection

close(curs)

close(conn)

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

Žádné komentáře

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

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

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