Search code examples
mysqlsqlsql-serverequivalent

What is MYSQL equivalent for DATABASENAME..TABLENAME?


In MSSQL Server, I can execute the following SQL

SELECT * FROM DATABASENAME..TABLENAME

or

SELECT * FROM DATABASENAME.dbo.TABLENAME

What is the equivalent syntax on MYSQL to perform this SQL (DATABASE..TABLE)?


Solution

  • If you want to select all the records from a database table the syntax is quite similar it's

    SELECT * FROM DatabaseName.TableName