Styjun

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

python mysql mysql-connector-python

share|improve this question

edited Mar 28 at 8:13

taras

3,81666 gold badges2626 silver badges3535 bronze badges

asked Mar 28 at 8:11

YashYash

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
  

  
  
  
  

add a comment | 

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

python mysql mysql-connector-python

share|improve this question

edited Mar 28 at 8:13

taras

3,81666 gold badges2626 silver badges3535 bronze badges

asked Mar 28 at 8:11

YashYash

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
  

  
  
  
  

add a comment | 

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

edited Mar 28 at 8:13

taras

3,81666 gold badges2626 silver badges3535 bronze badges

asked Mar 28 at 8:11

YashYash

1

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')

============== 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
>>> 

share|improve this question

edited Mar 28 at 8:13

taras

3,81666 gold badges2626 silver badges3535 bronze badges

asked Mar 28 at 8:11

YashYash

1

share|improve this question

edited Mar 28 at 8:13

taras

3,81666 gold badges2626 silver badges3535 bronze badges

asked Mar 28 at 8:11

YashYash

1

edited Mar 28 at 8:13

taras

3,81666 gold badges2626 silver badges3535 bronze badges

edited Mar 28 at 8:13

taras

3,81666 gold badges2626 silver badges3535 bronze badges

asked Mar 28 at 8:11

YashYash

1

asked Mar 28 at 8:11

YashYash

1