code resolve my problem regarding insertion except it split Luman i.e. 0.372 value from string and saved in mcompraser column i.e. 1 in given string,and shows null in mluman colum in table :
OUTPUT:
Idmnorth meast mtimemheight mtemperaturemvoltagemcompraser mluman
6 2449.555 06704.67880701071 44.678 11.7640.372 NULL
7 2449.555 06704.67880701071 44.678 11.7640.372 NULL
Message :
(8 row(s) affected)
Warning: Null value is eliminated by an aggregate or other SET operation.
(1 row(s) affected)