Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorbuffered.html
To create a buffered cursor, use the buffered argument when calling a connection's cursor() method. Alternatively, to make all cursors created from the connection buffered by default, use the buffered connection argument. Example: import ...After ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorraw.html
To create a raw cursor, use the raw argument when calling a connection's cursor() method. Alternatively, to make all cursors created from the connection raw by default, use the raw connection argument. Example: import mysql.connector cnx = ...A ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-serverprep.html
For this example, use the following table definition: CREATE TABLE file( file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, file_size MEDIUMINT UNSIGNED NOT NULL, file MEDIUMBLOB NOT NULL); After creating ... The first step is using MySQL with BLOB data is to configure the ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-net-csharp.html
The following sample creates a table my_odbc_net and demonstrates its use in C#. { for (int i=0; i < MyOdbcException.Errors.Count; i++) { Console.Write("ERROR #" + i + "\n" + "Message: " + MyOdbcException.Errors[i].Message + "\n" + "Native: " + ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-ado.html
The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = "updated-second-time" rs.Update rs.Close 'rs delete ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-dao.html
The following DAO (Data Access Objects) example creates a table my_dao and demonstrates the use of rs.addNew, rs.update, and result set scrolling. Set rs = conn.OpenRecordset("my_dao") rs.Edit rs!Name = "updated-string" rs.Update rs.Close 'fetch ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-rdo.html
The following RDO (Remote Data Objects) example creates a table my_rdo and demonstrates the use of rs.addNew and rs.update. SQL = "select * from my_rdo" Set rs = cn.OpenResultset(SQL, rdOpenStatic, rdConcurRowVer, rdExecDirect) Do Until rs.EOF For ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html
To create a linked table: Open the Access database that you want to link to MySQL. Figure 6.12 External Data: ODBC Database In the Get External Data dialog box that appears, choose Link to the data source by creating a linked table and click OK. To ... You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cursor.html
Arguments may be passed to the cursor() method to control what type of cursor to create: If buffered is True, the cursor fetches all rows from the server after an operation is executed. buffered can also be passed to connect() to set the default ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorbuffered.html
To create a buffered cursor, use the buffered argument when calling a connection's cursor() method. Alternatively, to make all cursors created from the connection buffered by default, use the buffered connection argument. Example: import ...After ...