Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
CREATE DATABASE is not permitted within a session that has an active LOCK TABLES statement. The ENCRYPTION option defines the default database encryption, which is inherited by tables created in the database. If the ENCRYPTION option is not ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6), ts TIMESTAMP(0)); The fsp value, if given, must be in the range 0 to 6. (This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Any TIMESTAMP or ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
CATALOG_NAME, SCHEMA_NAME, TABLE_NAME, COLUMN_NAME: Strings that indicate the catalog, schema, table, and column related to the condition. SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a ...
https://dev.mysql.com/doc/refman/8.4/en/drop-function-loadable.html
It requires the DELETE privilege for the mysql system schema because it removes the row from the mysql.func system table that registers the function. DROP FUNCTION also removes the function from the Performance Schema user_defined_functions table ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-system-variables.html
For a description of the privilege requirements for setting system variables, see Section 7.1.9.1, “System Variable Privileges” The following table lists all dynamic system variables applicable within mysqld. This differs from the ENUM data type ... Many server system variables are dynamic and can be set at ...
https://dev.mysql.com/doc/refman/8.4/en/entering-queries.html
At this point, it is more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. Normally, column labels are the names of the columns you fetch from ...
https://dev.mysql.com/doc/refman/8.4/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/8.4/en/examples.html
Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Here are examples of how to solve some common problems with MySQL. Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/8.4/en/fetching-spatial-data.html
Geometry values stored in a table can be fetched in internal format. Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM ...SELECT ST_AsText(g) FROM geom; Fetching spatial data in WKB format: The ST_AsBinary() function converts a geometry from internal format to a BLOB containing the WKB ...
https://dev.mysql.com/doc/refman/8.4/en/fractional-seconds.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6)); The fsp value, if given, must be in the range 0 to 6. MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a ...