Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-procedure.html
The following example shows a simple stored procedure that, given a country code, counts the number of cities for that country that appear in the city table of the world database. This prohibition includes SELECT statements that do not have an INTO ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/9.7/en/local-variable-scope.html
A local variable should not have the same name as a table column. Consequently, when the procedure sp1()is called, the newname variable returns the value 'bob' regardless of the value of the table1.xname column. The scope of a local variable is the ...
https://dev.mysql.com/doc/internals/en/charsets.html
Character sets are recorded against individual tables and returned as part of the field data. You can obtain a list of the available character sets configured within a server by running SHOW COLLATION, or by running a query on the ... Character sets ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-operations.html
To insert a new row into the table, first create a new instance of Employee. This can be accomplished by calling the Session method newInstance(), as shown here: Employee newEmployee = session.newInstance(Employee.class); Set the Employee instance ...For example, the following sets the id, firstName, lastName, and started ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
This includes the server data directory containing the files that implement the privilege tables. In addition to user data, the data directory contains data dictionary and system tables, which store sensitive information about database objects, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model-ratings-rankings.html
mysql> CALL sys.ML_MODEL_LOAD('recommendation_use_case', NULL); Make predictions for the test dataset by using the ML_PREDICT_TABLE routine. mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace ... This ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Select either of the following SSL modes: Disabled: Establishes an unencrypted connection between the source and target. Required: (Default) If the server supports encrypted connection, establishes an encrypted connection. The connection attempt ...
https://dev.mysql.com/doc/refman/9.7/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. Use the CREATE TABLE statement to create a table ...See also the notes about spatial indexes under Section 13.4.10, “Creating Spatial ...
https://dev.mysql.com/doc/refman/9.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. Handling of Enumeration Literals Trailing spaces are automatically deleted from ENUM ...See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/9.7/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Indexes are especially important for queries that reference ...