Insert data with pymysql into a database mysql error. How to solve?

Question

[USER]

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?

[Pierre Lindenbaum]

Hello projetoic!

Questions similar to yours can already be found at:

• How to insert sequence fasta data into a mysql database?

We have closed your question to allow us to keep similar content in the same thread.

If you disagree with this please tell us why in a reply below. We'll be happy to talk about it.

Cheers!

[USER]

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

[USER]

what is the similar question?

[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.

[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...