>-----Original Message----- >From: Martijn Tonies [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 31, 2008 10:37 AM >To: mysql@lists.mysql.com >Subject: Re: Re-arranging fields > >> >> [JS] I added a dozen or so columns for a special purpose, and >although >> >MySQL >> >> doesn't care I wanted them in a certain order that would be >intuitive >> >to a >> >> user / programmer. >> > >> >Why is a user looking at your database? >> > >> >This is a security breach. Users should only have access thru >> >pre-defined SQL statements. >> > >> [JS] Users will have read-only access through MS Access, and have to >filter >> on various fields. >> >> If we weren't trying to make our database designs somewhat intuitive, >we'd >> name all of our fields x1, x2, x3 .... > >There's actually companies that do -almost- just that. > [JS] I've had to work with programs written like that, and cursed the original author most soundly. Personally, I don't mind the extra typing to give things suggestive names. It's been a very long time since I had to worry about the size of a symbol table.
>Either way, the -order- has nothing to do with readable names. If you >filter >on fields, can't you order the list to filter on? Or do you simply fetch >them from >the db and that's that? > [JS] Typically I just have them link to the table and "filter by form". Then they usually copy and paste into an Excel spreadsheet. > >Martijn Tonies >Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, >Oracle & >MS SQL Server >Upscene Productions >http://www.upscene.com >My thoughts: >http://blog.upscene.com/martijn/ >Database development questions? Check the forum! >http://www.databasedevelopmentforum.com > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
