MySQL Bugs: #58417: Error trying to save table

Bug #58417	Error trying to save table - MySQLcc
Submitted:	23 Nov 2010 13:16	Modified:	23 Nov 2010 13:29
Reporter:	ziyaad kajee	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	0.9.4	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
HI

1) when im trying to save my table i created using MySQL control centre 0.9.4, its coming up with the following error: 
[VisualProgrammerServer] ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MYISAM PACK_KEYS=DEFAULT ROW_FORMAT=DEFAULT' at line 1

If i cannot save my tables i cannot procede with my programming. 

2) im trying to connect to delphi. im using the Borland developer studio 2006. i downloaded the update pack2, but its not excepting the VendorLib and the LibraryName. or rather its coming up with errors for them both.the standard vendorlib is dbexpmys.dll, the texkbook says dbexpmysql.dll. both dont work.  

please help. 

How to repeat:
I dont understand this section!!!

I think MySQLcc was abandoned 5 years ago.  Very few people now with MySQL will actually remember it at all, probably.

Peter
(not a MySQL person).

Your problems are not the result of any bugs in supported MySQL software.

For your problem 1, please, try to use ENGINE= instead of TYPE=...

For your problem 2, please, ask Delphi support (at Embarcadero now, http://support.embarcadero.com/delphi probably) what components to use to access MySQL database. We do not support any officially.