Re: Using Table prefixes

On Jun 8, 2013, at 3:00 PM, Ashley Sheridan <ash@ashleysheridan.co.uk> wrote: dealTek <dealtek@gmail.com> wrote: > >> I can see the basic need for a table prefix in a case where you may use >> one mysql database for several projects at once so as to distinguish >> tables per project like... >> >> -snip- >> however I was told a long time ago to use a prefix "tbl_" like >> tbl_Mytable but I don't really see much need for this by itself ... Am >> I missing something? > > I think that's a pattern that people use to distinguish their tables from views, etc, but > personally I find it a little pointless. It doesn't really help in any way, and just means more > typing. > > Using a prefix for a set of tables in one db where you might have several things using the db > (i.e. some hosting limits the databases you can have) makes sense, and especially so if you name it > sensibly as in your first example. > Thanks, > Ash I agree, but more than that I also set up databases specifically for clients such that all the tables in them are related to the client and not each other, such as: client1_db contacts invoices etc and client2_db contacts invoices etc As such, the "tbl_" prefix is not needed. Cheers, tedd _____________________ tedd.sperling@gmail.com http://sperling.com