• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Collapse

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

  • You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
  • You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
  • If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Previously on "Two for one special offer"

Collapse

  • TheFaQQer
    replied
    Originally posted by thunderlizard View Post
    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.

    Leave a comment:


  • pzz76077
    replied
    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

    Leave a comment:


  • thunderlizard
    replied
    Originally posted by suityou01 View Post
    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.

    Leave a comment:


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

    Leave a comment:


  • suityou01
    replied
    Originally posted by TheFaQQer View Post
    Sounds like you have double end of line terminators, e.g.

    Code:
    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.

    Leave a comment:


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

    Code:
    INSERT INTO foo VALUES (123);
    /

    Leave a comment:


  • suityou01
    replied
    Originally posted by suityou01 View Post
    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

    Leave a comment:


  • suityou01
    started a topic Two for one special offer

    Two for one special offer

    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.

Working...
X