Hi,
I don't have an MySQL install, but am hoping to find someone who could find a little spare time and test/confirm an application I am coding 'Excel to Database'.
You can find the application here:
Excel to Database
I need some help as I am not a MySQL user and am unable to test with MySQL, so I have tried to guess the correct entries for MySQL.
In particular the application has a support file 'SQL-Flavours.XL-DB.xml'.
Within the file are settings for different database types, including MySQL.
This snippet shows the definition for SQL server (with which I am familiar) followed the definition for MySQL:
<SQLFlavour>
<Code>MSSQL</Code>
<Name>Microsoft SQL Server</Name>
<DBMSName>Microsoft SQL Server</DBMSName>
<StoredProcMethod>SCRIPT</StoredProcMethod>
- <ExecProcFormat>
- <![CDATA[ DECLARE @ReturnCode int;[br]EXEC @ReturnCode = {proc_name}[br]|sp_params|@{param_name}={param_value}|end_sp_params|;[br]IF @ReturnCode <> 0 RAISERROR('Procedure failed',16,1)[br]
]]>
</ExecProcFormat>
- <InsertFormat>
- <![CDATA[ INSERT INTO {table_name}[br]([br]{fields_csv}[br])[br] VALUES[br] ({values_csv})
]]>
</InsertFormat>
<FieldNameQualifierStart>[</FieldNameQualifierStart>
<FieldNameQualifierEnd>]</FieldNameQualifierEnd>
<ItemQualifierEnd>]</ItemQualifierEnd>
- <GetProcCode>
- <![CDATA[ sp_helptext {proc_name}
]]>
</GetProcCode>
- <GetTableDefinitionCode>
- <![CDATA[ sp_help {table_name}
]]>
</GetTableDefinitionCode>
<StringDelimeter>'</StringDelimeter>
<Notes />
</SQLFlavour>
- <SQLFlavour>
<Code>MYSQL</Code>
<Name>MySQL</Name>
<DBMSName>MySQL</DBMSName>
<StoredProcMethod>SCRIPT</StoredProcMethod>
- <ExecProcFormat>
- <![CDATA[ CALL {proc_name} (|sp_params|@{param_name} := {param_value}|end_sp_params|)
]]>
</ExecProcFormat>
- <InsertFormat>
- <![CDATA[ INSERT INTO {table_name}[br]([br]{fields_csv}[br])[br] VALUES[br] ({values_csv})
]]>
</InsertFormat>
<FieldNameQualifierStart>`</FieldNameQualifierStart>
<FieldNameQualifierEnd>`</FieldNameQualifierEnd>
- <GetProcCode>
- <![CDATA[ SHOW CREATE PROCEDURE {proc_name}
]]>
</GetProcCode>
- <GetTableDefinitionCode>
- <![CDATA[ describe {table_name}
]]>
</GetTableDefinitionCode>
<StringDelimeter>`</StringDelimeter>
<Notes />
</SQLFlavour>
If anyone with some MySQL experience can help I would be very grateful.
Best regards
Richard
Edited 1 time(s). Last edit at 06/11/2012 07:44AM by richard briggs.