https://www.icyphoenix.com/viewtopic.php?f=35&t=3892&p=26538#p26538
-----------------------------------
moreteavicar
Thu 20 Mar, 2008 03:20

Re: MySQL Problems
-----------------------------------
[quote user="novice programmer" post="26521"][b]moreteavicar[/b], you have to type this exactily:

[code linenumbers=false]TYPE=MyISAM[/code]

Notice, all caps are capital except the "y".[/quote]No [b]novice programmer[/b]... mysql is [u]case insensitive[/u]. Read the docs next time ;) 

To help out, here we go or 5.1:

[quote="MySQL 5.1 Documentation"]"Keywords may be entered in any lettercase"[/quote]
Source: http://dev.mysql.com/doc/refman/5.1/en/entering-queries.html: 

Official engine declaration example with all CAPS:
[quote="MySQL 5.1 Documentation"]CREATE TABLE t (i INT) ENGINE = MYISAM;[/quote]
Source: http://dev.mysql.com/doc/refman/5.1/en/myisam-storage-engine.html

That caps are used at all is convention - but a logical convention, since it helps to distinguish between queries and table / field names. look in some of the phpbb / icy phoenix code, you sill see a few sql queries dotted about in lowercase - "select" as opposed to SELECT being a common one.

You should be able to issue the command: 
[code linenumbers=false]create table tablename (id int) engine = myisam; [/code] or 
[code linenumbers=false]create table tablename2 (id int) type = myisam; [/code] Try it... ;)


