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]



Reply via email to