Message-
> From: Ronan Lucio [mailto:[EMAIL PROTECTED]
> Sent: 27 April 2004 15:46
> To: [EMAIL PROTECTED]
> Subject: Standard of Column Names
>
> Hello,
>
> I´m doing the planing for an application that will use
> MySQL as database.
>
> So, I´d like to know your
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
"Ronan Lucio" <[EMAIL PROTECTED]> writes:
Hello,
I´m doing the planing for an application that will use
MySQL as database.
So, I´d like to know your opinions about the standard
for the column names.
Supposing that I should create a table nam
Harald,
> I don't see the necessity of the latter naming scheme since
>
> SELECT cod, name, description FROM car
>
> can also be written as
>
> SELECT car.cod, car.name, car.description FROM car
Do you know how it would be about portability?
Thanks,
Ronan
--
MySQL General Mailing List
Fo
Ruslan,
> IMHO:
> 1) Table name as prefix is unnecessary for me. It's norwegian notation
> which I hate.
> 2) Also I recomend look into ANSI SQL standard for reserved keywords.
> I've got experience of porting DB from MySQL(allow some keywords) to
> another DB, it's pain.
Thank you your answer.
D
Ronan Lucio wrote:
Hello,
I´m doing the planing for an application that will use
MySQL as database.
So, I´d like to know your opinions about the standard
for the column names.
Supposing that I should create a table named car.
Is it better to have either the column names (cod,
name, description) or
Hello,
I´m doing the planing for an application that will use
MySQL as database.
So, I´d like to know your opinions about the standard
for the column names.
Supposing that I should create a table named car.
Is it better to have either the column names (cod,
name, description) or (car_cod, car_na
