Using Python variable for mysql tables using mysql.connectorCalling an external command in PythonWhat are metaclasses in Python?Finding the index of an item given a list containing it in PythonWhat is the difference between Python's list methods append and extend?How can I safely create a nested directory?How do I connect to a MySQL Database in Python?Does Python have a ternary conditional operator?Should I use the datetime or timestamp data type in MySQL?Using global variables in a functionDoes Python have a string 'contains' substring method?

Why does F + F' = 1?

Georgian capital letter “Ⴒ” (“tar”) in pdfLaTeX

Which ping implementation is cygwin using?

Are Democrats more likely to believe Astrology is a science?

Is English tonal for some words, like "permit"?

Is there a basic list of ways in which a low-level Rogue can get advantage for sneak attack?

2.5 year old daughter refuses to take medicine

Are there any space probes or landers which regained communication after being lost?

Can I say "I will encrypt something" if I hash something?

Calculate time difference between two dates

What does the question of my colleagues really mean?

Is there a sentence that begins with “them”?

Is the space of Radon measures a Polish space or at least separable?

Wrathful Smite, and the term 'Creature'

Do any aircraft carry boats?

SCOTUS - Can Congress overrule Marbury v. Madison by statute?

I changed a word from a source, how do I cite it correctly?

How can I fix a framing mistake so I can drywall?

SQL Server table with 4,000,000 rows is 40GB

Was Robin Hood's point of view ethically sound?

Have there been any countries that voted themselves out of existence?

Matrices upper triangular alignment

Are there take-over requests from autopilots?

What are the advantages and disadvantages of Preprints.org compared with arXiv?



Using Python variable for mysql tables using mysql.connector


Calling an external command in PythonWhat are metaclasses in Python?Finding the index of an item given a list containing it in PythonWhat is the difference between Python's list methods append and extend?How can I safely create a nested directory?How do I connect to a MySQL Database in Python?Does Python have a ternary conditional operator?Should I use the datetime or timestamp data type in MySQL?Using global variables in a functionDoes Python have a string 'contains' substring method?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















I want to ask a value in python and use that variable to check a table in MySQL. if MySQL table value is same as entered name(by user) then if should show correct answer. Pls Help



import mysql.connector
mydb = mysql.connector.connect(host = "localhost",user = "root",passwd = "password")
m = mydb.cursor()
m.execute("use project")
m.execute("Select Question_Name from questions where Question_No = 1")
for x in m:
print(x)
m.execute("Select Option_A,Option_B from questions where Question_No = 1")
for x in m:
print(x)
m.execute("Select Option_C,Option_D from questions where Question_No = 1")
for x in m:
print(x)

t = input("Enter your Answer: ")
ans = (t,)
m.execute("Select Correct_Option from questions where Question_No = 1")
if ans==m:
print("Your answer is correct")
else:
print("Wrong")


m.execute("Select * from questions where Question_No = 1")
for x in m:
print(x)

#OUTPUT

(1, 'The weight of diamonds is usually measured in what?', 'A. Tola', 'B. Carat', 'C. Maund', 'D. Troy', 'Carat')


LAST COLUMN SHOULD BE COMPARED(CORRECT ANSWER)



OUTPUT SCREEN:



============== RESTART: E:Yash Class XIIProjectprojectdb.py ==============
('The weight of diamonds is usually measured in what?',)
('A. Tola', 'B. Carat')
('C. Maund', 'D. Troy')
Enter your Answer with option: Carat
Wrong
>>>


IT SHOULD DISPLAY ANSWER IS CORRECT










share|improve this question


























  • ans is a tuple (('Carat',)), m is very likely a list containing a tuple ([('Carat',)]). ans==m is False.

    – shmee
    Mar 28 at 8:41

















0















I want to ask a value in python and use that variable to check a table in MySQL. if MySQL table value is same as entered name(by user) then if should show correct answer. Pls Help



import mysql.connector
mydb = mysql.connector.connect(host = "localhost",user = "root",passwd = "password")
m = mydb.cursor()
m.execute("use project")
m.execute("Select Question_Name from questions where Question_No = 1")
for x in m:
print(x)
m.execute("Select Option_A,Option_B from questions where Question_No = 1")
for x in m:
print(x)
m.execute("Select Option_C,Option_D from questions where Question_No = 1")
for x in m:
print(x)

t = input("Enter your Answer: ")
ans = (t,)
m.execute("Select Correct_Option from questions where Question_No = 1")
if ans==m:
print("Your answer is correct")
else:
print("Wrong")


m.execute("Select * from questions where Question_No = 1")
for x in m:
print(x)

#OUTPUT

(1, 'The weight of diamonds is usually measured in what?', 'A. Tola', 'B. Carat', 'C. Maund', 'D. Troy', 'Carat')


LAST COLUMN SHOULD BE COMPARED(CORRECT ANSWER)



OUTPUT SCREEN:



============== RESTART: E:Yash Class XIIProjectprojectdb.py ==============
('The weight of diamonds is usually measured in what?',)
('A. Tola', 'B. Carat')
('C. Maund', 'D. Troy')
Enter your Answer with option: Carat
Wrong
>>>


IT SHOULD DISPLAY ANSWER IS CORRECT










share|improve this question


























  • ans is a tuple (('Carat',)), m is very likely a list containing a tuple ([('Carat',)]). ans==m is False.

    – shmee
    Mar 28 at 8:41













0












0








0








I want to ask a value in python and use that variable to check a table in MySQL. if MySQL table value is same as entered name(by user) then if should show correct answer. Pls Help



import mysql.connector
mydb = mysql.connector.connect(host = "localhost",user = "root",passwd = "password")
m = mydb.cursor()
m.execute("use project")
m.execute("Select Question_Name from questions where Question_No = 1")
for x in m:
print(x)
m.execute("Select Option_A,Option_B from questions where Question_No = 1")
for x in m:
print(x)
m.execute("Select Option_C,Option_D from questions where Question_No = 1")
for x in m:
print(x)

t = input("Enter your Answer: ")
ans = (t,)
m.execute("Select Correct_Option from questions where Question_No = 1")
if ans==m:
print("Your answer is correct")
else:
print("Wrong")


m.execute("Select * from questions where Question_No = 1")
for x in m:
print(x)

#OUTPUT

(1, 'The weight of diamonds is usually measured in what?', 'A. Tola', 'B. Carat', 'C. Maund', 'D. Troy', 'Carat')


LAST COLUMN SHOULD BE COMPARED(CORRECT ANSWER)



OUTPUT SCREEN:



============== RESTART: E:Yash Class XIIProjectprojectdb.py ==============
('The weight of diamonds is usually measured in what?',)
('A. Tola', 'B. Carat')
('C. Maund', 'D. Troy')
Enter your Answer with option: Carat
Wrong
>>>


IT SHOULD DISPLAY ANSWER IS CORRECT










share|improve this question
















I want to ask a value in python and use that variable to check a table in MySQL. if MySQL table value is same as entered name(by user) then if should show correct answer. Pls Help



import mysql.connector
mydb = mysql.connector.connect(host = "localhost",user = "root",passwd = "password")
m = mydb.cursor()
m.execute("use project")
m.execute("Select Question_Name from questions where Question_No = 1")
for x in m:
print(x)
m.execute("Select Option_A,Option_B from questions where Question_No = 1")
for x in m:
print(x)
m.execute("Select Option_C,Option_D from questions where Question_No = 1")
for x in m:
print(x)

t = input("Enter your Answer: ")
ans = (t,)
m.execute("Select Correct_Option from questions where Question_No = 1")
if ans==m:
print("Your answer is correct")
else:
print("Wrong")


m.execute("Select * from questions where Question_No = 1")
for x in m:
print(x)

#OUTPUT

(1, 'The weight of diamonds is usually measured in what?', 'A. Tola', 'B. Carat', 'C. Maund', 'D. Troy', 'Carat')


LAST COLUMN SHOULD BE COMPARED(CORRECT ANSWER)



OUTPUT SCREEN:



============== RESTART: E:Yash Class XIIProjectprojectdb.py ==============
('The weight of diamonds is usually measured in what?',)
('A. Tola', 'B. Carat')
('C. Maund', 'D. Troy')
Enter your Answer with option: Carat
Wrong
>>>


IT SHOULD DISPLAY ANSWER IS CORRECT







python mysql mysql-connector-python






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Mar 28 at 8:13









taras

3,8166 gold badges26 silver badges35 bronze badges




3,8166 gold badges26 silver badges35 bronze badges










asked Mar 28 at 8:11









YashYash

1




1















  • ans is a tuple (('Carat',)), m is very likely a list containing a tuple ([('Carat',)]). ans==m is False.

    – shmee
    Mar 28 at 8:41

















  • ans is a tuple (('Carat',)), m is very likely a list containing a tuple ([('Carat',)]). ans==m is False.

    – shmee
    Mar 28 at 8:41
















ans is a tuple (('Carat',)), m is very likely a list containing a tuple ([('Carat',)]). ans==m is False.

– shmee
Mar 28 at 8:41





ans is a tuple (('Carat',)), m is very likely a list containing a tuple ([('Carat',)]). ans==m is False.

– shmee
Mar 28 at 8:41












0






active

oldest

votes










Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);














draft saved

draft discarded
















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55392825%2fusing-python-variable-for-mysql-tables-using-mysql-connector%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes




Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.







Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.




















draft saved

draft discarded















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55392825%2fusing-python-variable-for-mysql-tables-using-mysql-connector%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

How to preserve electronics (computers, tablets and phones) for hundreds of years Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) The network's official Twitter account is up and running again. What content…How might modern humans leave a message for 50,000 years?How would an aquatic race develop computers?How do we make computers care for human life?Keeping supplies for 1000 yearsWhat will cell phones become in 100 years?What body armor protects against a laser?Could a society attain 1800s technology if limited to using copper and bronze?Electricity power (magic) and electronicsScavenging metal resources in post-apocalypse after 100 yearsWhy would precursors create devices that can survive and still work after hundreds of years?

해남서초등학교 학교 연혁 학교 동문 외부 링크 둘러보기 메뉴북위 34° 34′ 21″ 동경 126° 35′ 50″ / 북위 34.5726385° 동경 126.5972670°  / 34.5726385; 126.5972670해남서초등학교eh

155 수학 과학 기타 둘러보기 메뉴eh추가해eh문서를 완성해