Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql.html
This section describes how to set up your application to view MySQL trace information. The first thing you need to do is create a suitable app.config file for your application. The switch level in this case is set to Verbose to display the maximum ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN configuration. Alternatively, you can set these parameters within the InConnectionString argument in the SQLDriverConnect() call. Table 5.1 Connector/ODBC DSN ...
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-python/en/connector-python-example-cursor-select.html
The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees hired in the year 1999 and print their names and hire dates to the console. We then create a new ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, ...
https://dev.mysql.com/doc/internals/en/error-messages-5-0-3-higher.html
The file you edit to add a new error message depends on your version of MySQL: MySQL 5.0.3 up to 5.5: Edit errmsg.txt MySQL 5.5 and up: Edit errmsg-utf8.txt In either case, comp_err generates the header files automatically during the MySQL build ...
https://dev.mysql.com/doc/internals/en/innodb-field-contents.html
The Field Contents part of the record has all the data. There are no markers between fields, and there is no marker or filler at the end of a record. I made a table with this definition: CREATE TABLE T (FIELD1 VARCHAR(3), FIELD2 VARCHAR(3), FIELD3 ...
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
LOAD DATA INFILE is not written to the binary log like other statements. It is written as one or more events in a packed format, not as a cleartext statement in the binary log. The events indicate what options are present in the statement and how ...
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format"). These files will be in the directory: /<datadir>/<database>/ For example, if you use Linux, you might find the files in the ...