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

Q&A

Q1: Will MySQL ever support views and subqueries?
A1: With any luck, yes. Both of these features are currently on the To Do list for the software.
Q2:How can I compare dates within SQL?
A2: Use the same comparison operators that you use with other datatypes (=, <, >, 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 tables within the 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