New answers tagged view
0
Long story short: You do not have the user 'lumicrm'@'%' on the DB Server.
Login to MySQL and run
SELECT user,host FROM mysql.user WHERE user='lumicrm';
Let's say you see the user 'lumicrm'@'localhost'
You have to create the user so that the view can be recognized. There are three(3) things you can try
Try This #1
Login to MySQL as lumicrm and run ...
1
I would like to suggest the following:
SUGGESTION #1 : Query as follows
SET @GivenKind = '...';
SET @GivenDate = d;
SELECT * FROM table WHERE kind=@GivenKind
AND startdate < @GivenDate
ORDER BY startdate DESC LIMIT 1;
SUGGESTION #2 : Define a Good Index
In your question you said
Actually in the real problem column named here startdate and kind ...
1
This is easy.
let @d be the date and @k be the kind :
select *
from table a
where
startdate = (select max(b.startdate)
from table b
where b.startdate < @d
and b.kind = @k)
and a.kind = @k
11
Partitioned views are a (very) old technique for partitioning data that are very rarely used today. Oracle added the ability to partition tables back in Oracle 8, which provides much more functionality than partitioned views, at which point partitioned views became obsolete. The only reason to consider using partitioned views would be if you can't afford a ...
Top 50 recent answers are included
