Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjs-management.html
The syntax of the routine body is checked at creation time; any errors cause the CREATE statement to be rejected, and the stored program not to be created. Using a word that is reserved in JavaScript (such as var or function) as the name of an ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-routines.html
An error is thrown if the routine, after it is closed, is called again, or if its close() method is called again. Two functions, listed here, provide JavaScript Function objects reflecting MySQL stored routines: getFunction(): Get a Function ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-session.html
getSchema(String name): Gets the Schema object having the supplied name if the corresponding schema exists, otherwise throwing an error. The Session object is always available as the session property of the global object. Session has the methods ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-transactions.html
MLE supports a JavaScript MySQL transaction API which mimics the actions of most MySQL transactional SQL statements. All of the functions listed here, along with their descriptions and SQL equivalents, are methods of the Session object: commit(): ...
https://dev.mysql.com/doc/refman/9.7/en/starting-server.html
If the command fails immediately and prints mysqld ended, look for information in the error log (which by default is the host_name.err file in the data directory). If the server is unable to access the data directory it starts or read the grant ...
https://dev.mysql.com/doc/refman/9.7/en/stored-program-restrictions.html
If you refer to a temporary table multiple times in a stored function under different aliases, a Can't reopen table: 'tbl_name' error occurs, even if the references occur in different statements within the function. READ statements that invoke ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-restrictions.html
MySQL does not support LIMIT in subqueries for certain subquery operators: mysql> SELECT * FROM t1 WHERE s1 IN (SELECT s2 FROM t2 ORDER BY s1 LIMIT 1); ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' ... In general, you cannot modify a table and select from the same table in a ...
https://dev.mysql.com/doc/refman/9.7/en/system-schema.html
For example, you cannot select from the mysql.schemata table directly: mysql> SELECT * FROM mysql.schemata; ERROR 3554 (HY000): Access to data dictionary table 'mysql.schemata' is rejected. Account-management statements are transactional and either ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/refman/9.7/en/time-zone-support.html
Otherwise, use of a named time zone results in an error: mysql> SET time_zone = 'UTC'; ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC' Populating the Time Zone Tables Several tables in the mysql system schema exist to store time zone ...
https://dev.mysql.com/doc/refman/9.7/en/unix-signal-response.html
SIGUSR1 causes the server to flush the error log, general query log, and slow query log. The server response to SIGUSR1 is a subset of the response to SIGHUP, enabling SIGUSR1 to be used as a more “lightweight” signal that flushes certain logs ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...