How do you name columns in MySQL tables?

Question

MySQL

Often you need to name something there key, order and especially name.
But these are reserved names. And how to be?
Name with some kind of prefix or what? It just turns out ugly that type

Article
  - id
  - article_name
  - description
  - author

And if you write a prefix to all fields, then it greatly lengthens everything later

Answer 1

1. Reserved words can be used by enclosing them in back quotes, `key`
2. name is a keyword, not a reserved one. And keywords are permitted as identifiers without quoting

Answer 2

There was a similar question. MySQL Link
- Table and Column Naming Recommendations?