Entry

Database: MySQL: Table: InnoDb: Create: Check: How to: How to check if you can create InnoDb tables?

Mar 19th, 2005 09:15
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 14 March 2005 - 04:21 pm ----------------------

Database: MySQL: Table: InnoDb: Create: Check: How to: How to check if 
you can create InnoDb tables?

---

Steps: Overview:

 1. -Start MySql
     (you will need version 3.23.29 or higher)

 2. -Run the SQL query

--- cut here: begin --------------------------------------------------

SHOW VARIABLES LIKE 'have_innodb';

--- cut here: end ----------------------------------------------------

 3. -This should show

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | YES   |
+---------------+-------+

---
---

Book: see also:

---

[book: source: author: Dubois, Paul - title: MySql cookbook - 
publisher: O'Reilly - ISBN: 0-596-00145-2 - year: 2002 - pages: 1022]

---
---

Internet: see also:

---

Database: Language: SQL: Overview: Can you give an overview of links 
about SQL?
http://www.faqts.com/knowledge_base/view.phtml/aid/32811/fid/54

----------------------------------------------------------------------