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
-~----------~----~----~----~------~----~------~--~---
