• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Workshop

The Workshop area is meant to reinforce your reading with a series of questions and exercises.

Q&A

Q1: Will MySQL ever support views and sub-queries?
A1: Yes, both of these features are available in MySQL 4.x.
Q2:How can I compare dates within SQL?
A2: Use the same comparison operators that you use with other data types (=, <, >, and so on). The SQL Server will handle doing the hard work for you.
Q3:Is it possible to join more than two tables?
A3: Absolutely. The reason the examples consist of a single table is to limit the amount of space they take up. You can just as easily join three, four, or more otables within SQL.
Q4:Can I update data within a view?
A4: It depends on the features of your database server. Many servers offer the feature of allowing you to update view data just like any other table and even reject updates if the updated data would no longer be included within the view.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint