So I was working on the fruit table in bottle zoo and I figured out how to display the page with your help although now it won't submit so I need to learn how to allow users to make changes.
To delete something in SQL you just write
DELETE FROM table WHERE column=columndata;
for example
DELETE FROM Movies WHERE Title='Big Trouble in Little China';
To let the user remove something from the table you would use an html form where the user would select what they want deleted and then submit it. I need to read about cursors but I guess the cursor goes through the database and makes the changes.
As is so often the case, Wikipedia is our best friend here:
ReplyDeletehttp://en.wikipedia.org/wiki/Cursor_%28databases%29
Please read that over when you get a chance, and let me know if it clarifies for you what the cursor is.