Home

MySQL Views Presentation at the September 2008 Boston MySQL User Group

Posted September 12th, 2008 by sheeri

This Monday, September 8th, the Boston MySQL User Group broke our 2-month summer hiatus with a presentation on MySQL Views.

The slides can be downloaded from http://www.technocation.org/files/doc/2008_09_Views.pdf -- 89 kB, .pdf format.

The 199 Mb .flv file can be downloaded at http://technocation.org/node/621/download or played directly in your browser at http://technocation.org/node/621/play.

The presentation covers:
* Defining views, changing views, deleting views
* Using views for column and row level security
* Using views for schema abstraction
* Simulating check constraints using views
* Performance implications
* How to find out which tables are views, and information about views
* What a materialized view is, and that MySQL does not have them
* What makes a view updateable
* Problems with updateable views
* How views interact with replication

Trackback URL for this post:

http://technocation.org/trackback/621

pls give me ppt on my sql

On September 27th, 2008 viveknahar (not verified) says:

pls give me ppt on my sql ple send me on my email id

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • You may use <swf file="song.mp3"> to display Flash files inline
  • Avast! This website be taken over by pirates on September 19th. Yarr!
  • Each email address will be obfuscated in a human readable fashion and replaced with a spamproof clickable link, without loosing the mailto URL scheme semantics and operations.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

More information about formatting options

Captcha
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
1 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.