Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collections-as-relational-tables.html
The following example shows how to insert a JSON document string into the doc field. Applications that seek to store standard SQL columns with Documents can cast a collection to a table. In this case a collection can be fetched as a Table object ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/creating-documents.html
// Create a new collection 'my_collection' var myColl = db.createCollection('my_collection'); // Insert JSON data directly myColl.add({_id: '8901', name: 'Mats', age: 21}).execute(); // Inserting several docs at once myColl.add([ {_id: '8902', name: ... Once a collection has been created, it can store JSON ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collections-as-relational-tables.html
The following example shows how to insert a JSON document string into the doc field. # Get the customers collection as a table customers = db.get_collection_as_table('customers') customers.insert('doc').values('{"_id":"001", "name": "Ana", ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/creating-documents.html
// Create a new collection 'my_collection' var myColl = db.createCollection('my_collection'); // Insert JSON data directly myColl.add({_id: '8901', name: 'Mats', age: 21}).execute(); // Inserting several docs at once myColl.add([ {_id: '8902', name: ... Once a collection has been created, it can store JSON ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
Truncation of excess trailing spaces from values to be inserted into TEXT columns always generates a warning, regardless of the SQL mode. For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-enum.html
Unless strict mode is disabled (not recommended, but see Section 7.1.11, “Server SQL Modes”), the definition of a ENUM or SET column acts as a constraint on values entered into the column. Errors for invalid values can be suppressed in strict ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system schema. This query displays the row in this table inserted by the statement just shown for creating the user jim@localhost: mysql> ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-restrictions.html
For example, for an INSERT operation, an inserted string is tokenized and decomposed into individual words. For InnoDB, all DML operations (INSERT, UPDATE, DELETE) involving columns with full-text indexes are processed at transaction commit time.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
Even if free space displays as 0, it may be possible to insert rows as long as new extents need not be allocated. Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
(Even if a view is updatable, it might not be possible to insert into it; for details, refer to Section 27.5.3, “Updatable and Insertable Views”.) DEFINER The account of the user who created the view, in 'user_name'@'host_name' format. If a view ...You must have the SHOW VIEW privilege to access this ...