Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating mult. value mysql index with date_format
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01340137
Message ID:
01340552
Views:
5
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
Previous
Reply
Map
View

Click here to load this message in the networking platform