PHP mySQL - Insert new record into table with auto-increment on primary key

To insert a new record into a MySQL table that has an auto-increment primary key, you can use the INSERT statement with a list of comma-separated values. For example:

INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3);

The primary key column does not need to be included in the list of columns, as it will be generated automatically by the database.

Here is an example of how to insert a new record into a table named users that has an auto-increment primary key id and other columns username, password, and email:

INSERT INTO users (username, password, email) VALUES ('john', 'mypassword', '[email protected]');

If you want to insert multiple records at the same time, you can use the following syntax:

INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3), (value1, value2, value3), ...;

For example:

INSERT INTO users (username, password, email) VALUES 
('jane', 'password1', '[email protected]'), 
('jack', 'password2', '[email protected]'), 
('jill', 'password3', '[email protected]');

You can then use a SELECT statement to verify that the records have been inserted into the table.

SELECT * FROM users;