Mysql error: MySQL server version for the right syntax to use near type = InnoDB solution, syntaxinnodb

Mysql error: MySQL server version for the right syntax to use near type = InnoDB solution, syntaxinnodb

This article describes how to solve the mysql error: MySQL server version for the right syntax to use near type = InnoDB. We will share this with you for your reference. The details are as follows:

I. Problems:

When using SQL statements to create a table at work, mysql reports the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type = innodb' at line 1

Ii. solution:

This error occurs because some versions of mysql do not support type writing. You can change the type keyword to ENGINE.

I hope this article will help you design your MySQL database.

Articles you may be interested in:

• PHP compilation error configure error Cannot find libmysqlclient under usr Solution
• Mysql service failed to start error 1067 solution (mysql startup error 1067)
• How to enable bin-log mysql to report errors
• MySql error Table mysql. plugin doesn't exist Solution
• Phpmyadmin error: #2003 how can I log on to the MySQL server?
• Can't create/write to file ''c: \ WINDOWS \ TEMP \... MYSQL error Solution
• How to solve the MySQL Administrator Logon Error
• MySQL prompts that The InnoDB feature is disabled and The InnoDB must be enabled.
• How to explain the relationship between Innodb Transaction isolation level and lock in MySQL
• How to Use the InnoDB Storage engine lock in MySQL
• MySQL InnoDB Engine getting started tutorial