0

I am trying to save chemical names in mysql databsave and have tried various file formats, such as csv (both with and without "" around all the strings), opendocument format, xls etc but it keeps returning errors such as column count does not match the database.

this is an example of the chemical name. (2S)-7-[[6-O-(6-Deoxy-alpha-L-mannopyranosyl)-beta-D-glucopyranosyl]oxy]-2,3-dihydro-5-hydroxy-2-(3-hydroxy-4-methoxyphenyl)-4H-1-benzopyran-4-one

Also i am using utf8_unicode_ci collation

Daniel E.
  • 2,440
  • 1
  • 14
  • 24
rm65453
  • 81
  • 1
  • 8
  • 2
    There is no reason why an IUPAC chemical name, e.g. `1,4-butanediol` should present any problem for MySQL to store. Please give us a reproducible problem. – Tim Biegeleisen Jan 17 '19 at 14:17
  • 1
    *"column count does not match the database*" Would you show us the `CREATE TABLE` script and your `INSERT` query? – Cid Jan 17 '19 at 14:19
  • Can you provide us what you have tried and the **exact** errors you get ? – Daniel E. Jan 17 '19 at 14:20
  • Sorry guys, the information was very vague and so wasn't expecting to get an answer here. For some reason the excel CSV was the issue. Ran that file with a third party csv to sql software (exportiser pro) and uploaded that and the issues resolved. must have been an issue with a delimiter or something. – rm65453 Jan 24 '19 at 16:41

1 Answers1

0

Ran the CSV through a third party csv to sql generator and resolved the issue.

rm65453
  • 81
  • 1
  • 8