Re: Populating table with test file

2005-08-07 Thread Gleb Paharenko
Hello. I'm not sure about 'myPHPadmin', but if it uses LOAD DATA INFILE you should use \N in the data file, if you want to insert a NULL value in the column. See: http://dev.mysql.com/doc/mysql/en/problems-with-null.html where I would supply the number (would it start with 0 (zero)

Populating table with test file

2005-08-06 Thread Jeff Broomall
Hello. I'm creating my first database and would prefer populating the tables using a text file I'll create in Notepad (not that it makes and difference). In case it matters, I'm using myPHPadmin provided by my web hosting service. I'm a little confused about the format of the data in the text