Creating mult. value mysql index with date_format

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Creating mult. value mysql index with date_format

Message

19/08/2008 16:22:29

Bob Bolda
B&B Systems, Llc
Waukesha, Wisconsin, États-Unis

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Creating mult. value mysql index with date_format

Divers

Thread ID:

01340137

Message ID:

01340137

Vues:

121

Does anyone know if it is even possible to create a multiple value, character string index, using the date_format function in MYSQL?

I can't seem to get it work with the latest version of MYSQL.

Example:
CREATE INDEX ACTSTAFFAC ON CONTACTS (ACTSTAFF , date_format(ACTDATE,'%Y%m%d'))

Répondre

Fil

Voir

Click here to load this message in the networking platform