mysql error: MySQL server version the syntax to near type=InnoDB

This article illustrates the problem of mysql reporting error: MySQL server version the syntax use near type=InnoDB. To share for your reference, the details are as follows:

1. The question is:

mysql reported the following error when using sql statement to build the table:

You have an error in your SQL syntax; check the manual corresponds to your server for the right use near 'type=InnoDB 'at line 1

2. Solutions:

This error is due to the fact that some versions of mysql do not support type. You can just change the type keyword to ENGINE.

I hope this article has been helpful in designing MySQL database.