Small table to practice id matching.

CREATE DATABASE test_1;
USE test_1;

CREATE TABLE test_items(

contact_id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR (20) ,
last_name VARCHAR (20),
PRIMARY KEY (contact_id)
);

INSERT INTO test_items()

VALUES (
(NULL, 'Javier','Droid'),
(NULL,'Gret','Jun'),
(null,'Kilot','Ramirez')

);
SELECT * FROM test_items;

1 Answers

1
THEWOLF On

Always specify the column names you are inserting:

INSERT INTO test_items(first_name, last_name)  
VALUES ('Javier','Droid'), ('Gret','Jun'), ('Kilot','Ramirez'); 

SELECT * FROM test_items;