Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks-handling.html
For example, organize database operations into functions within your application, or call stored routines, rather than coding multiple similar sequences of INSERT, UPDATE, and DELETE statements in different places. You can get deadlocks even in the ... This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-relational-tables.html
mysql-js> db.getTables() { "city": <Table:city>, "country": <Table:country>, "countrylanguage": <Table:countrylanguage> } Basic Table Operations Basic operations scoped by tables include: Operation form Description db.name.insert() The insert() ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-relational-tables.html
mysql-py> db.get_tables() [ <Table:city>, <Table:country>, <Table:countrylanguage> ] Basic Table Operations Basic operations scoped by tables include: Operation form Description db.name.insert() The insert() method inserts one or more records into ... You can also use X DevAPI to work with relational ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
A very common error is to insert a new row with Host='%' and User='some_user', thinking that this enables you to specify localhost to connect from the same machine. Because that row has a Host value 'localhost' that is more specific than '%', it is ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...