MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Import Excel ods file problem
Jane Morrell
March 27, 2022 02:00AM
Re: Import Excel ods file problem
Peter Brawley
March 27, 2022 09:26AM
Re: Import Excel ods file problem
Jane Morrell
March 27, 2022 10:01AM
Re: Import Excel ods file problem
Peter Brawley
March 27, 2022 01:00PM
Re: Import Excel ods file problem
Barry Galbraith
March 27, 2022 05:38PM
Re: Import Excel ods file problem
Jane Morrell
March 27, 2022 07:27PM
Re: Import Excel ods file problem
Barry Galbraith
March 27, 2022 09:34PM
Re: Import Excel ods file problem
Peter Brawley
March 28, 2022 09:10AM
Re: Import Excel ods file problem
Peter Brawley
March 27, 2022 07:44PM
Re: Import Excel ods file problem
Jane Morrell
March 28, 2022 01:59AM
Re: Import Excel ods file problem
Barry Galbraith
March 28, 2022 06:29AM
Re: Import Excel ods file problem
Jane Morrell
March 28, 2022 07:43AM


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.