Fusion table

May i know how do i delete the rows from fusion table ?

--

use a DELETE statement

For DELETE 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 DELETE.

see also SQL Reference Documentation of the Fusion Tables API.

-- 

Sorry but i don't know how to start the select statement.

-- 

How do i get the ROWID of the row 

-- 

I do this but it got error . May i know what is the problem ??

-- 

Frequently Made Errors with Fusiontables and how to fix them

check your SQL statement using Do it and read the error message, which gives you some hints about the issue...

you are currently selecting several columns from the table and in the fusiontable control got result event you assign the complete data row to the rowid variable... does this make sense? probably better to only assign the rowid instead, what do you think?

-- 

I'm sorry but I still don't understand and how to name that rowid for specific row which I want to delete . Like for example I want to delete 7 rows in one go when I pressed the delete button

--

which row do you like to delete?

you have to add a WHERE condition to be able to get the rowid of that row

and you do not have to add all columns in the select statement, just do it like this

SELECT ROWID FROM <tableid> WHERE name = 'Denise'

assuming there is the column name available and you like to delete the row, which has the name = 'Denise'

see again the SQL Reference Documentation of the Fusion Tables API.

to delete several rows, you first have to get a list of rowids to be deleted using a SELECT sttement and then DELETE each row one by one

to delete all rows, just send a DELETE FROM <tableid> to the table

-- 

Sorry but it still doesnt work . It still show the error ):

--

a correct DELETE statement looks like this

DELETE FROM <tableid> WHERE ROWID = <rowid you like to delete>

-- 

but i still dont understand how to do . could you give me a example like from my fusion table ?? 

-- 

what does rowid exactly means ??

-- 

What about the select statement , how do i do it ?? Sorry but i really try it out many times. But still doesnt work

-- 

see here https://groups.google.com/d/msg/mitappinventortest/z1QR4hMQU1w/VIHOW8e2AQAJ

--