Hi all,
I want to insert multiple rows in my table.
Why is it that i cannot execute this statement?:
INSERT INTO myfile VALUES
(140,'text1',20),
(250,'text2',20)
...
...
Does it mean i will be retyping the insert into statements..
like this:
INSERT INTO myfile VALUES
(140,'text1',20)
INSERT INTO myfile VALUES
(250,'text2',20)
..
..
Is there a workaround or shortcut?
Thanks,
Greg
I want to insert multiple rows in my table.
Why is it that i cannot execute this statement?:
INSERT INTO myfile VALUES
(140,'text1',20),
(250,'text2',20)
...
...
Does it mean i will be retyping the insert into statements..
like this:
INSERT INTO myfile VALUES
(140,'text1',20)
INSERT INTO myfile VALUES
(250,'text2',20)
..
..
Is there a workaround or shortcut?
Thanks,
Greg
Comment