Search Results
Displaying 301 to 310
of 318 total results
- « Previous
- 29
- 30
- 31
- 32
- Next »
https://dev.mysql.com/doc/refman/9.7/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-geohash-functions.html
These geohash functions are available: ST_GeoHash(longitude, latitude, max_length), ST_GeoHash(point, max_length) Returns a geohash string in the connection character set and collation. Geohash is a system for encoding latitude and longitude ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...
https://dev.mysql.com/doc/refman/9.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/9.7/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/9.7/en/user-names.html
In addition, character set autodetection is supported as described in Section 12.4, “Connection Character Sets and Collations”. MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of a user name ...
https://dev.mysql.com/doc/refman/9.7/en/using-innodb-tables.html
row *************************** Name: t1 Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2021-02-18 12:18:28 Update_time: ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is by ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-options.html
The argument can be MYSQL_AUTODETECT_CHARSET_NAME to cause the character set to be autodetected based on the operating system setting (see Connection Character Sets and Collations). int mysql_options(MYSQL *mysql, enum mysql_option option, const ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-2-0.html
(Bug #37143289) When evaluating an expression such as value BETWEEN 'a' AND 'b', the server now checks the string literals and ensures that they use the same character set and collation as the value to be compared with them. (Bug #37132323) This ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-6-0.html
(Bug #38170188, Bug #36782728, Bug #38549372) Under certain circumstances, when used for an upgrade, mysqlpump altered the SQL mode and collation of stored procedures. Note These release notes were created with the assistance of MySQL HeatWave ...
Displaying 301 to 310
of 318 total results
- « Previous
- 29
- 30
- 31
- 32
- Next »