passarito Posted December 8, 2015 at 04:18 PM Report Share #590480 Posted December 8, 2015 at 04:18 PM Boa tarde, tenho uma BD com varias tabelas. Numa delas, que tem milhares de registos, quero acrescentar um campo numerico. Se eu quiser colocar todos os registos desse novo campo igual a 1, há alguma forma automática de o fazer? Obrigdo Link to comment Share on other sites More sharing options...
Solution vikcch Posted December 8, 2015 at 07:58 PM Solution Report Share #590484 Posted December 8, 2015 at 07:58 PM UPDATE tabela SET novo_campo = 1 Link to comment Share on other sites More sharing options...
passarito Posted December 11, 2015 at 08:09 AM Author Report Share #590561 Posted December 11, 2015 at 08:09 AM Obrigado Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now