I prefer Users, Groups, Orders as my db tables .... avoids the reserved words problem .... I have an Order class and object though but my db tables are plural.
I'm with Stephen on this. Reserved words as table and column names annoy me too Alan ________________________________ From: Chris Blackwell <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, November 19, 2008 11:09:20 PM Subject: [transfer-dev] Re: Escaping reserved column names Hi Stephen, Fortunately this db schema is not of my design and unfortunately i'm not able to change it. Most applications have a User table, if those users are organized then there may be a Group table, and if theres any kind of ecommerce or whatever going on then it might have a Order table. How would you name these so as not to use reserved words? > Not sure why you would want to allow or continue to use badly formed sql. I don't consider SELECT `UserId` FROM `User` to be badly formed sql. when i'm writing sql i would enclose every table and column in back ticks whether thay are reserved words or not - because then they change color in my sql ide and that makes it look nice! :D I've used all those words above as table names in the past (now you hate me don't you ;-)) because they are accurate description of what they are. Just because the dbms says its a reserved word doesn't mean you should not use it - the dbms provides you with a way of escaping them for precisely this reason. If you use MySQL server you will know that the mysql db actually has a table called "user" I'm not spoiling for a fight, just curious for your opinion on this Cheers, Chris 2008/11/19 Stephen Moretti <[EMAIL PROTECTED]> 2008/11/19 Mark Mandel <[EMAIL PROTECTED]> Ah yeah.. that's not going to work. It is a limitation of Transfer. Probably quite a good limitation. Not sure why you would want to allow or continue to use badly formed sql. To be honest, if you're building something new and have the access to change the database schema, I would get it changed. Sorry grumpy pet-peeve of mine is using reserved words in database columns or in general. Makes my blood boil..... Stephen --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
