MySQL Forums
Forum List  »  Newbie

need some explanation
Posted by: sergey lakantarov
Date: May 04, 2015 11:22AM

so i have this table-

SELECT color FROM my_db.books;
+---------+
| color |
+---------+
| Gopal |
| Manisha |
| Javed |
+---------+
3 rows in set (0.00 sec)

and i saw some syntax online, and i tested it, and its working-

SELECT abcd.``1234.e.color FROM my_db.books;
+---------+
| color |
+---------+
| Gopal |
| Manisha |
| Javed |
+---------+
3 rows in set (0.00 sec)

and this also-

SELECT color FROM my_db 123.e.books;
+---------+
| color |
+---------+
| Gopal |
| Manisha |
| Javed |
+---------+
3 rows in set (0.00 sec)

why it works?

Options: ReplyQuote


Subject
Written By
Posted
need some explanation
May 04, 2015 11:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.