Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. MySql Strange Problem :)
Forum Updated to NodeBB v4.3 + New Features

MySql Strange Problem :)

Scheduled Pinned Locked Moved General and Desktop
4 Posts 2 Posters 1.2k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    mmallad
    wrote on last edited by
    #1

    My Query gets successfully executed.
    But I dont see inserted record.
    When I insert records from mysql prompt than it shows that PRIMARY KEY which was set to AUTO_INCREMENT has been incremented. Thats means the query from Qt was success but the record does not show up.
    I have checked everything. I have passed all values in correct order.

    Dpak Malla

    1 Reply Last reply
    0
    • Q Offline
      Q Offline
      qxoz
      wrote on last edited by
      #2

      Can you show query?
      and some code.

      1 Reply Last reply
      0
      • M Offline
        M Offline
        mmallad
        wrote on last edited by
        #3

        I have used transaction and did not committed it. When I did that it worked.
        But the thing is why mysql incremented the ID field when transaction is not committed.
        Is this Bug or something Can You Help qxoz :)

        Dpak Malla

        1 Reply Last reply
        0
        • Q Offline
          Q Offline
          qxoz
          wrote on last edited by
          #4

          I think it's ok, because it reserve the "id" for a writing data after committing. If not reserve, after committing there can be written two records with identical id.

          1 Reply Last reply
          0

          • Login

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • Users
          • Groups
          • Search
          • Get Qt Extensions
          • Unsolved