Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-init-db.html
Syntax: cnx.cmd_init_db(db_name) This method makes specified database the default (current) database. In subsequent queries, this database is the default for table references that include no explicit database qualifier.
https://dev.mysql.com/doc/connectors/en/connector-python-coding.html
The following guidelines cover aspects of developing MySQL applications that might not be immediately obvious to developers coming from a Python background: For security, do not hardcode the values needed to connect and log into the database in ...
https://dev.mysql.com/doc/connectors/en/connector-python-connection-pooling.html
For example: dbconfig = { "database": "test", "user": "joe" } cnx = mysql.connector.connect(pool_name = "mypool", pool_size = 3, **dbconfig) The pool name is restricted to alphanumeric characters and the special characters ., _, *, $, and #. If the ... Simple connection pooling is supported that has these characteristics: The mysql.connector.pooling module implements ...
https://dev.mysql.com/doc/connector-net/en/connector-net-connections-errors.html
The following code example shows how to manage the response of an application based on the actual error: C# Example MySql.Data.MySqlClient.MySqlConnection conn; string myConnectionString; myConnectionString = "server=127.0.0.1;uid=root;" + ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-mysqlcommand.html
The MySqlCommand class represents a SQL statement to execute against a MySQL database. Class methods enable you to perform the following database operations: Query a database Insert, update, and delete data Return a single value Command-based ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-efmodel-ddl.html
In the Properties panel, locate the DDL Generation Template in the category Database Script Generation. From the menu select Generate Database from Model to open the Generate Database Wizard dialog. In the Generate Database Wizard dialog select an ... This tutorial demonstrates how to create MySQL DDL from an Entity Framework ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
To run the example programs in this tutorial, set up a simple test database and table using the mysql Command-Line Client or MySQL Workbench. Commands for the mysql Command-Line Client are given here: CREATE DATABASE TestDB; USE TestDB; CREATE TABLE ... This tutorial teaches you how to use the MySqlScript ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl-pfx.html
using (MySqlConnection connection = new MySqlConnection( "database=test;user=sslclient;" + "CertificateFile=H:\\git\\mysql-trunk\\mysql-test\\std_data\\client.pfx;" + "CertificatePassword=pass;" + "SslMode=Required ")) { connection.Open(); } The ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-init-db.html
Syntax: cnx.cmd_init_db(db_name) This method makes specified database the default (current) database. In subsequent queries, this database is the default for table references that include no explicit database qualifier.
https://dev.mysql.com/doc/connector-python/en/connector-python-coding.html
The following guidelines cover aspects of developing MySQL applications that might not be immediately obvious to developers coming from a Python background: For security, do not hardcode the values needed to connect and log into the database in ...