title: How to fix 'Background on this error at: http://sqlalche.me/e/e3q8'?
body: <p>I have written the following code using Python</p>
  
  <pre><code>from sqlalchemy import Table,create_engine,String,Float,Integer,Column,MetaData 
  engine = create_engine('sqlite:///college.db',echo = True)
  meta = MetaData() 
  Players = Table('Players',meta,
                  Column('name',String),
                  Column('number',Integer),
                  Column('Speed',Float))
  meta.create_all(engine) 
  conn = engine.connect() 
  from sqlalchemy.sql.expression import update  
  up = update(Players).where(Players.name == 'Rolnando').values(name = 'Messi') 
  s = Players.select() conn.execute(s)
  </code></pre>
  
  <p>But I am getting the following exception</p>
  
  <blockquote>
    <p>File
    "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\default.py",
    line 509, in do_execute
        cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such
    column: Players.number [SQL: 'SELECT "Players".name, "Pla
    yers".number, "Players"."Speed" \nFROM "Players"'] (Background on this
    error at: <a href="http://sqlalche.me/e/e3q8" rel="nofollow noreferrer">http://sqlalche.me/e/e3q8</a>)</p>
  </blockquote>
  
  <p>Why am I receiving this error and how do I resolve it?</p>