General discussion
Import data from csv to mysql

5a900ec14193e
this my table> can anyone help me how to data like this to my table

411,1,1,200 m WANITA - AKHIR,+0.6,M/S,,,,,"20:01,18.0794"
1,458,5,,NUR AISHAH ROFINA BINTI ALING,SANDAKAN,26.15,,26.144,,,"20:01,18.08",,,,26.144,26.144
2,401,8,,RUJIAH JAHAMIN,RANAU,27.13,,same time,,,"20:01,18.08",,,,0.978,0.978
3,009,7,,CAMELLIA JASTEN,BEAUFORT,27.65,,same time,,,"20:01,18.08",,,,0.520,0.520
4,464,3,,SHARIFAH AUSYAH BINTI MOHAMMAD,SANDAKAN,27.68,,same time,,,"20:01,18.08",,,,0.033,0.033
5,532,2,,MIANA MASINTA MOSUSAH,TAWAU,27.79,,same time,,,"20:01,18.08",,,,0.106,0.106
6,531,4,,JAMILAH SAPARUDDIN,TAWAU,27.88,,same time,,,"20:01,18.08",,,,0.099,0.099
7,626,6,,PETRONELLA LISONG,TUARAN,27.91,,same time,,,"20:01,18.08",,,,0.028,0.028
8,161,1,,LYVONIE HEAVENDRA DONNY,KOTA MARUDU,28.90,,same time,,,"20:01,18.08",,,,0.984,0.984

![5a900ec14193e](serve/attachment&path=5a900ec14193e) this my table> can anyone help me how to data like this to my table > 411,1,1,200 m WANITA - AKHIR,+0.6,M/S,,,,,"20:01,18.0794" 1,458,5,,NUR AISHAH ROFINA BINTI ALING,SANDAKAN,26.15,,26.144,,,"20:01,18.08",,,,26.144,26.144 2,401,8,,RUJIAH JAHAMIN,RANAU,27.13,,same time,,,"20:01,18.08",,,,0.978,0.978 3,009,7,,CAMELLIA JASTEN,BEAUFORT,27.65,,same time,,,"20:01,18.08",,,,0.520,0.520 4,464,3,,SHARIFAH AUSYAH BINTI MOHAMMAD,SANDAKAN,27.68,,same time,,,"20:01,18.08",,,,0.033,0.033 5,532,2,,MIANA MASINTA MOSUSAH,TAWAU,27.79,,same time,,,"20:01,18.08",,,,0.106,0.106 6,531,4,,JAMILAH SAPARUDDIN,TAWAU,27.88,,same time,,,"20:01,18.08",,,,0.099,0.099 7,626,6,,PETRONELLA LISONG,TUARAN,27.91,,same time,,,"20:01,18.08",,,,0.028,0.028 8,161,1,,LYVONIE HEAVENDRA DONNY,KOTA MARUDU,28.90,,same time,,,"20:01,18.08",,,,0.984,0.984

Want to know the process of import data from CSV to MYSQL, consult with an expert database tutor. In the technology era, find many websites of online teaching, but I suggest you to 'Select My Tutor' for solving database problems.

Want to know the process of import data from CSV to MYSQL, consult with an expert database tutor. In the technology era, find many websites of online teaching, but I suggest you to 'Select My Tutor' for solving database problems.

http://www.selectmytutor.co.uk/subject-php.html

edited Mar 9 '18 at 1:05 pm

@Ayie You just need to format the data through settings you can mange to sort the jumbled data and than the import would be quite smooth

@Ayie You just need to format the data through settings you can mange to sort the jumbled data and than the import would be quite smooth
343
2
3
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft