MySqlDb python, syntax error, can not understand

Question

I have this query

        self.cursor.execute("""INSERT IGNORE INTO 
                        groups 
                        (
                            name,
                            builder_id,
                            content,city,
                            location,price,
                            target,
                            project_completion,
                            creator_id,verified,
                            live,
                            updater_id,
                            verify_id
                        ) 
                        VALUES 
                        (
                            %s,
                            %s,
                            %s,
                            %s,
                            %s,
                            %s,
                            %s,
                            '30',
                            '4',
                            '1',
                            '1',
                            '4',
                            '4'
                        );""", 
                       (
                            item['name'],
                            builder_id,
                            item['content'],
                            item['city'],
                            item['address'],
                            item['price'],
                            item['possession_date']
                        )
        )

I am scraping a few data and putting in into a mysql database using Scrapy. I am keep getting a syntax error

traceback

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '),
                                18,
                                ("'friend' at line 19

18 is the builder_id and friend... is the start of content field any help??

Post the traceback, don't just say "I keep getting a syntax error". — abarnert
– abarnert, Commented Nov 29, 2013 at 7:17
Are you sure item['name'] and item['content'] are strings and not, say, tuples — RedBaron
– RedBaron, Commented Nov 29, 2013 at 7:31
Pretty print or inspect in any other way your "item" object, it might not be exactly what you think... — bruno desthuilliers
– bruno desthuilliers, Commented Nov 29, 2013 at 7:32
The traceback tells you exactly what the problem is: one of the values is ("'friend'—in other words, as @RedBaron said, one of your values is a tuple (because that's what the start of a tuple of strings looks like). And that's why you should give the traceback in your questions, instead of making people guess. — abarnert
– abarnert, Commented Nov 29, 2013 at 8:03

Tiger Lu · Accepted Answer · 2013-11-29 08:49:46Z

-1

The execute() method take only 1 single param.

cursor.execute('insert into a ("a", "b") values (1,2)')

So, there is not supposed to be ',' in your param. you could try this

self.cursor.execute("""INSERT IGNORE INTO 
                    groups 
                    (
                        name,
                        builder_id,
                        content,city,
                        location,price,
                        target,
                        project_completion,
                        creator_id,verified,
                        live,
                        updater_id,
                        verify_id
                    ) 
                    VALUES 
                    (
                        %s,
                        %s,
                        %s,
                        %s,
                        %s,
                        %s,
                        %s,
                        '30',
                        '4',
                        '1',
                        '1',
                        '4',
                        '4'
                    );""" % (
                        item['name'],
                        builder_id,
                        item['content'],
                        item['city'],
                        item['address'],
                        item['price'],
                        item['possession_date']
                    )
    )

answered Nov 29, 2013 at 8:49

Tiger Lu

13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

bruno desthuilliers Over a year ago

Please check your facts and stop posting wrong and ill-advised answers. And read this too: xkcd.com/327

bruno desthuilliers Over a year ago

python.org/dev/peps/pep-0249/#id15 and stackoverflow.com/questions/2097475/…

Collectives™ on Stack Overflow

MySqlDb python, syntax error, can not understand

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related