Asking MySQL if InnoDB is available

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • M Taylor
    #1

    Asking MySQL if InnoDB is available

    Hi,

    Is it possible to 'ask' MySQL using SQL if InnoDB is available and
    usable?

    I am writing a GUI database app that has a 'create table' function, I
    want to give the user the option of creating an InnoDB database, but
    only if InnoDB is available, can this information be found out from
    SQL (I'm using JDBC)

    Thanks in advance

    Moray
    Tags: None
    • Chuck Gadd
      #2
      Re: Asking MySQL if InnoDB is available

      On 22 Nov 2003 12:23:24 -0800, bigmugen@freeuk .com (M Taylor) wrote:
      [color=blue]
      >Hi,
      >
      >Is it possible to 'ask' MySQL using SQL if InnoDB is available and
      >usable?
      >
      >I am writing a GUI database app that has a 'create table' function, I
      >want to give the user the option of creating an InnoDB database, but
      >only if InnoDB is available, can this information be found out from
      >SQL (I'm using JDBC)[/color]


      show variables like 'have_innodb'



      Chuck Gadd
      404 Not Found
      http://www.csd.net/~cgadd/aqua

        Comment

        • Chuck Gadd
          #3
          Re: Asking MySQL if InnoDB is available

          On 22 Nov 2003 12:23:24 -0800, bigmugen@freeuk .com (M Taylor) wrote:
          [color=blue]
          >Hi,
          >
          >Is it possible to 'ask' MySQL using SQL if InnoDB is available and
          >usable?
          >
          >I am writing a GUI database app that has a 'create table' function, I
          >want to give the user the option of creating an InnoDB database, but
          >only if InnoDB is available, can this information be found out from
          >SQL (I'm using JDBC)[/color]


          show variables like 'have_innodb'



          Chuck Gadd
          404 Not Found
          http://www.csd.net/~cgadd/aqua

            Comment

            • M Taylor
              #4
              Re: Asking MySQL if InnoDB is available

              Chuck Gadd <cgadd@cfxc.com > wrote in message news:<ae58sv4l9 t3t9ooj1hqv9vv0 865qt585po@4ax. com>...[color=blue]
              > On 22 Nov 2003 12:23:24 -0800, bigmugen@freeuk .com (M Taylor) wrote:
              >[color=green]
              > >Hi,
              > >
              > >Is it possible to 'ask' MySQL using SQL if InnoDB is available and
              > >usable?
              > >
              > >I am writing a GUI database app that has a 'create table' function, I
              > >want to give the user the option of creating an InnoDB database, but
              > >only if InnoDB is available, can this information be found out from
              > >SQL (I'm using JDBC)[/color]
              >
              >
              > show variables like 'have_innodb'
              >
              >
              >
              > Chuck Gadd
              > http://www.csd.net/~cgadd/aqua[/color]

              That looks just the job, thanks v much.

              Moray

                Comment

                • M Taylor
                  #5
                  Re: Asking MySQL if InnoDB is available

                  Chuck Gadd <cgadd@cfxc.com > wrote in message news:<ae58sv4l9 t3t9ooj1hqv9vv0 865qt585po@4ax. com>...[color=blue]
                  > On 22 Nov 2003 12:23:24 -0800, bigmugen@freeuk .com (M Taylor) wrote:
                  >[color=green]
                  > >Hi,
                  > >
                  > >Is it possible to 'ask' MySQL using SQL if InnoDB is available and
                  > >usable?
                  > >
                  > >I am writing a GUI database app that has a 'create table' function, I
                  > >want to give the user the option of creating an InnoDB database, but
                  > >only if InnoDB is available, can this information be found out from
                  > >SQL (I'm using JDBC)[/color]
                  >
                  >
                  > show variables like 'have_innodb'
                  >
                  >
                  >
                  > Chuck Gadd
                  > http://www.csd.net/~cgadd/aqua[/color]

                  That looks just the job, thanks v much.

                  Moray

                    Comment

                    Previous template Next
                    Working...