PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
It returns the exact string that can be used to re-create the named stored procedure. A similar statement, SHOW CREATE FUNCTION, displays information about stored functions (see Section 13.7.5.8, “SHOW CREATE FUNCTION Statement”). If you do not ... SHOW CREATE PROCEDURE proc_name This statement is a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
The specification describes a set of SQL geometry types, as well as functions on those types to create and analyze geometry values. MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
All credentials are stored in the authentication_string column, including those formerly stored in the Password column. If performing an in-place upgrade to MySQL 5.7.6 or later, run mysql_upgrade as directed by the in-place upgrade procedure to ...
https://dev.mysql.com/doc/refman/5.7/en/apis-perl.html
For ways to quote string literals, see Section 9.1.1, “String Literals”. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
The following table illustrates the differences between CHAR and VARCHAR by showing the result of storing various string values into CHAR(4) and VARCHAR(4) columns (assuming that the column uses a single-byte character set such as latin1). The CHAR ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
Character (nonbinary) string values are converted from their character set to UTF-8. Binary string values are copied as is for bytes in the range 0x20 to 0x7E, and using \x hexadecimal encoding for bytes outside that range. This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
The value cannot be the error value (that is, 0 or the empty string). A SET value must be the empty string or a value consisting only of the values listed in the column definition separated by commas. For SET, the value is inserted as given except ... ENUM and SET columns provide an efficient way to define columns that can contain only a given set of ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
Rather than storing a customer or catalog item number as a string of digits, potentially using up several bytes, convert it to a numeric ID for storing and querying. If you have MyISAM tables that you want to convert to InnoDB for better ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
For nonbinary (character) string columns, the character set and collation must be the same. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/5.7/en/data-types.html
MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. This chapter provides an overview and more detailed description of the properties of ...