Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-reference-type-conversions.html
MySQL Connector/J is flexible in the way it handles conversions between MySQL data types and Java data types. In general, any MySQL data type can be converted to a java.lang.String, and any numeric type can be converted to any of the Java numeric ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html
MySQL Connector/J is flexible in the way it handles conversions between MySQL data types and Java data types. In general, any MySQL data type can be converted to a java.lang.String, and any numeric type can be converted to any of the Java numeric ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
If 25 <= p <= 53, the result is of type DOUBLE. This is actually FLOAT if the REAL_AS_FLOAT SQL mode is enabled; otherwise the result is of type DOUBLE. Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-float.html
The FLOAT and DOUBLE data types are subject to these issues. The following example uses DOUBLE to demonstrate how calculations that are done using floating-point operations are subject to floating-point error. If columns d1 and d2 had been defined ... Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
In all other cases, the arguments are compared as floating-point (double-precision) numbers. Comparisons between floating-point numbers and large integer values are approximate because the integer is converted to double-precision floating point ...
https://dev.mysql.com/doc/workbench/en/wb-model-overview-privileges.html
Figure 9.7 Roles and Privileges 9.1.1.5.1 Adding Users To add a user, double-click the Add User icon. Double-clicking this user opens the user editor docked at the bottom of the application. 9.1.1.5.2 Adding Roles and Object Privileges To add a ...
https://dev.mysql.com/doc/workbench/en/wb-routine-groups.html
9.1.6.2.1 Adding Routine Groups to the Physical Schemata Double-clicking the Add Routine Group icon in the Physical Schemata section of the MySQL Model page adds a routine group with the default name of routines1. 9.1.6.2.3 The Routine Group Editor ...If a routine group with this name already exists, the new routine group is named ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
WKB uses 1-byte unsigned integers, 4-byte unsigned integers, and 8-byte double-precision numbers (IEEE 754 format). A Point value has X and Y coordinates, each represented as a double-precision value. Two standard spatial data formats are used to ...
https://dev.mysql.com/doc/refman/8.4/en/gis-point-property-functions.html
These functions are available for obtaining point properties: ST_Latitude(p [, new_latitude_val]) With a single argument representing a valid Point object p that has a geographic spatial reference system (SRS), ST_Latitude() returns the latitude ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
The identifier quote character is the backtick (`): mysql> SELECT * FROM `select` WHERE `select`.id > 100; If the ANSI_QUOTES SQL mode is enabled, it is also permissible to quote identifiers within double quotation marks: mysql> CREATE TABLE "test" ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...