#coding:utf-8
    import connectex
    import datetime
    
    dt = datetime.date.today()
    print(dt)
    print(datetime.datetime.now())
    
    mydb = connectex.getDB()
    mycursor = mydb.cursor()
    #guest(id int primary key auto_increment, name varchar(255), birthday date, address varchar(255), sex char(10))")
    sql = "insert into guest (name, birthday,address,sex) VALUES (%s, %s,%s,%s)"
    val = [
      ('赤星あきら', '2000-02-05','熊本市清水','男'),
      ('氏江アミ', '2001-05-23','阿蘇市','女'),
      ('Michael','1998-09-10', 'Valley 345','女'),
      ('Sandy','1990-11-23', 'Ocean blvd 2','M'),
      ('Richard','1992-03-27', 'Sky st 331','M'),
      ('Susan','1991-10-06', 'One way 98','F'),
      ('Vicky','1987-04-29', 'Yellow Garden 2',''),
      ('Ben','1978-03-08', 'Park Lane 38','M'),
      ('William','1988-10-26', 'Central st 954',''),
      ('Chuck','2002-05-15', 'Main Road 989','M'),
      ('Viola','2003-12-23', 'Sideway 1633','F')
    ]
    
    mycursor.executemany(sql, val)
    mydb.commit()
    print(mycursor.rowcount, "was inserted.")
    
    sql = "select * from guest"
    mycursor.execute(sql)
    myresult = mycursor.fetchall()
    for x in myresult:
        print(x)
        
    mydb.close()