trying to insert data into view but im getting the run around.
i would like to do this because its less threads directly to the table.
could you give me an example please.
I've followed the guidelines from mysql but im stuck. their are no defaults except ( auto inc) and i've included all rows from the table.
heres the view code
-
create or replace algorithm=merge definer=`user`@`localhost` sql security definer view `test`.`Domain` as select
-
'test'.'name'.'id' as id,
-
aes_encrypt(`test`.`name`.`name`,'key') AS `Name`,
-
`test`.`name`.`date` AS `Date`
-
from `test`.`domains`;
-
thanks in advance for your help.
