One way MS Access Differs from MySQL

Previously, I shot some holes in an article touting the advantages of MySQL over MS Access. Today I want to show one significant advantage MySQL does have. The advantage pertains to the implementation of JOIN operators. First, pointers to documentation for each product:

MS Access JET JOIN Syntax: INNER JOIN, LEFT JOIN, RIGHT JOIN MySQL [...]

March 3rd, 2005 | Category: SQL | Comments are closed

Access vs MySQL – Refuting article errors

While ordinarily, I’m no defender of Microsoft applications, while searching for a feature comparison between MySQL and MS Access I found the article MySQL versus Access to be very wrong on several points. If you do a feature comparision, at least check that your data is correct. Now, I could not find a published date [...]

January 31st, 2005 | Category: Information Technology (IT), SQL | Comments are closed

Using SQL Properly

With the flurry of people that became web developers the past few years, quite a few gained their knowledge and skill using the time-proven hands-on method. This enabled not a few people to gain skill and knowledge needed for web development. One unfortunate draw-back to this however is incomplete knowledge. Oft times people are not [...]

October 20th, 2004 | Category: SQL | Comments are closed