Tuesday, April 7, 2020

Answer for SQL auto increment

https://365datascience.com/dwqa-answer/answer-for-sql-auto-increment/ -

Hi Sandra!

Thanks for reaching out.

This is the code structure to use; please apply it to your table and relevant field with its data type, substituting the relevant names in there.


ALTER TABLE table_name MODIFY field_name data_type NOT NULL AUTO_INCREMENT;

Hope this helps.
Best,
Martin


 



#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

No comments:

Post a Comment