Lines Matching refs:sql
49 https://www.w3schools.com/sql/
430 .. code-block:: sql
447 .. code-block:: sql
620 .. method:: execute(sql, parameters=(), /)
623 :meth:`~Cursor.execute` on it with the given *sql* and *parameters*.
626 .. method:: executemany(sql, parameters, /)
629 :meth:`~Cursor.executemany` on it with the given *sql* and *parameters*.
1023 # Convert file example.db to SQL dump file dump.sql
1025 with open('dump.sql', 'w') as f:
1336 .. method:: execute(sql, parameters=(), /)
1342 :param str sql:
1346 Python values to bind to placeholders in *sql*.
1353 If *sql* contains more than one SQL statement.
1356 *sql* is an ``INSERT``, ``UPDATE``, ``DELETE``, or ``REPLACE`` statement,
1358 a transaction is implicitly opened before executing *sql*.
1362 .. method:: executemany(sql, parameters, /)
1366 :abbr:`DML (Data Manipulation Language)` SQL statement *sql*.
1370 :param str sql:
1375 the placeholders in *sql*.
1380 If *sql* contains more than one SQL statement,
1852 >>> sql = "SELECT * FROM stocks WHERE symbol = '%s'" % symbol
1853 >>> print(sql)
1855 >>> cur.execute(sql)