I had that problem and solved it with prefixing the table name with the database name, so
select * from database.table
More Related Contents:
- How to create this type of JSON data from PHP [closed]
- how to write php code for the key press enter button when fill the form?
- Just using mysql real escape string [closed]
- Create hyperlink from html table row to open record on a new page
- mysql_fetch_array(): supplied argument is not a valid MySQL result resource [duplicate]
- I don’t know what’s wrong with my code. I’m a newbie. The prob is – Notice: Undefined variable: result [duplicate]
- Many-to-many relationships examples
- SELECT COUNT(*) AS count – How to use this count
- How to execute two mysql queries as one in PHP/MYSQL?
- Storing files in database Vs file system
- How to upload images into MySQL database using PHP code
- selecting unique values from a column
- MySQL Join two tables with comma separated values
- Create a dynamic mysql query using php variables
- How to enable mysqlnd for php?
- Mysql event error using php
- How to separate DATE and TIME from DATETIME in MySQL?
- How can I Use Prepared Statements in CodeIgniter
- How to echo out table rows from the db (php)
- mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
- How to display Unicode data with PHP [duplicate]
- PDO fetchAll group key-value pairs into assoc array
- MySQL Performance – “IN” Clause vs. Equals (=) for a Single Value [duplicate]
- Connect DATABASE Error TYPE: 2002: Permission denied
- MySQL skipping first row
- How to reverse order output of a MySQL query
- MySQL statement takes more than minute to execute
- Binding parameters for WHERE IN clause with PDO [duplicate]
- How to convert excel file into mysql database? [duplicate]
- Turkish characters are not displayed correctly [duplicate]