Skip navigation.

my php-driven thoughts

about web and something more

Posts tagged with "database"

database wisdom

,

Real indexing masterpiece appears only when one is creating select query from 9 tables based on 20 criterias.

DB problems

, , , ...

Just remembered one thing: if you have home-made-hosting "company" and you provide MySQL databases as data storage server - don't use underscores (_) in databases' names. When you grant someone all priviledges on one db named user_db, then user can create even more databases, like:
  • user0db;
  • user1db;
  • and so on...
I had that problem in my ex-work (Vilnius University IT Center). Thank God, i wasn't responsible for database administration (yet) .)

It's much better to gain such experience at 127.0.0.1 if u know what i mean .)
December 2009
S M T W T F S
November 2009January 2010
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31