MySQL Database interview SummarySeptember 04, 2017 00:11:40Hits: 151Combined with the online great God also have their own interview experience, collect the summary of MySQL interview questions, to facilitate their own preparation for the interview;
1. Encrypt authorization with strong password (recommended)8.0 provide the heart of the authorization method, using the SHA256 basis of password encryption methods.But a new version of connector is needed, current and connector/j the latest
Error message: 1.ubantu18.04 Install MySQL no prompt for password2, using terminal installation Mysql-apt-config_0.8.10-1_all.deb still unsuccessful3. ERROR 1698 (28000): Access denied for user ' root ' @ ' localhost4. ERROR 1146 (42S02): Table '
1. Export all databasesUse Mysqldump's-all-databases parameter to export all the databases under your database root to a SQL file in one breath. Then, after reloading the system, use the source command to rewind back in a breath.You need to
Libraries.zip Address: Link: Https://pan.baidu.com/s/1kIZ2aBCOFSJ9l727MxgIKQ Password: 40VQ* Note that because LR has many library files, you need to download the public library from outside and put it in the appropriate location. * Recommended
Not much to say, directly on the dry goods!The direct yum install MySQL will error, because there is no directly available installation package in the Yum installation library, this time needs to use the MariaDB , MariaDB is the MySQL
First, meaningAlso multiprocessing table query, when the query field from more than one table, you will use the connection query.II. Classification 2.1, chronological classification:SQL92 Standard: Supports only internal connectionsSQL99 standard
as the name implies, the slow query log is a long execution of query, that is, we often say slowquery, by setting--log-slow-queries[=file_name] to open the function and set the record location and file name. The slow query log is a simple text
System Centeros7:1. Configure the Yum sourceDownload the Yum source RPM installation package on the MySQL website: http://dev.mysql.com/downloads/repo/yum/# 下载mysql源安装包shell> wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm#
MySQL Multi-instance _ Qin EncyclopediaNote: Before deploying a dual instance, you first need to deploy a single instance, and the single instance deployment details are as follows:Https://www.cnblogs.com/wangqiner/p/9081002.html1, if you have
MySQL field typeMySQL supports multiple types and can be broadly divided into three categories: numeric, date/time, and string (character) types.Numeric type
type
size
Range (signed)
Range (unsigned)
Use
1. The Environment for libraries and tables is as follows, and the character set is latin1:Mysql> Show CREATE Database yuanqk;+----------+---------------------------------------------------------------- ---+| Database | Create Database |+----------+-
1. Recently encountered in the writing e-commerce project to add data garbled problem to the databaseThe first thought was that the database problem but a look atNo problem.So I looked at the project's default code, and no problem.So here's the
Installation tutorial for MySQLReference from rookie tutorial http://www.runoob.com/mysql/mysql-tutorial.htmlProblem: No response to directory switching in cmdOn the cmd command line, use CD D:\ to not switch smoothlySolution: Use cd/d d:\It should
--01 MySQL database operation --Link DatabaseMysql-uroot-pmysql--Don't show password * * * *Mysql-uroot-p--Exit the databaseQuit/exit Ctrl+d--The SQL statement needs a semicolon at the end;--Show database version versionsSelect version ();--Show
Deal with inventory oversold situation, first understand what is optimistic lock and pessimistic lock, the following several blog has been introduced more detailed, I will not repeat its principle"MySQL" pessimistic Lock & optimistic
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service