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

New Topic

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

Posted by: Barry Galbraith
Date: September 21, 2022 06:07PM

Quote

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,
Barry.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

creating a table is there another way to do this?

Mark Roberge

September 21, 2022 12:45PM

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

Barry Galbraith

September 21, 2022 05:47PM

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

Mark Roberge

September 21, 2022 05:56PM

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

Mark Roberge

September 21, 2022 05:59PM

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

Barry Galbraith

September 21, 2022 06:07PM

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

Barry Galbraith

September 21, 2022 06:02PM

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

Mark Roberge

September 21, 2022 07:34PM

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

Barry Galbraith

September 21, 2022 07:48PM

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

Barry Galbraith

September 21, 2022 08:22PM

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

Mark Roberge

September 22, 2022 08:00AM

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

Mark Roberge

September 22, 2022 09:31AM

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

Barry Galbraith

September 22, 2022 03:50PM

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

Mark Roberge

September 22, 2022 06:05PM

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

Barry Galbraith

September 22, 2022 06:12PM

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

Barry Galbraith

September 22, 2022 06:25PM

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.