multiple level database hierarchy

2010-05-13 Thread Peng Yu
I seems that mysql and may SQL has only two levels databases->tables. Where there many tables, it become hard to properly name the tables and databases. I'm wondering if there is any variant of SQL or some other database that support arbitrary levels of complexity. -- Regards, Peng -- MySQL Gen

RE: Count Query question

2010-05-13 Thread webmaster
E KEY `products_model` (`products_model`), > >>>> KEY `idx_products_date_added` (`products_date_added`), > >>>> KEY `manufacturers_id` (`manufacturers_id`) > >>>> ) ENGINE=MyISAM AUTO_INCREMENT=17418 DEFAULT CHARSET=latin1 > >>>&g

Re: Count Query question

2010-05-13 Thread Keith Clark
Bob, Here are a few rows of my data: 17462, 0, '0929998596', '/GraphicNovels/0929998596.jpg', '8.5000', '2010-05-12 19:02:47', '2008-10-01 00:00:00', '2008-10-01 00:00:00', '0.50', 1, 1, 7429, 0, '1', 17461, 1, '1561481912', '/Cooking/1561481912.jpg', '3.', '2010-05-12 19:00:17', '2008-10-0