MySQL Forums
Forum List  »  Newbie

Re: creating a table is there another way to do this?
Posted by: Barry Galbraith
Date: September 21, 2022 05:47PM

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.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.