Re: Is there a way to load non-native Date type with LOAD DATA

> I have a pretty large file with a Date column in the format M/D/. > > Is there a way to either change the Date data type in the table or a method > to indicate the date format in the LOAD DATA statement in order to handle > this? If you are using MySQL 5.0.3 or greater, you should be able t

Re: Joining result sets into 1 row

> I want to have the rows returned as one row > Such as > ROW 1 Mechanic, Carpenter, Plumber You may want to try GROUP_CONCAT(expr) ... http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscr

Re: stuck on localhost authentication

> insert into user (user,host) values ('jeff','localhost'); > flush privileges; > grant all on databaseName.* to jeff; jeff = [EMAIL PROTECTED] not [EMAIL PROTECTED] So in your statement you should have used... grant all on databaseName.* to [EMAIL PROTECTED]; >select user,host from

Re: Backup questions

> 2) sometimes, I like to copy just a single table or so out of the backup > file, and restore just that. You might want to try out MySQL Administrator which can often be used to restore backups from mysqldump. It can _selectively_ restore tables from a backup file. http://dev.mysql.com/doc/admi