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) or 1)? Don't use a zero in the AUTO_INCREMENT column if you want to explicitly specify the values in that column. >I'm a little confused about the format of the data in the text file. From >what I've read, In general you can use both, but for your first database I'd recommend you to use your second form (explicitly specify the values). >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 file. From >what I've read, >it's simply listing the values in a row separated by a tab. But what if the >first >field/column is an ID number to be generated by MySQL? > >Table groups > >Two Fields: groups_id auto-increment Primary > groups_name varchar(15) > >Would the text file look like: > >NULL students >NULL faculty >NULL staff > > where I would acutally type NULL > >or > >0 students >1 faculty >2 staff > > where I would supply the number (would it start with 0 (zero) or 1)? > >or > >what else is there? "Jeff Broomall" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
