top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Materialized Views in MYSQL

0 votes
348 views

I have a question about the materialized views , i remember in the DBA course my trainer said me. In Mysql doesn't exist this type views like Oracle. But My boss think the opposite.
In the new version has this type of view? and the diferences the differences between views Mysql and Oracle?

posted Jun 23, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes
 
Best answer

*where* do you see there *any* word about *MATERIALIZED* views except a comment with the words "Since MySQL currently doesn't support materialized views, here is simple way to simulate materialized views that consists on creating a static table and a robust updating script"?

answer Jun 23, 2013 by anonymous
0 votes

I think you're operating off of old information:

http://dev.mysql.com/doc/refman/5.0/en/create-view.html

answer Jun 23, 2013 by anonymous
Similar Questions
0 votes

How can I insert data into one table from two other tables where i have three tables namely users, role and userrole.
Now I want to insert the data into userrole table from users table and role table with a single statement.

...