PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-database.html
Every database has a database character set and a database collation. The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET ...If CHARACTER SET charset_name is specified without COLLATE, character set charset_name and its default collation are ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
Once you know how to enter SQL statements, you are ready to access a database. For example, a database like this could be used by a farmer to keep track of livestock, or by a veterinarian to keep track of patient records. Use the SHOW statement to ...Suppose that you have several pets in your home (your menagerie) and you would like to keep track of various types of information about ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
mysql> SELECT X'616263', HEX('abc'), UNHEX(HEX('abc')); -> 'abc', 616263, 'abc' mysql> SELECT HEX(255), CONV(HEX(255),16,10); -> 'FF', 255 INSERT(str,pos,len,newstr) Returns the string str, with the substring beginning at position pos and len ...For ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
To perform such a standard, basic installation, go to the folder that contains all those packages (and, preferably, no other RPM packages with similar names), and issue the following command for platforms other than Red Hat Enterprise Linux/Oracle ... The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
A number of changes are made in the ndbinfo database, chief of which is that it now provides detailed information about NDB Cluster node configuration parameters. In addition, the ndbinfo database no longer depends on the MyISAM storage engine. The ... Major changes and new features in NDB Cluster 7.5 which are likely to be of interest are shown in the following list: ndbinfo ...
https://dev.mysql.com/doc/refman/5.7/en/creating-database.html
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL ...
https://dev.mysql.com/doc/refman/5.7/en/show-databases.html
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. The LIKE clause, if present, indicates which database names to match. You see only those databases for which you have some kind of ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 24.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-databases.html
Replacing a database directory with a symbolic link works as long as you do not make a symbolic link between databases. On Unix, the way to symlink a database is first to create a directory on some disk where you have free space and then to create ...If one client updates db1.tbl_a and another client updates db2.tbl_a, problems are likely to ...
https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You might have to run commands as the MySQL root user on the new machine until you have the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
By default, tables are created in the default database, using the InnoDB storage engine. An error occurs if the table exists, if there is no default database, or if the database does not exist. This works regardless of whether there is a default ...