MySQL Forums
Forum List  »  Newbie

create a view which adds new data to a table
Posted by: Paul Smith
Date: August 01, 2015 08:51PM

I would like to create a view which inserts a new record into a table.

I know how to create a view but I am having problems with inserting the data.

My code:
CREATE VIEW test
INSERT INTO `mydatabase`.`tbltest` (`TestID`, `Testname`, `Location`) VALUES ('6', 'Sample Test', 'room1');

thanks for your help

Options: ReplyQuote


Subject
Written By
Posted
create a view which adds new data to a table
August 01, 2015 08:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.