• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: MySQL Index Generation
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: MySQL Index Generation


  • Subject: Re: MySQL Index Generation
  • From: Kieran Kelleher <email@hidden>
  • Date: Thu, 15 Jan 2009 21:11:12 -0500

Probably the MySQL Migration Helper code is not done yet in Wonder migrations to support this MySQL indexes. 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,...)
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

  • Follow-Ups:
    • Re: MySQL Index Generation
      • From: Jerome Chan <email@hidden>
    • Re: MySQL Index Generation
      • From: Chuck Hill <email@hidden>
References: 
 >MySQL Index Generation (From: Jerome Chan <email@hidden>)

  • Prev by Date: Re: [OT - kinda] WOWODC 2009 webcasting?
  • Next by Date: Re: MySQL Index Generation
  • Previous by thread: MySQL Index Generation
  • Next by thread: Re: MySQL Index Generation
  • Index(es):
    • Date
    • Thread