dos prompt help

2001-12-06 Thread Ward, Mark
Okay, got through that NULL problem. Thanks. My next question is regarding using the DOS prompt. At work, I'm using Win2000. When I'm using mySQL, if I want to repeat commands, I can just press the up key without retyping the whole thing. But at home I use Win98. I can't do the same thing, even t

NULL Strings

2001-12-06 Thread Ward, Mark
I don't know how this affects anything, but, I'm running the most recent version of mySQL for win98. Why is it that an SQL statement like this (or any variation)... SELECT * FROM classification WHERE level1 = "FOO" AND level2 = "NULL"; will return an empty set. I know that there should be resul

help with load data infile

2001-11-30 Thread Ward, Mark
Hello, I've got a bunch of tables from MS Excel that I've exported to tab delimited files that I'm trying to load into mySQL. I'm having problems getting the data in properly though. For instance, I have set up the ids so that they are incremented automatically. I have the initial records in m