Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-serverprep.html
The first step is using MySQL with BLOB data is to configure the server. 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, ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-wordexcel.html
Within Microsoft Excel, you can execute queries on your MySQL server and import the data directly into an Excel Worksheet, presenting the data as a series of rows and columns. Figure 6.19 Microsoft Query Wizard: Choose Data Source Dialog Within the ... You can use Microsoft Word and Microsoft Excel to access information from a MySQL database using ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-description.html
Syntax: tuples = cursor.description This read-only property returns a list of tuples describing the columns in a result set. Each tuple in the list contains values as follows: (column_name, type, None, None, None, None, null_ok, column_flags) The ...To see how to interpret it, do this: >>> from mysql.connector import FieldFlag >>> FieldFlag.desc ...
https://dev.mysql.com/doc/internals/en/optimizer-early-nulls-filtering.html
Suppose further that table tblY is accessed via ref or eq_ref access on tblY.key_column = tblX.column or, in the case of ref access using multiple key parts, via ... We make the following inference: (tblY.key_partN = tblX.column) => (tblX.column IS ... Suppose we have a join order such as this one: ..., tblX, ..., tblY, ...
https://dev.mysql.com/doc/mysqld-version-reference/en/information-schema-tables.html
The following table shows all INFORMATION_SCHEMA tables available in MySQL Server. Introduced: The version or versions in which the item was introduced. Deprecated: The version or versions in which the item was deprecated. Removed: The version or ...
https://dev.mysql.com/doc/mysqld-version-reference/en/options-variables.html
The following table shows all the options and variables available in MySQL Server. Intr: The version or versions in which the item was introduced. Depr: The version or versions in which the item was deprecated. Removed: The version or versions in ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-persistent.html
4.3.2.13.1 Synopsis @Target(value={java.lang.annotation.ElementType.FIELD, java.lang.annotation.ElementType.METHOD}) @Retention(value=java.lang.annotation.RetentionPolicy.RUNTIME) public @interface Persistent { public NullValue nullValue ; public ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbscanoperation.html
If it is present, then only columns for which the corresponding bit in the mask is set are retrieved by the scan. If it is present, then only columns for which the corresponding bit in the mask is set are retrieved by the scan. SF_OrderByFull This ...NdbScanOperation Class Overview NdbScanOperation::close() NdbScanOperation::deleteCurrentTuple() NdbScanOperation::getNdbTransaction() NdbScanOperation::getPruned() NdbScanOperation::lockCurrentTuple() NdbScanOperation::nextResult() NdbScanOperation::readTuples() NdbScanOperation::restart() NdbScanOperation::ScanFlag NdbScanOperation::ScanOptions NdbScanOperation::updateCurrentTuple() NdbScanOperation Class Overview Parent class NdbOperation Child classes NdbIndexScanOperation Description The NdbScanOperation class represents a scanning operation used in a ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-tablemapping.html
A default table mapping is one which maps each column in a table to a field of the same name. TableMapping = { String table : "" , String database : "" , boolean mapAllColumns : true, Array fields : null }; The table and data members are the names ... A TableMapping describes the mapping of a domain object in the application to a table stored in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES table. If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table ...Check if you have the SELECT and INSERT privileges for the table that you want to ...