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
What is on line 2? Why do you have two lines?
I don't have 2 lines, just one but error message insists 2 lines
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.
I am getting
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:
Any idea?
Best,
Savas