Unsupported Screen Size: The viewport size is too small for the theme to render properly.

cant rollback!!

forums › forums › SQLyog › Using SQLyog › cant rollback!!

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • May 31, 2003 at 8:35 am #7988
      jayson_13
      Member

      :ph34r: This is what i did using sqlYog 3.11.

      begin;

      delete from chqtrans; <--- ok! all the records had been deleted rollback; <-- seems ok because 0 rows affected select * from chqtrans <-- no row returned !!!! my table type is Innodb and there are records in chqtrans table. Why?

    • May 31, 2003 at 2:19 pm #14426
      CalEvans
      Member

      Hmmmmm….never seen this happen with InnoDB.

      Re-load from a backup, recreate the experiment, watch your MySQL log file. Did the begin get into the logfile? Does your errorfile show anything?

      BTW, it is default behavior for rollback and commit to return 0 rows affected. That's really for select, update, delete although all DML commands return the number of rows affected.

      HTH,

      =C=

    • June 2, 2003 at 12:15 am #14427
      jayson_13
      Member

      begin & rollback statement do not appear in the log file.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.