Why I can only choose the whole column content, but can't select specified name column content

CodePudding user response:

Don't understand your problem,

CodePudding user response:

Is the whole table, there are a lot of countries in the name of a column name, I want to choose a name for China in the specified column data, but access is specified listed all of the data, and all the name column into China, the name of the other countries are covered off, how to solve?

CodePudding user response:

Did not fully understand what you mean,
But you can try:

(1)

 SELECT total_confirm 

To:

 SELECT * 

See how the results

(2)

 
Adr=(" China ") 

To:

 
Adr="Chinese" 

Try

(3) find the mysql tools alone, to run your SQL command to see if the output in line with your expectations
Wait conform to, to go into a python code,

Another:
Your question is actually mysql database and issue, rather than a python,
And we are here for your database, also can't help you test result,
Can only be tested on your own,

CodePudding user response:

Direct written name='China' behind excute don't adr or name=? Adrs=try (" 'China', ")