MySQL Forums
Forum List  »  Newbie

Re: MySQL Tables
Posted by: Phillip Ward
Date: September 02, 2022 03:56AM

Never use spaces in table or column names.

They should never be seen outside of the database, so it doesn't matter what you name them.

CREATE TABLE cruise
( column_name VARCHAR(20) NOT NULL
, data_type VARCHAR(20) NOT NULL
, length INT
, decimal_places INT
, PRIMARY KEY ( column_name ) 
);

As an aside: this is a rather strange looking table.
It looks more like a Data Dictionary table that describes other table columns, rather than Data relating to a "cruise". But hey; YMMV.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
September 01, 2022 08:47AM
September 01, 2022 11:19AM
September 02, 2022 10:45AM
Re: MySQL Tables
September 02, 2022 03:56AM


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.