column name

Hi all, I guess it's a dumb question for you guys, but MySql manual doesn't seem to offer newbies a great deal of help on this one: how do I change a column name? Gian - Before posting, please check: http://www.mysql.com/man

Missing values

Hi, I've been trying to import a huge .txt file into a MySql table. In the .txt file, missing values are recorded as empty cells (it might be that there's some hidden character instead, but I wouldn't know how to figure that out). When I LOAD DATA INFILE, MySql writes the missing values as zero