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. treating SQLite like MySQL
Forum Updated to NodeBB v4.3 + New Features

treating SQLite like MySQL

Scheduled Pinned Locked Moved Unsolved General and Desktop
2 Posts 2 Posters 646 Views
  • 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.
  • pluxyyP Offline
    pluxyyP Offline
    pluxyy
    wrote on last edited by
    #1

    Hello,

    I have a qustion just to be sure or for confirmation purposes. Recently I started using SQLite. A few months ago I uses MySQL and it worked fine. Now I am working wicht SQLite and I have some trouble.
    Can I use the same Classes to dela with a SQLite DB as for MySQL ?
    If this ist the case I can narrow down the problem.

    Thanks!
    Peter

    1 Reply Last reply
    0
    • P Offline
      P Offline
      panosk
      wrote on last edited by
      #2

      Hi,

      For most general SQL work and if you're not using very exotic features I guess you'll have no trouble spotting down the differences and adapting your SQL code. One that comes right in my mind is the different statement for selecting the last inserted row, SELECT last_insert_id() in MySQL and SELECT last_insert_rowid() in SQLite but there should be a few more.
      You could probably search the net and write down the differences and then see if you use any of those in your code and how they could affect possible data types, classes, etc.
      Otherwise, you could post specific problems and try to get specific help.

      1 Reply Last reply
      1

      • Login

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