Insert dynamic record in preorder traversal tree in mysql
===

I have the following entry in my table:

    id  name          unit_id 	lft rgt level
    1 	Sports 	      1 	 	1 	30 	0
    2 	Cricket       00012 	2 	3 	1
    5 	Hocky 	      123 	 	10 	13 	1
    6 	Tennies       1234 	 	11 	12 	2
    9 	Baseball      222 		14 	15 	1
    10 	Soccer 	      2 	  	16 	25 	1
    11 	Carrom 	      3 	  	17 	22 	2

Above records are inserted manually. Now I want to insert record dynamically for maintaining parent-child relationship in table. Can it possible. Thanks in advance.