Relative Content

Tag Archive for sqlvisual-studio-code

How to turn a already created column in auto_incremeted on VScode

Im trying just to turn my column, that i’ve already created, into a auto_incremented table.
My table is Ator, who has CodAutor and Nome as columns, i see that instead of always put numbers(in this example, input 1) manually in CodAutor, like: insert into Autor(CodAutor,NAME) values(1,’NameExample’), it can be incremented automatic. I’ve been trying this like : ALTER TABLE Ator MODIFY COLUMN CodAtor NOT NULL AUTO_INCREMENT;