mysql - SequelizeDatabaseError

Поддержка
  • При выполнении запроса

    START TRANSACTION;
    INSERT INTO banned
    SELECT * FROM accounts WHERE login=[[TCB_LOGIN]];
    DELETE FROM accounts WHERE login=[[TCB_LOGIN]];
    COMMIT;
    

    получаю ошибку

    Поток №1 : SequelizeDatabaseError: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO banned SELECT * FROM accounts WHERE login=' at line 2
    

    Запрос рабочий. Это баг БАСа или nodejs либы?

  • @wwhite скорее всего ковычки надо добавить

  • 0 Votes
    7 Posts
    743 Views
  • 0 Votes
    4 Posts
    389 Views
  • 0 Votes
    4 Posts
    542 Views
  • 0 Votes
    10 Posts
    782 Views
  • 0 Votes
    11 Posts
    1215 Views