view's query

[expired user #9169]'s profile image [expired user #9169] posted 9 years ago in General Permalink
Hello,
I have problem and don't know how to fix that. When I use database for example from XAMMP it's ok. But problem is with another mysql database (Percona).

I make simple view for example "select * from table_name", save that, I open another table and back to this new created view to refresh. My query change from "select * from table_name" to very long query like " select 'table_name'.'colmun1' AS 'column1','table_name'.'colmun2' AS 'column2','table_name'.'colmun3' AS 'column3' ...... from 'table_name';

I don't know why this happend. Is some kind workaround for this?

Please login to leave a reply, or register at first.