If I need to add several records I can perform this in 1 command as shown in the sample SQL scripts we have been using:

-- Populate initial data into table

INSERT INTO `sfmembers` VALUES

(NULL, 'James', 'Kirk', 1, '1966-09-08', 'Captian'),

(NULL, 'S\'chn T\'gai', 'Spock', 2, '1966-09-08', 'Commander'),

(NULL, 'Montgomery', 'Scott', 1, '1966-09-08', 'Commander'),

(NULL, 'Michael', 'Burnham', 2, '2017-09-19', 'Captian'),

(NULL, 'Sylvia', 'Tilly', 1, '2017-09-19', 'Lt. Commander'),

(NULL, 'Keyla', 'Detmer', 1, '2017-09-19', 'Lt. Commander'),

(NULL, 'Benjamin', 'Sisko', 1, '1993-01-03', 'Captian'),

(NULL, 'Worf', 'Mogh', 3, '1993-01-03', 'Commander'),

(NULL, 'Jadzia', 'Dax', 4, '1993-01-03', 'Lt. Commander'),

(NULL, 'Kathryn', 'Janeway', 1, '1995-01-16', 'Captian'),

(NULL, 'D\'sut', 'Tuvok', 2, '1995-01-16', 'Lt. Commander'),

(NULL, 'B\'Elenna', 'Torres', 3, '1995-01-16', 'Lt. Commander'),

(NULL, 'Leonard', 'McCoy', 1, '1966-09-08', 'Lt. Commander'),

(NULL, 'Philippa', 'Georgiou', 1, '2017-09-19', 'Captian'),

(NULL, 'Annika', 'Hansen', 1, '1995-01-16', 'Master Chief');

Individual Records are delimited by a comma ‘,’ and the list is ended with the semicolon ‘;’

INSERT -ing In Batch