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?