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 <pete.do...@gmail.com> wrote:
> 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 ),
> Column('user_name' ,String, nullable = True, unique = True ),
> Column('real_name' ,String, nullable = True ),
> Column('email_addr' ,String, nullable = True, unique = True ),
> Column('address' ,String, nullable = True ),
>
> )
>
> try:
> metadata.create_all(db)
> except Exception,err:
> print err
> exit(1)
>
>
>
> morecowbell wrote:
> > 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 the schema, but it has no tables I thought the create_all
> >> would make the tables
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
