Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,960
    Thanks
    120
    Thanked 76 Times in 76 Posts

    Subquery returns more than one row ?

    EDIT: Newer mind that, message comes from trigger.


    Code:
    insert ignore into t1 (a,b,c) 
    select a,b,c from t
    t1 has unique index on a field.

    What does error mean ? I know that there are more rows in subquery obviously.
    Last edited by BubikolRamios; 12-17-2013 at 07:57 AM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •