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

Click here to load this message in the networking platform