is there in mysql Views ,stored procedure and trigger???
if there is how can i do it please?
AFAIK, mySQL doesn't support those. You'd have to move to something more heavyweight like interbase or postgresql for those features