Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-using-character-sets.html
To insert 4-byte UTF8 strings into blob columns, use the .NET Encoding.GetBytes function to convert your string to a series of bytes. Treating Binary Blobs As UTF8 Before the introduction of 4-byte UTF-8 character set, MySQL did not support 4-byte ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-commit.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.commit() To roll back instead and discard modifications, see the rollback() method. This method sends a COMMIT statement to the MySQL server, ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-rollback.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.rollback() To commit modifications, see the commit() method. This method sends a ROLLBACK statement to the MySQL server, undoing all data changes ...
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core-example.html
Insert the following code into the existing Program.cs file, replacing the default C# code. The Code First approach enables you to define an entity model in code, create a database from the model, and then add data to the database. MySQL ...
https://dev.mysql.com/doc/connector-net/en/connector-net-using-character-sets.html
To insert 4-byte UTF8 strings into blob columns, use the .NET Encoding.GetBytes function to convert your string to a series of bytes. Treating Binary Blobs As UTF8 Before the introduction of 4-byte UTF-8 character set, MySQL did not support 4-byte ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
ccnx.query('DROP TABLE IF EXISTS t') ccnx.query('CREATE TABLE t (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY)') ccnx.query('INSERT INTO t (i) VALUES (NULL),(NULL),(NULL)') ccnx.query('SELECT LAST_INSERT_ID()') row = ccnx.fetch_row() ...raw_as_string ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-commit.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.commit() To roll back instead and discard modifications, see the rollback() method. This method sends a COMMIT statement to the MySQL server, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-rollback.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.rollback() To commit modifications, see the commit() method. This method sends a ROLLBACK statement to the MySQL server, undoing all data changes ...
https://dev.mysql.com/doc/internals/en/event-meanings.html
INTVAR_EVENT Written every time a statement uses an AUTO_INCREMENT column or the LAST_INSERT_ID() function; precedes other events for the statement. An INTVAR_EVENT is written with a "subtype" in the event data part: INSERT_ID_EVENT indicates the ...
https://dev.mysql.com/doc/internals/en/myisam-directory.html
They are: mi_cache.c --- for reading records from a cache mi_changed.c --- a single routine for setting a "changed" flag (very short) mi_check.c --- for checking and repairing tables. Can be used to exactly replay a set of changes to a table.