SQLSTATE[42S02]: Base table or view not found: 1146 Table doesn't exist
I have faced the very strange Mysql problem. I have the database name "DAVP" and having various tables. All the tables are existing with few of records.
Now I have queried to select some rows from one of table and surprise query showing error that the table "sark_rec" is not existing. It is wondering that the table "sark_rec" is existing!!.
I spend lot of time in Google but did not found any solution related to this strange problem.
So lastly I have solved it myself. I have just added database name just before table name with dot. see below solution sql query.
select *from DAVP.sark_rec;
Now I have queried to select some rows from one of table and surprise query showing error that the table "sark_rec" is not existing. It is wondering that the table "sark_rec" is existing!!.
I spend lot of time in Google but did not found any solution related to this strange problem.
So lastly I have solved it myself. I have just added database name just before table name with dot. see below solution sql query.
select *from DAVP.sark_rec;
0 comments:
Post a Comment