Re: Standard of Column Names

[Ruslan U. Zakirov]

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 (car_cod, car_name, car_description)?
		Hello.
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.

		Good luck. Ruslan.

Thanks,
Ronan





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]