Search Results
https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser doesn't seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/8.4/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-file-context.html
The MySQL Server reads from and writes to many files. If the SELinux context is not set correctly for these files, access to the files could be denied. The instructions that follow use the semanage binary to manage file context; on RHEL, it's part ...
https://dev.mysql.com/doc/refman/8.4/en/serialized-dictionary-information.html
In addition to storing metadata about database objects in the data dictionary, MySQL stores it in serialized form. Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. Serialized ...
https://dev.mysql.com/doc/refman/8.4/en/server-administration.html
MySQL Server (mysqld) is the main program that does most of the work in a MySQL installation.
https://dev.mysql.com/doc/refman/8.4/en/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variable-reference.html
The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...
https://dev.mysql.com/doc/refman/8.4/en/set-role.html
SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... } SET ROLE modifies the current user's effective privileges within the current session by specifying which of its granted roles are active. Granted roles include those granted ...
https://dev.mysql.com/doc/refman/8.4/en/set-sql-log-bin.html
SET sql_log_bin = {OFF|ON} The sql_log_bin variable controls whether logging to the binary log is enabled for the current session (assuming that the binary log itself is enabled). To disable or enable binary logging for the current session, set the ...