I created a table in mysql containing 2 columns ,userid,movieid.I entered the values in movieid column using arraylist.
the table contains the following data
userid movieid
1 12234,5688,8976
2 567
now i want to delete 12234 in movieid column where userid=1
how i can write the query in mysql.can anyone help me.
delete a leela May 13, 2012 at 10:06 PM
I created a table in mysql containing 2 columns ,userid,movieid.I entered the values in movieid column using arraylist. the table contains the following data userid movieid 1 12234,5688,8976 2 567 now i want to delete 12234 in movieid column where userid=1 how i can write the query in mysql.can anyone help me.
Post your Comment