Error 1046 No database Selected, how to resolve?

You need to tell MySQL which database to use:

USE database_name;

before you create a table.

In case the database does not exist, you need to create it as:

CREATE DATABASE database_name;

followed by:

USE database_name;

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. MySQL – Operand should contain 1 column(s)
  5. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. MySQL create table if not exists and insert record only if table was created
  8. How do I use properly CASE..WHEN in MySQL
  9. How can I do a FULL OUTER JOIN in MySQL?
  10. MySQL query String contains
  11. What’s the difference between VARCHAR and CHAR?
  12. Case statement in MySQL
  13. How to declare a variable in MySQL?
  14. MySQL Cannot Add Foreign Key Constraint
  15. How to split the name string in mysql?
  16. How do I import an SQL file using the command line in MySQL?
  17. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  18. mysql Foreign key constraint is incorrectly formed error
  19. MySQL: Invalid use of group function
  20. How can I return pivot table output in MySQL?
  21. Compare dates in MySQL
  22. MySQL “WITH” clause
  23. MySQL Multiple Joins in one query?
  24. Error Code: 2013. Lost connection to MySQL server during query
  25. MySQL syntax for Join Update
  26. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  27. how to drop partition without dropping data in MySQL?
  28. MySQL combine two columns into one column
  29. Simple way to calculate median with MySQL
  30. MySQL Error 1264: out of range value for column
  31. Remove duplicate rows in MySQL
  32. How to SUM and SUBTRACT using SQL?
  33. Cast from VARCHAR to INT – MySQL
  34. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  35. How do you force mysql LIKE to be case sensitive?
  36. MySQL – UPDATE multiple rows with different values in one query
  37. How to create a MySQL hierarchical recursive query?
  38. ERROR 1148: The used command is not allowed with this MySQL version
  39. Insert into a MySQL table or update if exists
  40. How to round down to nearest integer in MySQL?
  41. MySQL starts with searching issue
  42. Query to convert from datetime to date mysql
  43. Is it possible to GROUP BY multiple columns using MySQL?
  44. MySQL error: key specification without a key length
  45. Best way to test if a row exists in a MySQL table
  46. Check if MySQL table exists without using “select from” syntax?
  47. MySQL equivalent of DECODE function in Oracle
  48. mysql update column with value from another table
  49. The used SELECT statements have a different number of columns
  50. How to delete from multiple tables in MySQL?
  51. MySQL: Can’t create table (errno: 150)
  52. How to copy a row and insert in same table with a autoincrement field in MySQL?
  53. Join vs. sub-query
  54. Alternative to except in MySQL
  55. Equivalent of explode() to work with strings in MySQL
  56. ROW_NUMBER() in MySQ
  57. MySQL OPTIMIZE all tables?
  58. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  59. MySQL – Get row number on select
  60. MySQL error: Unknown column in ‘where clause’
  61. How to truncate the text returned for a column in a MySQL query
  62. Using union and order by clause in mysql
  63. MySQL LIKE IN()?
  64. Efficiently convert rows to columns in sql server
  65. Nested select statement in SQL Server
  66. Cannot delete or update a parent row: a foreign key constraint fails
  67. Rename a column in MySQL
  68. Sql Server equivalent of a COUNTIF aggregate function
  69. Column name or number of supplied values does not match table definition
  70. Simple PHP Pagination script
  71. ORA-12560: TNS:protocol adaptor error
  72. SQL – HAVING vs. WHERE
  73. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  74. difference between primary key and unique key
  75. String or binary data would be truncated. The statement has been terminated
  76. Error converting data type varchar to float
  77. How to concatenate text from multiple rows into a single text string in SQL Server
  78. Count(*) vs Count(1) – SQL Server
  79. Unknown Column In Where Clause
  80. “You tried to execute a query that does not include the specified aggregate function”
  81. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  82. SQL Server dynamic PIVOT query?
  83. LEFT function in Oracle
  84. SQLite string contains other string query
  85. How to get the count of each distinct value in a column?
  86. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  87. How do I see the mysql query generated by get_posts( $args )?
  88. Better way to migrate to server?
  89. Making a query to the DB using same parameters of loop
  90. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  91. Why does changing Database Table Prefixes result in loss of content?
  92. WP MultiSite: Can’t select database error after changing to new domain
  93. Use variable in SQL statement
  94. Help me SELECT thumbnail from SQL and use
  95. Database SQL query error
  96. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  97. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  98. can’t delete a row from post_meta table
  99. Creating a “forum” – showing last post or last commented post
  100. Replace Unwanted Space in Post Content URL

Leave a Comment