rowid need to update or delete operation, but I can not reach him
--
SELECT ROWID FROM <tableid> WHERE ...
--
SELECT ROWID FROM <tableid> WHERE ...
--
unfortunately it's a little bit complicated...
How do i delete all values in one column
you only can delete rows, but you can update all values in a column and set them to empty string like this:
generally: For UPDATE statements the first step to be done is to get the ROWID of the row to be updated with a SELECT statement. The second step is to do the UPDATE.
to update several rows, you first could retrieve the rowids of all rows like this
SELECT ROWID FROM <tableid>
and store them in a list, then execute an update statement for each rowid
UPDATE <tableid> SET myColumn = '' WHERE ROWID = <rowid>
how do i only get the last value in a column
you can try the following slect statement
SELECT columnName FROM <tableid> WHERE ROWID = MAXIMUM(ROWID)
--
댓글 없음:
댓글 쓰기