How can I make this code simplier?

Question

Iam trying to make my code simple, is there any difference between this

INSERT INTO course (code, name, credits) VALUES 
('WSD','Web systems Development','75');
INSERT INTO course (code, name, credits) VALUES 
('DDM','Database Design & Management','100');
INSERT INTO course (code, name, credits) VALUES 
('NSF','Network security & forensics','75');

and this?

INSERT INTO course (code, name, credits) VALUES 
('WSD','Web systems Development','75');
('DDM','Database Design & Management','100'); 
('NSF','Network security & forensics','75');

Does it produce same results?

Second query will not work. – Haytem BrB Feb 04 '16 at 18:32 — Haytem BrB, Feb 04 '16 at 18:32

score 0 · Accepted Answer · answered Feb 04 '16 at 18:34

0

Yes, the same.

You can insert multiple rows at once in MySql but instead of a semicolon you need commas.

Syntax

INSERT INTO tbl_name
        (a,b,c)
    VALUES
        (1,2,3),
        (4,5,6),
        (7,8,9);

Your example

INSERT INTO course (code, name, credits) 
VALUES
('WSD','Web systems Development','75'),
('DDM','Database Design & Management','100'),
('NSF','Network security & forensics','75');

answered Feb 04 '16 at 18:34

amui

51
2

You are right that in terms of speed it is not the same. However I was looking at it as the end result of what is in the database is still the same. Thank you. – amui Feb 04 '16 at 18:50

How can I make this code simplier?

1 Answers1