• FellowHuman@lemmy.world
    15·
    1 year ago

    Hope that the behavior is enum and indexed. …and that the table doesn’t have to many columns …and there aren’t many nice people …god damn it just select only what you need and use limit

    • Alien Nathan Edward@lemm.eeEnglish
      3·
      1 year ago

      select only what you need and use limit

      you don’t know the structure of the contacts table, and do you really want christmas gifts to only go to the first x number of nice people?

      update contacts set name = ‘Grinch’ where name = ‘FellowHuman’;