Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Do not output explicit error ...Note It is possible to obtain XML-formatted output from MySQL in the mysql and mysqldump clients by invoking them with the --xml ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-29.html
It is suitable for use with MySQL Server versions 8.0 and 5.7. (Bug #106065, Bug #33726184) When inserting BigDecimal values into a database using rewritable server-side prepared statements with cursor-based fetching, the values suffered precision ... Version 8.0.29 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-foreign-key-relationships.html
MySQL Workbench enables you to add a foreign key from within the table editor or from within an EER diagram by using the relationship tools on the vertical toolbar. To add a foreign key using the table editor, see Section 8.1.10.4, “Foreign Keys ... Foreign key constraints are supported for the InnoDB storage engine ...
https://dev.mysql.com/doc/workbench/en/wb-grt-data-organization.html
Workbench model data, such as diagrams, schemas, and tables, is stored in a hierarchy of objects that can be accessed by any plugin. Main Nodes in the Application Object Tree Table C.1 The main nodes in the Application Object Tree Node Description ... The Generic RunTime (GRT) is the internal system used by MySQL Workbench to hold model document ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-online-backup.html
The Contents subtab defines the schemas and tables to back up, and whether the job is a full or partial backup: Full backup: All schemas and tables are backed up (see the figure that follows). Figure 6.28 Workbench: MySQL Enterprise Backup ... This ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-live.html
It has a section for each object type present in the schema that you can import (tables, views, routines, and so forth). The following figure shows an example of the table object section with the filter open. Figure 9.53 Select Objects The options ... To reverse-engineer a live database, click Database and then Reverse Engineer from the ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
To use transactional database access, we will need to change the storage engine of the tables in the world database. The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. ALTER TABLE City ... Spring ...