pythonデータベースに接続して音楽ソフトを作成する

import pymysql
conn = pymysql.connect(host="localhost",user="root",password="123",db="day300",charset="utf8")
car = conn.cursor()



#     t_music
sql = '''CREATE TABLE t_music(
        id INT PRIMARY KEY AUTO_INCREMENT, --   
        mname VARCHAR(32), --   
        path VARCHAR(320)  --       
);

'''
car.execute(sql)
conn.commit()





#       id,  ,  
sql1=r'''insert into t_music values(1,"    -       ","F:\\\\pycharm2019.1.3\\\\PyCharm word\\\\  \\\\  \\\\    -       .mp3"), 
--           r  pycharm   \       ,   \\\\, mysql   \\,     pycharm   \\\\
          (2,"  JUN -    ","F:\\pycharm2019.1.3\\PyCharm word\\  \\  \\  JUN -    .mp3"),
--           r  pycharm   \       ,   \\, mysql   \,     pycharm   \\
          (3,"   -   ","F:\pycharm2019.1.3\PyCharm word\  \  \   -   .mp3");
--            r  pycharm   \       ,   \ mysql    ,    pycharm    
'''

car.execute(sql1)
conn.commit()





#      
sql2 = "select * from t_music"
car.execute(sql2)
#    conn.commit()
data =  car.fetchall()
print(data)
# ((1, '    -       ', 'F:\\\\pycharm2019.1.3\\\\PyCharm word\\\\  \\\\  \\\\    -       .mp3'),
#  (2, '  JUN -    ', 'F:\\pycharm2019.1.3\\PyCharm word\\  \\  \\  JUN -    .mp3'),
#  (3, '   -   ', 'F:pycharm2019.1.3PyCharm word       -   .mp3'))



#  pygame    
import pygame,time      #  pyname mixer    
pygame.mixer.init()     #   
pygame.mixer.music.load(data[1][2])    #    path  
pygame.mixer.music.play()       #           
time.sleep(100)                 #