since you're using mysql you got specify the the length for each
string, e.g., String(40);
http://www.sqlalchemy.org/docs/05/ormtutorial.html#define-and-create-a-table
On Mar 23, 1:49 pm, Peter Douma wrote:
> Here is the code I am using MySQL_Python 1.2.3 with Python 2.6
>
> db = create_engine(
Here is the code I am using MySQL_Python 1.2.3 with Python 2.6
db = create_engine('mysql://root:passw...@localhost/dbase', echo = True)
metadata = MetaData()
user = Table( 'user',metadata,
Column('id' ,Integer, primary_key = True),
Column('password' ,String, nullable = True
it should. how/where are you setting up the tables? can you post the
essential parts of your code?
On Mar 22, 9:11 pm, pete.do...@gmail.com wrote:
> I am having trouble connecting to mysql database. I keep getting
> Programming error 1146 after trying to do a metadata.create_all(). I
> created th