Saturday, 31 August 2013

Insert array in one insert query

Insert array in one insert query

i need use on array in insert query :
SET @follower = (SELECT follow.follower FROM follow WHERE
following=NEW.user_id);
INSERT INTO followRead (`id_fk`, `follower`, `seen`) VALUES (NEW.id,
implode(",",@follower) , 0);
in this query used from implode function

No comments:

Post a Comment