Wednesday, January 21, 2015

SQL and HTML

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.

1 comment:

  1. As is so often the case, Wikipedia is our best friend here:

    http://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.

    ReplyDelete