Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating mult. value mysql index with date_format
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01340137
Message ID:
01340552
Vues:
6
Hi Bob,

>PS. Unfortunately, I have some tags that have a character field + a DTOS(mdate) function

You don't need to upgrade index tags to MySql for the purpose of sorting data. That's something you do with the ORDER BY clause of your SQL query or by indexing the result set in VFP. SQL servers need indexes to ensure unqiue constraints and for optimizing queries.
--
Christof
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform