9.数据库多表一起查询

查询多表（子查询）匹配

SELECT*from data_names  WHERE `Name` not in (SELECT  search_name FROM qichacha );

 

可用链接数据库查询代码：

#coding:utf-8

from pymysql import connect
import re
data_list1=[]

# 将数据存入数据库
conn = connect(host="172.16.0.55",
               port=3306,
               database="**********",
               user="root",
               password="*********",
               charset="utf8")

cursor = conn.cursor()

try:
    sql = "SELECT*from data_names  WHERE `Name` not in (SELECT  search_name FROM qichacha );"
    cursor.execute(sql)
    names=cursor.fetchall()
    # print(names)
    for name in names:
        name1=list(name)
        # print(name1)
        data_list1.append(str(name1[1]))
    print(data_list1)
except:
    print('异常!')
cursor.close()
conn.commit()
conn.close()

print("*"*100)

print(data_list1)
# for i in data_list1:
#     print(i)