Re: MySQL Index Generation
Re: MySQL Index Generation
- Subject: Re: MySQL Index Generation
- From: Chuck Hill <email@hidden>
- Date: Thu, 15 Jan 2009 18:19:52 -0800
On Jan 15, 2009, at 6:11 PM, Kieran Kelleher wrote:
Probably the MySQL Migration Helper code is not done yet in Wonder
migrations to support this MySQL indexes.
Or is this from the new index support in WO 5.4. I played with it a
bit before deciding that it was not quite cooked yet. You can file a
bug with Apple.
Chuck
You could just do it using SQL on the command line.
BTW, if using MySQL 5.0.XX, I would recommend latest 5.0.XX connector.
On Jan 15, 2009, at 7:27 PM, Jerome Chan wrote:
Is anyone getting SQL errors trying to generate indexes with MySQL?
How do I correct this?
I get the following code when I choose generate SQL.
CREATE INDEX name_idx FOR Account (name);
CREATE INDEX fromId_idx FOR Follow (fromId);
but according to the MySQL docs its suppose to be
CREATE [ONLINE|OFFLINE] [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name
[index_type]
ON tbl_name (index_col_name,...)
[index_option] ...
How do I correct this? I have added mysql-connector-java-3.1.14-
bin.jar to my lib path.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden