On 11/3/05, Lewis Sellers <[EMAIL PROTECTED]> wrote: > >> A. "SELECT TOP 50" doesn't work in mySQL. "Top" is > >> only SQL > >> Server, correct? > >> B. "From Shows Limit 50" returns an error as well. > >> > > To further elaborate on your question... > > Question: Is it "Shows" or "shows"? Case makes a difference (between > platforms). As a general rule it's best to have all MySQL table names > be lowercase.
Actually, it's best to have the database and table names *consistent* -- the OS simply uses that database or filename to look up the appropriate directory (database) or file (table) for MyISAM databases. On Windows, all of these work: Shows, shows, sHoWS, etc. On Linux, only the one with the right capitalization works. I'd recommend lowercase or camelcase -- whatever you're more consistently using in the codebase. Then formalize the convention and go from there. Fieldnames in MySQL, as an aside, are case insensitive. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54