Hi !!!
)-Original Message-
)From: Armando Cerna [mailto:[EMAIL PROTECTED]]
)Sent: Tuesday, August 28, 2001 1:27 PM
)To: [EMAIL PROTECTED]
)Subject: dbf2mysql problem please help
)
)
)I have problems only converting certain DBF files to mysql with
)dbf2mysql.
)Some work but some don't and when they dont' I get the following error
)
)bash-2.05$ dbf2mysql -d maria -t cusine -c -P pass -U user CUSINE.DBF
)Error creating table!
)Detailed report: You have an error in your SQL syntax near 'DESC
)varchar(20)
)not null)
You can't use the SQL/MySQL standard keywords as the table/column names.
Here DESC is a standard keyword. So, change DESC to DESC1 and it will
absolutely work fine.
Regards
Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu <mailto:[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ Woodside, California USA
<___/ www.mysql.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