search

tajubenv / fda_faers_dl_extract

Downloads and extracts FDA FAERS data and generates a sql script to read the data into a MYSQL database through MYSQL shell.
5 stars 3 forks source link

error 1064 sql syntax #1

Open Lamahb opened 2 years ago

Lamahb commented 2 years ago

Hey , thank you for easing the process but i am trying to create a table for FAERS data and something went wrong because i extracted the faers files with your python script and run the queries in mysql shell and this error happened . Would you mind helping me ?

error
elvey commented 1 year ago

Typo? util.importTable("EC:/ doesn't make sense to me. (Is that valid syntax on an OS I'm not familiar with?)
Perhaps delete a letter, making util.importTable("C:/ or util.importTable("E:/