• 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
MySQL Index Generation
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

MySQL Index Generation

  • Subject: MySQL Index Generation
  • From: Jerome Chan <email@hidden>
  • Date: Fri, 16 Jan 2009 08:27:23 +0800
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
  • Follow-Ups:
    • Re: MySQL Index Generation
      • From: Kieran Kelleher <email@hidden>
  • Prev by Date: EOKeyValueQualifier not escaping single quote character
  • Next by Date: Re: longText and postgresql migrations
  • Previous by thread: Re: EOKeyValueQualifier not escaping single quote character
  • Next by thread: Re: MySQL Index Generation
  • Index(es):
    • Date
    • Thread