MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 191 to 199 of 199 total results

« Previous
18
19
20
Next »

https://dev.mysql.com/doc/refman/8.0/en/set-character-set.html

SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT} This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets three session system variables: character_set_client and ...

15.7.6 SET Statements

https://dev.mysql.com/doc/refman/8.0/en/set-statement.html

SET CHARACTER SET and SET NAMES assign values to character set and collation variables associated with the current connection to the server. Descriptions for those forms that are not associated with a specific server capability appear in subsections ...

15.7.7 SHOW Statements

https://dev.mysql.com/doc/refman/8.0/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 ...

14.16.10 Spatial Geohash Functions

https://dev.mysql.com/doc/refman/8.0/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 ...

14.16.11 Spatial GeoJSON Functions

https://dev.mysql.com/doc/refman/8.0/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 ...

15.5 Prepared Statements

https://dev.mysql.com/doc/refman/8.0/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, ...

30.4.4.1 The create_synonym_db() Procedure

https://dev.mysql.com/doc/refman/8.0/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 ...

8.2.1 Account User Names and Passwords

https://dev.mysql.com/doc/refman/8.0/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 ...

17.6.1.1 Creating InnoDB Tables

https://dev.mysql.com/doc/refman/8.0/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 ...