MySQL Forums
Forum List  »  Newbie

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Entering data when the value is the word "Null"
July 24, 2014 09:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.