CREATE INDEX for fixtime & eventtime

savasy 3 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 Tananaev 3 years ago

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

savasy 3 years ago

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

Anton Tananaev 3 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.