communication error

it is corrected? mysql: Ver 14.12 Distrib 5.0.22, for sun-solaris2.8 (sparc) using EditLine wrapper Thanks for any insights. Chris Jones 14 Oneida Avenue Toronto, ON M5J 2E3. Tel. 416-203-7465 Fax. 416-946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

INSERT into select ... ON DUPLICATE KEY??

-0002 ON DUPLICATE KEY UPDATE FAC_ID=FAC-0003 Now in my untrained mind, this should create 4 new, identical records with only the fac_id field changed. Where am I going wrong? Thanks. Chris Jones 14 Oneida Avenue Toronto, ON M5J 2E3. Tel. 416-203-7465 Fax. 416-946-1005 -- MySQL General

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

] Chris Jones 14 Oneida Avenue Toronto, ON M5J 2E3. Tel. 416-203-7465 Fax. 416-946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Table permissions - before the table is created?

privileges. Chris Jones, P.Eng. 14 Oneida Avenue Toronto, ON M5J2E3 Tel. 416 203-7465 Fax. 416 946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table permissions - before the table is created?

Thanks for that. Will create the two tables ahead of time which won't affect the existing application. At 11:57 30/08/2006, [EMAIL PROTECTED] wrote: Chris Jones wrote: Can the mysql administrator grant permissions on a table in an existing database if that table doesn't exist yet

Re: Newbie - Where do I look for answers?

[EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Chris Jones, P. Eng. 14 Oneida Avenue Toronto, ON M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249