MySQL error with ‘TYPE=MyISAM’

Just a quick note:

MySQL has deprecated the use of the keyword ‘TYPE’ to define the database engine. The database engine is now defined using the syntax engine.

So if you are using a script which still uses this keyword, you will get an error message like:

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=MyISAM’ at line 11.

To correct this error, simply replace your engine definition from TYPE=MyISAM to ENGINE=MyISAM.

So now you would define a table like this:

 CREATE TABLE `mytable` (
		  `post_id` int(10) unsigned NOT NULL auto_increment,
		  `title` varchar(255) NOT NULL default '',
		  `desc` text NOT NULL,
		  `comments` text NOT NULL,
		  PRIMARY KEY  (`post_id`),
		  KEY `word_title` (`word_title`(5)),
		  FULLTEXT KEY `word_desc` (`word_desc`)

By Bhaskar

My name is Bhaskar. I am a CTO and a startup techno guy with 10+ years of experience startups.
Full-time coding in Python, React. Part-time coding in Haskell, Java, C.
Scientifically interested in Music, BioInformatics, Linear Algebra, Category theory, Graph theory.

What excites me: anything that has the potential to disrupt the status quo.

Looking for technical support on a startup idea ?
write at : bhaskar {-at-}