Re: [lms] aktualizacjia adresów w urzadzeniach sieciowych

Witam c.addres to chyba pole string UPDATE netdevices nd SET location = (SELECT c.address from customers c, nodes n WHERE nd.id <http://nd.id> = n.netdev AND c.id <http://c.id> = n.ownerid and c.address not like '' LIMIT 1) lub UPDATE netdevices nd SET location = (SELECT c.address from customers c, nodes n WHERE nd.id <http://nd.id> = n.netdev AND c.id <http://c.id> = n.ownerid and c.address not like ' ' LIMIT 1) On 15.09.2015 13:30, Marcin wrote:

UPDATE netdevices nd SET location = (SELECT c.address from customers c, nodes n WHERE nd.id <http://nd.id> = n.netdev AND c.id <http://c.id> = n.ownerid and c.address IS NOT NULL LIMIT 1)