Home>Foods>Potatoes, mashed, dehydrated, prepared from granules with milk, water and margarine added
Prev     Next    

Long_Desc	Potatoes, mashed, dehydrated, prepared from granules with milk, water and margarine added
Food Groups	Vegetables and Vegetable Products
Foods	11383
Refuse	0
N_Factor	0
Pro_Factor	0
Fat_Factor	0

Problem with sql > select 'NDB_No', s.table_name from information_schema.TABLES t, information_schema.COLUMNS s where t.table_schema = schema() and t.table_type = 'BASE TABLE' and s.table_name = t.table_name and t.table_name != 'food_des' and s.column_name = 'NDB_No' and s.table_schema = schema() and t.table_name in ('food_des','food_group','food_nut_data','food_nutr_def') union select 'NDB_No',

Lists: Nutrients Foods Food Groups Nutrient

View full screen