Tables in database.
-
I have created a database with n number of tables. i want to delete some rows from some tables matching certain criteria. This i have to do dynamically. I am a beginner to sql. If someone in here can shed me a light will be great.
Something like:
delete from table where mycolumn = 0
The
whereis where you put conditional statements that match your requirement. So, for instance, let's say I have a person table and one of the columns tells me that a person is active or not I might use:delete from person where IsActive = 0
me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven
-
I have created a database with n number of tables. i want to delete some rows from some tables matching certain criteria. This i have to do dynamically. I am a beginner to sql. If someone in here can shed me a light will be great.
Do you mean that you want to delete the same information from multiple tables?
Humble Programmer