Backticks in MySQL queries?

**frost** · 12-23-2007, 01:30 AM

I notice when I do queries in phpMyAdmin, it often uses backticks for table names and fields:

Code:

DELETE  FROM  `users`  WHERE  `users`.`id`  =11 LIMIT 1

Since they aren't required, is there any real benefit to use backticks in my script queries?

**klaroen** · 12-23-2007, 05:43 AM

I don't really know the extra purpose of them.... but if you do your query withouth the backtickts proparly, you don't need to worry.

**chrishirst** · 12-23-2007, 08:17 AM

Using "backticks" on database and column names avoids any issues where the entity name is a reserved word.