MySQL Forums
Forum List  »  Russian

Array + NOT IN
Posted by: Fenix Fenix
Date: May 26, 2009 01:42AM

Подскажите:
есть массив чисел, к примеру (1,2,3,4,5)
есть таблица table1 c table1.id, table1.num

как возможно получить элементы массива, которые ненаходятся в table1.num?
а потом их добавить в table1

хотелось бы всё скрутить в 1 запрос =)

Options: ReplyQuote


Subject
Views
Written By
Posted
Array + NOT IN
6412
May 26, 2009 01:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.