Hello mysql, I have some table: /* BEGIN DUMP *************************************************/ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) );
INSERT INTO `sp_tovar_vid` VALUES (0, 0, 'root', 'root category'); INSERT INTO `sp_tovar_vid` VALUES (7, 0, 'cat.1', ''); INSERT INTO `sp_tovar_vid` VALUES (8, 0, 'cat.2', ''); INSERT INTO `sp_tovar_vid` VALUES (9, 0, 'cat.3', ''); INSERT INTO `sp_tovar_vid` VALUES (10, 0, 'cat.4', ''); INSERT INTO `sp_tovar_vid` VALUES (11, 0, 'cat.5', ''); INSERT INTO `sp_tovar_vid` VALUES (12, 7, 'subcat 1', '(to cat.1)'); INSERT INTO `sp_tovar_vid` VALUES (13, 7, 'subcat 2', '(to cat.1)'); INSERT INTO `sp_tovar_vid` VALUES (14, 7, 'subcat 3', '(to cat.1)'); INSERT INTO `sp_tovar_vid` VALUES (15, 9, 'subcat 1', '(to cat.3)'); INSERT INTO `sp_tovar_vid` VALUES (16, 9, 'subcat 2', '(to cat.3)'); INSERT INTO `sp_tovar_vid` VALUES (17, 9, 'subcat 3', '(to cat.3)'); INSERT INTO `sp_tovar_vid` VALUES (18, 13, 'subsubcat 1', '(to subcat.2 to cat.1)'); /* END DUMP ****************************************************/ _QUESTION 1_: in what way should i run query to restore table with `id`' like in dump? (`id` is auto_increment) _QUESTION 2_: how to display table with columns= ('parent_category.name' ,'category.name')? i tried this: /***/ SELECT t1.`name`,t2.`name` FROM `sp_tovar_vid` AS t1, `sp_tovar_vid` AS t2 WHERE t1.`id`=t2.`id_tovar_vid` ORDER BY t1.`name`,t2.`name`; /***/ How to make it more simply? _QUESTION 3_: how to display string: "subsubcat 1 - subcat.2 - cat.1" if we have only `id`=18 ? -- Best regards, Alex mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]