MySQL Forums
Forum List  »  Newbie

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


words like decimal, varchar, PURCHASE_PRICE DECIMAL
Reserved words, decimal, varchar can be either case. If PURCHASE_PRICE is a column name (a database object) then on Windows, upper and lower case are the same, but on *nix they are different.
For compatibility sake, always use lowercase for database object names. Saves heartache should you move your (Windows) development code to (*nix) production server.

Good luck,

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.