Method execute

src/MySQLdb/cursors.py:162–180

Execute a query. query -- string, query to execute on server args -- optional sequence or mapping, parameters to use with query. Note: If args is a sequence, then %s must be used as the parameter placeholder in the query. If a mapping is used, %(key)s must b

(self, query, args=None)

        return con

    def execute(self, query, args=None):
        """Execute a query.

        query -- string, query to execute on server
        args -- optional sequence or mapping, parameters to use with query.

        Note: If args is a sequence, then %s must be used as the
        parameter placeholder in the query. If a mapping is used,
        %(key)s must be used as the placeholder.

        Returns integer represents rows affected, if any
        """
        self._discard()

        mogrified_query = self._mogrify(query, args)

        assert isinstance(mogrified_query, (bytes, bytearray))
        res = self._query(mogrified_query)
        return res

    def _mogrify(self, query, args=None):
        """Return query after binding args."""