Results 1 to 2 of 2

Thread: how to check mysql version

  1. #1
    Join Date
    Dec 2009
    Posts
    65
    Thanks
    10
    Thanked 4 Times in 4 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows Android

    Default how to check mysql version

    After connecting to database i wanted to (from my application) alter some tables and add field type JSON, but the json type is available since 5.7.8
    is there elegant way to check mysql version is not sufficient?

  2. #2
    Join Date
    Jan 2008
    Location
    Alameda, CA, USA
    Posts
    5,230
    Thanks
    302
    Thanked 864 Times in 851 Posts
    Qt products
    Qt5
    Platforms
    Windows

    Default Re: how to check mysql version

    A SELECT VERSION() SQL statement should do it. See this.
    <=== The Great Pumpkin says ===>
    Please use CODE tags when posting source code so it is more readable. Click "Go Advanced" and then the "#" icon to insert the tags. Paste your code between them.

Similar Threads

  1. [SOLVED] MySQL - Check credentials?
    By xyz247 in forum Qt Programming
    Replies: 5
    Last Post: 28th October 2012, 06:30
  2. How to check or set GLSL version?
    By bartosz.kwasniewski in forum Newbie
    Replies: 2
    Last Post: 20th December 2010, 23:50
  3. QMake Check for Qt version in QMake
    By PaladinOfKaos in forum Qt Tools
    Replies: 1
    Last Post: 24th October 2010, 14:41
  4. Check if a table exists in a mysql database
    By graciano in forum Qt Programming
    Replies: 8
    Last Post: 5th November 2009, 02:44
  5. Replies: 5
    Last Post: 5th June 2009, 10:07

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.