I'm trying to run a sql command using the %sql magic. For some reason, when the table is named foo.db, I get an error saying "no table named foo.db". But when I rename the table to foo, it's able to connect to it and run commands properly. Could someone tell me why this is happening?
Asked
Active
Viewed 9 times
0
-
It's a **BAD IDEA** to use dot (.) in any sql names check [Is it okay to put dots in SQL Server database names?](https://dba.stackexchange.com/questions/1166/is-it-okay-to-put-dots-in-sql-server-database-names#:~:text=Complex%20SQL%20actions%20are%20processed,if%20the%20base%20is%20fine.&text=These%20errors%20may%20more%20often,of%20anything%20on%20sql%20server.) and [Is it good practice to use dots within table names in MySQL](https://stackoverflow.com/questions/41948399/is-it-good-practice-to-use-dots-within-table-names-in-mysql) – Kuro Neko May 18 '22 at 02:00