7TbLhms3

1Populate MySQL table with db file
2for filename in filenames:
3        with contextlib.closing(shelve.open(filename, flag = "w")) as data:     
4prdata = data['all'].keys()
5	
6tbl= """CREATE TABLE IF NOT EXISTS table2 (
7      `class` varchar(30) default NULL,
8      `name` varchar(120) default NULL,
9       )""" 
10cursor.execute(tbl)
11	
12LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
13    [REPLACE | IGNORE]
14    INTO TABLE tbl_name
15    [CHARACTER SET charset_name]
16    [{FIELDS | COLUMNS}
17        [TERMINATED BY 'string']
18        [[OPTIONALLY] ENCLOSED BY 'char']
19        [ESCAPED BY 'char']
20    ]
21	
22cursor.executemany(
23      """INSERT INTO table2 (class, name)
24      VALUES (%s, %s)""",
25      [
26      ("class1", "name1" ),
27      ("class2", "name2" ),
28      ("class3", "name3" )
29      ] )