mysql 选择同一行中的数据

bfnvny8b 于 2023-04-05 发布在 Mysql

关注(0)|答案(1)|浏览(110)

my tabel
我需要知道如何编写这样的代码：
如果account_id 2的quiz_num_1数据不是quiz_null，则进行打印，如果account_id 2的quiz_num_1数据是quiz_null，则进行不同的打印，account_id可由变量名控制：user_account_id = 1或2
有人能帮我吗？
我试着这么做，但没有成功

mycursor.execute(f"SELECT account_id FROM quizzes_lib WHERE account_id = '{user_account_id}'AND SELECT quiz_num_1 FROM quizzes_lib WHERE quiz_num_1 = 'quiz_null'")
 #mycursor.execute("SELECT quiz_num_1 FROM quizzes_lib Where quiz_num_1 = 'quiz_null'")
 if mycursor.fetchall():
   print("there is no quizzes in your library")
 else:
   print("there is __ in your library")

mysql

来源：https://stackoverflow.com/questions/75887050/selecting-data-which-are-in-the-same-row

1条答案

按热度按时间

vlju58qv1#

mycursor.execute(f"SELECT account_id, quiz_num_1 FROM quizzes_lib WHERE account_id = '{ user_account_id }' AND quiz_num_1 != 'quiz_null'")
if mycursor.fetchall():
  print("there is quizzes in your library")
else:
  print("no quizzes")

赞(0）回复(0）举报 2023-04-05

我来回答

mysql 选择同一行中的数据

1条答案

相关问题

热门标签

最新问答