Re: Entering data when the value is the word "Null"
Posted by:
Bob Rowe
Date: July 24, 2014 09:40AM
3209,,KARNSTEDT,EMMA,,73,FEMALE,1953-06-14,1953-06-17,4170,ALDER,24,4,5
3131,,QUICK,EARL N,,98,MALE,1984-02-16,1984-02-20,12115,ALDER,24,5,5
2669,,NULL,ALVIN J.,,68,MALE,1935-10-27,1935-10-29,866,ALDER,25,1,5
2669,,NULL,HANNAH K.,,85,FEMALE,1962-09-03,1962-09-06,6596,ALDER,25,1,6
2971,,PICHA,STEPHEN J.,,69,MALE,1939-06-22,1939-06-24,1355,ALDER,25,2,5
I created this table a couple of days ago and have used the Import tab several times in PHPMyAdmin because I keep finding problems with the data. The import does not produce any errors but I am left with blank fields for their surname. So, I don't have the results of Show Create Table.