SQL插入报错：第2行列数与值数不匹配，请求技术排查帮助

错误原因是第二行插入数据里的**'Nantes'和'08:00:00'之间缺少逗号**，导致这两个值被合并成一个字符串，使得该行的有效数值数量比目标列数少1，触发了列数与值数不匹配的错误。

错误代码片段（第二行）： #

('martedi', 'Nantes' '08:00:00', 'Marsiglia', '11:00:00', 'Super 100'),

修正后的完整SQL代码： #

CREATE TABLE volo (
idVolo INT AUTO_INCREMENT PRIMARY KEY NOT NULL, 
giornoSett VARCHAR (50),
cittàPart VARCHAR (50),
oraPart TIME,
cittàArr VARCHAR (50),
oraArr TIME,
tipoAereo VARCHAR (50),
FOREIGN KEY (cittàPart) REFERENCES aeroporto (città)
);


INSERT INTO volo (giornoSett, cittàPart, oraPart, cittàArr, oraArr, tipoAereo)
VALUES 
    ('martedi', 'Bristol', '16:00:00', 'Pescara', '18:00:00', 'Super 23'),
    ('martedi', 'Nantes', '08:00:00', 'Marsiglia', '11:00:00', 'Super 100'),
    ('mercoledi', 'Marsiglia', '09:00:00', 'Manchester', '10:00:00', 'Super Mx'),
    ('mercoledi', 'Palermo', '12:00:00', 'Roma', '18:00:00', 'Super Evo'),
    ('mercoledi', 'Bristol', '12:00:00', 'Nizza', '14:00:00', 'Tx Transporter'),
    ('giovedi', 'Manchester', '17:00:00', 'Parigi', '19:00:00', 'Tx Mega 2'),
    ('giovedi', 'Pescara', '00:00:00', 'Milano', '03:00:00', 'Tx Adv'),
    ('giovedi', 'Nizza', '10:00:00', 'Londra', '14:00:00', 'Tx One'),
    ('venerdi', 'Milano', '22:00:00', 'Bristol', '00:00:00', 'Tx One'),
    ('venerdi', 'Roma', '21:00:00', 'Palermo', '23:00:00', 'Tx One'),
    ('venerdi', 'Londra', '15:00:00', 'Nantes', '17:00:00', 'Tx One'),
    ('sabato', 'Liverpool', '21:00:00', 'Nantes', '22:00:00', 'Tx One'),
    ('sabato', 'Palermo', '16:00:00', 'Liverpool', '19:00:00', 'Tx One'),
    ('sabato', 'Londra', '19:00:00', 'Palermo', '22:00:00', 'Tx One'),
    ('domenica', 'Marsiglia', '20:00:00', 'Milano', '23:00:00', 'Tx One'),
    ('domenica', 'Roma', '21:00:00', 'Pescara', '23:00:00', 'Tx One'),
    ('domenica', 'Prigi', '06:00:00', 'Londra', '09:00:00', 'Tx One'),
    ('martedi', 'Londra', '23:00:00', 'Bristol', '03:00:00', 'Boing 463'),
    ('lunedi', 'Pescara', '22:00:00', 'Londra', '01:00:00', 'Boing 717'),
    ('lunedi', 'Nantes', '18:00:00', 'Londra', '20:00:00', 'Boing 12'),
    ('lunedi', 'Milano', '20:00:00', 'Palermo', '21:00:00', 'Boing 890');

额外提示：SQL的TIME类型不支持24:00:00格式，已将代码中所有24:00:00替换为00:00:00（午夜的标准表示），避免触发类型错误。

内容的提问来源于stack exchange，提问作者Leonardo Sebastiani