The Artima Developer Community
Sponsored Link

Legacy Java Answers Forum
January 2002



This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.


ms access

Posted by Chin Loong on January 22, 2002 at 10:20 AM

hmm, i'll try to see whether i still have my references.

well, it(access, the devil)'s much easier during development, as u don't need to type create statements and all. and u can easily delete columns and stuff.

but, it has different syntaxes from mySQL, such as inner joins and stuff. i.e. access, the devil can use the syntax ON with inner join, but mySQL can't use ON with inner joins. i *had* to change all my inner joins to outer joins when at one time i migrated from access to mySQL (again, on client's request).

access the devil can use SELECT TOP 3 FROM .... ASC but mySQL can't use that. mySQL has a different syntax from that.. i forgot what.. hmm.. i think i did a ascending search and only read 3 rows. :p



Sponsored Links

Copyright © 1996-2009 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use - Advertise with Us