Python query_result Beispiele

Beispiel #1

Datei: 01.missing_record.py Projekt: vanillapapaya/Programmers_SQL

import sys
sys.path.append("..")
import mysql_connect
    
query = """

    SELECT OUTS.ANIMAL_ID, OUTS.NAME
    FROM ANIMAL_INS AS INS
    RIGHT JOIN ANIMAL_OUTS AS OUTS
    ON INS.ANIMAL_ID = OUTS.ANIMAL_ID
    WHERE INS.ANIMAL_ID IS NULL
    ORDER BY OUTS.ANIMAL_ID

"""

result = mysql_connect.query_result(query)

Beispiel #2

import sys
sys.path.append("..")
import mysql_connect
    
query1 = """

    SELECT DATETIME AS 시간
    FROM ANIMAL_INS
    ORDER BY DATETIME DESC
    LIMIT 1

"""

query2 = """

    SELECT MAX(DATETIME) AS 시간
    FROM ANIMAL_INS

"""

result1 = mysql_connect.query_result(query1)
result2 = mysql_connect.query_result(query2)