1 ALTER TABLE app01_student ADD COLUMN Relation VARCHAR(255) DEFAULT'无';

2 、D:\Users\zhang.ning\PycharmProjects\APP>python manage.py startapp app01

import pymysql

sql = "SELECT * FROM userinfo "

def Sql_Query():

    try:

        connection = pymysql.connect(host='127.0.0.1',

                                     user='root',

                                     password='123456',

                                     db='test',

                                     charset='utf8',

                                     port=3306

                                     )

    except Exception as e:

        print(e)

        exit()

    try:

        with connection.cursor() as cursor:

            cursor.execute(sql)

            result = cursor.fetchall()

    except Exception as e:

        print(e)

        return False, None

    else:

        return True, result

    finally:

        connection.close()

if __name__ == '__main__':

    flag, rs = Sql_Query()

    if flag:

        print(rs)

    else:

        print("NO")