python 判断sqlite数据库中的表是否存在，不存在就创建

#判断表存不存在来创建表

def create_table():



    conn = sqlite3.connect(db_name)

    try:

        create_tb_cmd='''

        CREATE TABLE IF NOT EXISTS USER

        (NAME TEXT,

        AGE INT,

        SALARY REAL);

        '''

        #主要就是上面的语句

        conn.execute(create_tb_cmd)

    except:

        print "Create table failed"

        return False

    insert_dt_cmd='''

    INSERT INTO USER (NAME,AGE,SALARY) VALUES ("Jack",10,20.1);

    '''

    conn.execute(insert_dt_cmd)

    conn.commit()

    conn.close()