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/update.html
The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. The mysql_info() C API function returns the number of rows that were matched and updated and the number of ... UPDATE is a DML statement that modifies rows in a ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
When using a CONNECTION string, you cannot use an '@' character in the password. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
The argument to AGAINST() must be a string value that is constant during query evaluation. For example, for an INSERT operation, an inserted string is tokenized and decomposed into individual words. Full-text searches are supported for InnoDB and ...