Does different quotation marks mean different things?

[Samishii23]

Hello, I'm not too new to MySQL, but this has kinda been bugging me for a little while now, and I want an answer if possible.

Most Tutorials out there on the web usually feature MySQL code like this:

SELECT id,name,password FROM users LIMIT 1

Since I started using phpMyAdmin to manage my home database projects, I had noticed it uses:

SELECT `id`,`name`,`password` FROM `users` LIMIT 1

I know also from experience, if when dealing with INT, DOUBLE, etc using double quotes (") causes an error. ( I don't know if theres a configuration that could turn this off or not ) But just now I was doing something in phpMyAdmin, and I noticed when doing an UPDATE query, it had used single quotes (') for all the values.

Can anyone tell me the differences or w/e they may or may not be?

[AutumnsDecay]

I couldn't figure out the right way to explain it, so I decided to do a search. This explains it in a bit of detail.

http://stackoverflow.com/questions/214309/do-different-databases-use-different-name-quote