Hi, Newbie to MySQL here. I am trying to export tables from SQL Server to MySQL set up on a virtual server and manage to create the tables when the fields contained within them are purely text, but the table creation fails when fields are type integer or type datetime. The error message is as follows - [TCX][MyODBC]You have an error in your SQL syntax near 'ID char (10) NULL, Job Ref integer NULL, JobTitle char (100) NULL, DateAdd' at line 2 I have just used the default settings for export from SQL Server 2000. All comments would be very gratefully received. Many thanks in advance, Chris Malloch _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
