Two for one special offer

[suityou01]

Using MySQL QB

I have an insert script, 343 rows.
When I run it it inserts double the number of rows.

So two for one.

[suityou01]

Using MySQL QB

I have an insert script, 343 rows.
When I run it it inserts double the number of rows.

So two for one.

Those are sarcastic bananas

HTH

[TheFaQQer]

Sounds like you have double end of line terminators, e.g.

INSERT INTO foo VALUES (123);
/

[suityou01]

Sounds like you have double end of line terminators, e.g.

INSERT INTO foo VALUES (123);
/

Interesting

twas

insert into foo(foo1,foo2) values (bar1,bar2);
insert into foo(foo1,foo2) values (bar1,bar2);
insert into foo(foo1,foo2) values (bar1,bar2);

the developer used the same script using a different db client and Robert is your Aunties brother or something like that

MySQL QB is pants (IMVHO)

Ne'er mind. There I go breaking my new rule about posting when I'm angry.

[scotspine]

i don't know how you manage the stress/excitement sy

[thunderlizard]

insert into foo(foo1,foo2) values (bar1,bar2);
insert into foo(foo1,foo2) values (bar1,bar2);
insert into foo(foo1,foo2) values (bar1,bar2);

even so, an extra / at the end of all that could whizz the whole lot in again if it's anything like Oracle SQL*Plus.

[pzz76077]

3 of us have just PMd and agreed that we are all going to to throw a Zambian Quacha into the pot and have you assassinated.

PZZ

[TheFaQQer]

even so, an extra / at the end of all that could whizz the whole lot in again if it's anything like Oracle SQL*Plus.

That was my guess, but you never know.