A virtual table that represents the data in one or more tables in an alternative way.
0
votes
1answer
33 views
Database user specified as a definer
I have a view in my database. problem is below
Error
SQL query:
SELECT *
FROM `lumiin_crm_prod`.`v_contact`
LIMIT 1 ;
MySQL said:
1449 - The user specified as a definer ('lumicrm'@'%') ...
1
vote
0answers
30 views
CouchDB views and references
Not sure if/how it is intended to be done but i am trying to match up all the active document in my database with the author of it:
function(doc) {
if (doc.data.active && doc.data.active ...
0
votes
0answers
23 views
Procedure after commit
I have an application which periodically will insert large amounts of data, from that data I build a few materialized views (well emulate by creating a table from a view and replacing it with the ...
0
votes
0answers
20 views
View is not dropping
I tried removing a view in HeidiSQL, and it froze bunch of times. So I connected to a database with Putty, ran a command
DROP VIEW item_view;
and nothing happened, its still running and command ...
0
votes
0answers
25 views
how to tranlate MySQL code so that it can be used in PHP MyAdmin
I have a problem with my database view that is answered in another post. The answer shows the following solution:
mysql -uusername -ppassword -A --skip-column-names -e"
SELECT CONCAT('SHOW ...
