Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-YEAR.html
Connector/J follows the same rules that govern how values are inserted by a mysql client; see explanations in The YEAR Type for details. Treatments of zero values depend on whether they are strings or numbers, and on the value of yearIsDateType: If ... How a value in a MySQL YEAR column is handled is controlled by the connection property yearIsDateType: If yearIsDateType is true (the default), YEAR is mapped to the Java data type ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-crystalreports.html
Open Crystal Reports and create a new project, or an open an existing reporting project into which you want to insert data from your MySQL data source. Figure 5.40 Cross-Tab Report Creation Wizard: Final Report Once the ODBC connection has been ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
The majority of Microsoft applications have been tested with Connector/ODBC, including Microsoft Office, Microsoft Access and the various programming languages supported within ASP and Microsoft Visual Studio. 5.8.2.1.1 Microsoft Access To improve ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-crystalreports.html
Open Crystal Reports and create a new project, or an open an existing reporting project into which you want to insert data from your MySQL data source. Figure 6.29 Cross-Tab Report Creation Wizard: Final Report Once the ODBC connection has been ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-excel.html
If you have problems importing data into Microsoft Excel, particularly numeric, date, and time values, this is probably because of a bug in Excel, where the column type of the source data is used to determine the data type when that data is ...The ...
https://dev.mysql.com/doc/internals/en/scripts-directory.html
mysql_setpermission.sh --- Aid to add users or databases, sets privileges mysql_tableinfo.sh --- Puts info re MySQL tables into a MySQL table mysql_zap.sh --- Kill processes that match pattern . Linux programmers use it where Windows programmers ...
https://dev.mysql.com/doc/internals/en/sleep.html
send INSERT INTO t1 VALUES (1); --connection conn1 # Sleep until we can be sure that conn2 reached wait_for_lock(). One solution is to use the 'sleep' command of 'mysqltest' in front of the SQL statement that drives the remaining thread into the ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-tableconfiguration-category.html
Low Priority Updates Enabled When enabled, all INSERT, UPDATE, DELETE, and LOCK TABLE WRITE statements wait until there is no pending SELECT or LOCK TABLE READ on the affected table. Metadata Locks Hash Instances The set of metadata locks can be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
In MySQL HeatWave, you can explicitly exclude certain table columns from being loaded into the MySQL HeatWave Cluster, by defining them with the NOT SECONDARY attribute. Check if you have the SELECT and INSERT privileges for the table that you want ...These columns are typically not needed for analytic queries and are therefore omitted to optimize memory usage and ...