CREATE INDEX for fixtime & eventtime

savasy2 years ago

I am getting

"ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE INDEX idx_positions_fixtime ON tc_positions (fixtime)' at line 2"

when I try to implement the following recommendation,

It is also strongly recommended to create indexes on tc_positions.fixTime and tc_events.eventTime like this:

CREATE INDEX idx_positions_fixtime ON tc_positions (fixtime);
CREATE INDEX idx_events_eventtime ON tc_events (eventtime);

Any idea?

Best,

Savas

Anton Tananaev2 years ago

What is on line 2? Why do you have two lines?

savasy2 years ago

I don't have 2 lines, just one but error message insists 2 lines

Anton Tananaev2 years ago

If it says you have two lines then it's probably true. You need to carefully check what you're doing. Maybe you have some weird invisible characters or something.