如何自动增加MySQL表中的列？

Question

Ok so I am making a program in Java where it sends data to a MySQL server where it makes a new account. The table has 4 columns. ID, e-mail, username, and password. I know how to set the values of e-mail, username, and password but I need help setting ID. ID will auto-increment based on the last registered ID in the table.

Example: If the last registered user had an ID of 4 then it will auto-set the new user's ID to 5.

Answer 1

Like this:

ALTER TABLE Persons AUTO_INCREMENT=100 //use this if you want a certain number to start off from

To insert a new record into the "Persons" table, we will NOT have to specify a value for the "ID" column (a unique value will be added automatically):

INSERT INTO table (email, username, password)
VALUES ('email@domain','unixmiah', 'x007')