Advertisement
ddspires

Alterar Dados da Empresa E Filial

Aug 17th, 2018
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.21 KB | None | 0 0
  1. SELECT * FROM empresa
  2.  
  3. UPDATE empresa SET fone='(81)3132-2976', fax='(81)8116-3440'
  4.  
  5. SELECT * FROM filial WHERE idfilial='2'
  6.  
  7. UPDATE filial SET fone='(81)3132-2976', fax='(81)8116-3440' WHERE idfilial='2'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement