Does MySQL allows to create database with dot?

by

You can’t use the dot in a database name. Also, I’d avoid using it in any identifier. A common convention is to use underscore instead. It will serve the same purpose and will avoid a LOT of confusion. If you do have a good reason for using strange and otherwise-illegal characters in a table or field name, then you have to escape it.

to escape identifiers in MySQL, use the backtick:

SELECT `select`, `some.field name`, `crazy()naming+here`
FROM `my-=+table`

Getting into the habit of backticking all field names regardless of whether you need to is a good practice in my opinion, but that’s another story.

More Related Contents:

  1. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Is there a MySQL option/feature to track history of changes to records?
  4. Binary Data in MySQL [closed]
  5. Using an Alias in SQL Calculations
  6. Can a table field contain a hyphen?
  7. Auto Generate Database Diagram MySQL [closed]
  8. Check for x consecutive days – given timestamps in database
  9. MySQL Insert Into from one Database in another
  10. How do I get the ID of multiple inserted rows in MySQL?
  11. Case statement in MySQL
  12. What resources exist for Database performance-tuning? [closed]
  13. How to connect to MySQL from the command line
  14. How to find out the MySQL root password
  15. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  16. How to display open transactions in MySQL
  17. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  18. MySQL query, MAX() + GROUP BY
  19. Easiest way to copy a table from one database to another?
  20. What are the differences between the BLOB and TEXT datatypes in MySQL?
  21. What is the best way to store media files on a database?
  22. Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
  23. remove all numeric characters from column mysql
  24. MySQL: Check if the user exists and drop it
  25. WooCommerce: Finding the products in database
  26. Is it unreasonable to assign a MySQL database to each user on my site?
  27. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
  28. Create a new database with MySQL Workbench
  29. Optimistic locking in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment