Input the values to the respective fields in prettytable

I just have to input the values to the respective fields in prettytable.

def report_book_list():
    clear()
    print('\n REPORT - BOOK TITLES ')
    print('-'*120)
    sql ='select * from book'
    mc.execute(sql)
    while True:
        r=mc.fetchone()
        if r== None:
            break
        print(r)
    table=PrettyTable()
    columns= ["ID", "TITLE", "AUTHOR", "PUBLISHER", "PAGES", "PRICE", "EDISION", "COPIES", "STATUS"]
    table.add_column(columns[0],12)
    table.add_column(columns[1],12)
    table.add_column(columns[2],12)
    table.add_column(columns[3],12)
    table.add_column(columns[4],12)
    table.add_column(columns[5],12)
    table.add_column(columns[6],12)
    table.add_column(columns[7],)
    table.add_column(columns[8],'HI')
    print(table)
    print( 'No of Records : ', mc.rowcount)
    wait = input('\n\n\nPress any key to continue.....')