Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.36 KB | None | 0 0
  1. update parcela_conta_receber set nossonumero=REPLACE(nossonumero, '/', '') where nossonumero LIKE'%/%';
  2.  
  3.  
  4. DELETE a FROM boletos_cbx AS a, boletos_cbx AS b WHERE ((a.nossonumeroint=b.nossonumeroint) and (a.sacado_nome=b.sacado_nome) and
  5. (a.banco=b.banco)
  6. )  AND  a.boleto_nosso_numero like'%/%';
  7.  
  8. select * from boletos_cbx where boleto_nosso_numero LIKE'%/%';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement