MySQL Forums
Forum List  »  Newbie

Re: Import Excel ods file problem
Posted by: Jane Morrell
Date: March 28, 2022 01:59AM

Thank you Barry and Peter. However it looks like I'm missing something else.

INSERT into race_details(id, name, loft_number, race_code, ring_number, miles, yards, hours, minutes, seconds, clocked, time_field) SELECT (A, B, C, D, E, F, G, H, I, J, K, L) from Sheet1;

MySQL said: Documentation

#1241 - Operand should contain 1 column(s)

Options: ReplyQuote

Written By
Re: Import Excel ods file problem
March 28, 2022 01:59AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.