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.
6 messages in com.mysql.lists.mysqlRe: Standard of Column Names
