//select * from dir_config order by dir_code asc; //insert into dir_config (dir_code,dir_name,dir_parent,dir_depth,dir_sort,dir_date,dir_ip) values (52,'¿î¼¼',6,2,1,'2001-10-10 ¿ÀÈÄ 1:47:18','211.251.251.37'); //commit; //insert into dir_config (dir_code,dir_name,dir_parent,dir_depth,dir_sort,dir_date,dir_ip) values (53,'ÀÎÅ׸®¾î',6,2,1,'2001-10-10 ¿ÀÈÄ 1:47:18','211.251.251.37'); //commit; //insert into dir_config (dir_code,dir_name,dir_parent,dir_depth,dir_sort,dir_date,dir_ip) values (54,'±âŸ',6,2,1,'2001-10-10 ¿ÀÈÄ 1:47:18','211.251.251.37'); //commit; //select * from dir_config; //insert into dir_config (dir_code,dir_name,dir_parent,dir_depth,dir_sort,dir_date,dir_ip) values (6,'»ýÈ°ÆíÀÇ',0,1,1,'2003-12-16 ¿ÀÈÄ 10:00:00','221.161.82.237'); //commit; //delete from dir_config where dir_code = '40'; //commit; //update dir_config set dir_date ='2003-12-16 ¿ÀÀü 10:00:00' , dir_ip = '221.161.82.237'; //commit; //update dir_config set dir_code='8' where dir_code='6' and dir_parent='1'; //commit; select * from dir_list order by dir_code asc; //update dir_list set dir_code='30' where d_code='323'; //commit;