Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
8 subscribers
Views
1334 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
We have a cloud hosted instance of Appian using MySQL. I've tried to create
steveb
over 8 years ago
We have a cloud hosted instance of Appian using MySQL. I've tried to create an index on a table with one of the keys being descending rather than the default of ascending, but it is not working.
The SQL I'm using is
ALTER TABLE `Demand_Notes`
ADD UNIQUE KEY `IX1_Demand_Notes` (`demandId`,`createdDateTime` desc,`noteId`);
Can someone explain what I'm doing wrong.
OriginalPostID-179777
OriginalPostID-179777
Discussion posts and replies are publicly visible
Parents
0
mayankk718
over 8 years ago
Descending index is not supported in MySQL (till 5.7). Keywords may be given, but they are anyways ignored and only ascending index is supported, which is default.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mayankk718
over 8 years ago
Descending index is not supported in MySQL (till 5.7). Keywords may be given, but they are anyways ignored and only ascending index is supported, which is default.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data