Bryan Stevenson wrote: > > I'm not all that familiar with MySQL, but from what I hear it's not as good > as MS SQL Server (which I use along with Oracle).
"good" depends on the task. > The MySQL.com website says that upcoming features for version 5 include: > -views > -stored procedures > -triggers > -sub-queries > > Now if it's missing all that then what is it....Access on steroids?? ;-) It is a fast data storage mechanism with a SQL like syntax. As for SQL support and 'doing the right thing' I rate it lower as Access, but it is fast and can handle concurrency better as Access. Very suited for read-only systems where data integrity or relational features are not so important. (For instance, the US Census Bureau uses MySQL to power their webservers. It is very suited for that due to its speed and the price, but the actual data the Census Bureau depends on is stored in Oracle and loaded into the MySQL servers every night. Many other organizations use MySQL like that.) IMHO it is most definitely not suited as a "no brains" upgrade from Access. Due to the lack of features such as referential integrity and views and the way in which some functionality behaves totally different from Access (or any other database or the SQL standard for that matter) you actually need to know quite a bit about it. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
