Re: creating a table is there another way to do this?

[Barry Galbraith]

Do you keep making typos?
You could always write your "create table ... " in a text editor of your choice, allowing you to correct, and re-correct your spelling until you are satisfied.
Then copy the text from the text editor and paste it to the mysql commandline client.
On the subject of mixing case.
Words like SELECT, FROM, WHERE etc can be either upper or lower case. MySQL doesn't care.
For database objects, like table names, case depends on your operating system.
*nix type systems are case sensitive, mytable and myTable are two different things. On Windows, they are the same thing.
Recommendation is that database objects should always be lowercase, so that code will work on any system.

Good luck,
Barry.