trying to insert data into view but im getting the run around(no where).
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
1. create or replace algorithm=merge definer=`user`@`localhost` sql security definer view `test`.`Domain` as select
2. 'test'.'name'.'id' as id,
3. aes_encrypt(`test`.`name`.`name`,'key') AS `Name`,
4. `test`.`name`.`date` AS `Date`
5. from `test`.`domains`;
the view consists of one table. i understand the rules of views.
its that im using aes_encrypt in the creation of the view, and it doesnt encrypt the data it errors. Ive created a test view with out the aes_encrypt in the view and it inserts fine no prob. what i would like is to use aes_encrypt in the view not the insert statement.
less overhead on app.
i've used aes_decrypt fine in the view no prob there.