Check out example codes for "sql query to make a existing column auto increment". It will help you in understanding the concepts better.

Code Example 1

Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY

Learn ReactJs, React Native from akashmittal.com