VIEWS Question

[ary1080]

I have a site that users can login to and add friends to their list, delete friends from their list, etc. My problem is that if a user deletes a friend from their list, it will delete the friend from the base table. If I setup a VIEW, will deleting a row from a view also delete it from the base table?

[intellix]

I had a similar conversation with a friend... I was asking if I could use Views in a similar way and he told me that this is not what views are for.

 

It sounds like you have some foreign key dependencies where when you delete from one place it will delete from another automatically for you... did you create your table using MySQL Workbench at all?

[ary1080]

I used the mysql console to setup all of the tables.

[requinix]

A VIEW is something that lets you view data in tables in a different way than is actually set up in the table. You can do JOINs and expressions and whatever and SELECT from it as if it was a table. Depending, you might be able to INSERT or UPDATE it.

 

If the SQL you used has an "ON DELETE CASCADE" then that's the problem. Otherwise I'd start looking at your code to see if it's causing the problem.