PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. This section discusses the following topics: Creating Accounts and Granting Privileges Checking Account Privileges and ...GRANT and REVOKE assign privileges to and revoke privileges from ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable ...
https://dev.mysql.com/doc/refman/8.0/en/create-database.html
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name | ENCRYPTION [=] {'Y' | 'N'} } CREATE DATABASE creates a database with the given name. To ...For information about character set and collation names, see Chapter 12, Character Sets, Collations, ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/mysql-nutshell.html
This enhancement aligns the syntax of these statements more closely with that of CREATE DATABASE, CREATE TABLE, CREATE USER, and CREATE EVENT (all of which already support IF NOT EXISTS), and acts to complement the IF EXISTS option supported by DROP ...MySQL now incorporates a transactional data dictionary that stores information about database ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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 28.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET ...If ...