Python MySql Examples

Example #1

File: data_analysis_7.py Project: liuyuzhou/ai_pre_sourcecode

def get_data():
    # 为便于观看结果形式，只展现指定结果集
    sql = 'select song_name,song_ablum,song_singer from song limit 6'
    result = MySql().read_table(sql)
    return result

Example #2

def get_data():
    # 为便于观看结果形式，只展现指定结果集
    sql = 'select song_singer,create_time from song limit 3'
    result = MySql().read_table(sql)
    return result

Example #3

File: data_show_1.py Project: liuyuzhou/ai_pre_sourcecode

def get_data():
    # 为便于观看结果形式，只展现指定结果集
    sql = 'select * from song limit 10'
    result = MySql().read_table(sql)
    return result

Example #4

File: data_analysis_1.py Project: liuyuzhou/ai_pre_sourcecode

def get_data():
    # 连接本地mysql
    sql = 'select song_ablum from song limit 10'
    result = MySql().read_table(sql)
    # print(result)
    return result