You can't use UNION until MySQL 4.0, and you lose the "TOP n" clause after SELECT in favor of "LIMIT n" after the ORDER BY clause. You also can't store unicode until 4.1, which may or may not be an issue.
barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Jim Campbell [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 30, 2003 2:54 PM > To: CF-Talk > Subject: Re: Access to MySQL Migration > > > Transactions and foreign keys are available in MySQL by using the InnoDB > engine. Subqueries might be "doable" via a workaround, be it through > more complex joins, CF QoQ's or a mixture of the two (Don't know about > the performance hit, though). Is the "decimal" data type that different > from MySQL's "double"? I also thought NOT NULL was supported. I guess > I'll have to go home and try it now... :) > > - Jim > > Jochem van Dieten wrote: > > >Jim McAtee wrote: > > > > > > > >>We're moving a number of backend databases from Access2000 to MySQL 3.23 > >>(MyISAM) tables. As with Access, we're using ODBC (CF5) to > talk to the MySQL > >>server. Any advice or gotchas we should be aware of? Things > that worked in > >>Access that won't work in MySQL? > >> > >> > > > >transactions > >subqueries > >foreign keys > >decimal datatype > >NOT NULL constraints > > > >Jochem > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4