This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Insert data with pymysql into a database mysql error. How to solve?

seqteste.txt or List sequece:

I'm trying to insert data from a seqteste.txt and seqteste.fasta file into a mysql database but the result is always null. How to solve this problem? What am I doing wrong?

python database biopython mysql genome
• 1,608 views • link
written by USER • USER

this is another question to complement the other..It's not the same question ...

• 0 views • link
written by USER • USER

what is the similar question?

• 0 views • link
written by USER • USER

Error of the other;

pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your version of the MySQL server for the correct syntax to use next to '% s,% s,% s,% s) 'on line 1 ")

erro here:

TypeError: not all arguments converted during string formatting
or 
TypeError: expected str, bytes or os.PathLike object, not NoneType

I would like to insert the data but when inserting the data they are null or are not inserted due to these errors.

• 0 views • link
written by USER • USER

It's not the same problem ... One was about the connection and this one about inserting the data ... which are being inserted as null ... Maybe I needed to modify the titles to be clearer ... Despite the codes complement each other are different problems...

• 0 views • link
written by USER • USER

0 answers

No answers yet.

Log in to answer this question.

More posts like this