Actually i did put 'Company_ID':'Joe' and i could run it.please try
putting in mysql and let me know if there is a issue.
Tom
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post
> -Original Message-
> From: sqlalchemy@googlegroups.com
> [mailto:sqlalch...@googlegroups.com] On Behalf Of Tanmoy
> Sent: 03 April 2009 14:30
> To: sqlalchemy@googlegroups.com
> Subject: [sqlalchemy] Re: Insertion issues
>
> import sqlalchemy
> from sqla
import sqlalchemy
from sqlalchemy import *
engine = create_engine('mysql://root:voxta...@localhost/stock')
metadata = MetaData()
users=Table('NSE', metadata,
Column('Company_ID',String(40),primary_key=True),
Column('10:00',Numeric(8,2)),
)
metadata.create_all(engine)
conn = eng
conn = eng.connect()
conn.execute(users.insert(), [{'name':'joe', '10:00':'1200'}])
--
Mike Conley
On Fri, Apr 3, 2009 at 12:07 AM, Tanmoy wrote:
> Tried that...dosent work
>
>
>
>
> Tom
>
> >
>
--~--~-~--~~~---~--~~
You received this mess
Tried that...dosent work
Tom
--~--~-~--~~~---~--~~
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,
whateverfunction( **{key1:value1,...})
On Thursday 02 April 2009 10:55:20 Tanmoy wrote:
> Hi..
> I am trying to create a database where i am trying to keep
> column names as 10:00 and 10:05. The problem is when i am trying to
> insert values like users.insert().values(..,10:05='1200')
