1.vim /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=
Tag: mysql
Why is MySQL assessment (TRUE or TRUE and FALSE) TRUE?
If you enter
SELECT (true or true and false) In mysql, It will return 1, which is true. Why is this happening? What is the order of evaluation in Boolean expressions?
If you enter
Spoon (Kettle) Basic Configuration (Connect MySQL and Oracle)
1. Download the spoon package and driver
The spoon package I use, including spoon7.1, Mysql driver and Oracle driver
link: https:// pan.baidu.com/s/16Q-iUNB7qGU0xlKbGTw-vg Extraction code: q9h5
If you have installed an Oracle database or oracle client locally, you can use its own Oracle driver,
Remember to deal with the experience of the mysql database
One day, the user table in the production environment suddenly locked the table for no reason. I thought it was just an occasional bug. So the first solution that came to my mind was simple and rud
Use node to do the background write interface for Express + MySQL + Node
1. Introduce the corresponding module
const express = require(‘express’)
// Create server express module, express framework coexists with native API , So you can use any native method attrib
Mysql master
1. Installmysql
(1) Unzipmysqlpackage and createmysqlUsers and creationmysqldata directory span>
tar zxvf mysql-5.6.43-linux -glibc2.12-x86_64.tar.gz
mv mysql-5.6.43-linux-glibc2
Mysql – Counting – Optimization of Each Connection
Results:
I have used three methods:
>Three sub-queries, each adding 1 (my)
>Three subqueries, no connection, use where to filter (SlimsGhost)
>Three connections (Solarflare)
I have us
MySQL – How to SUM Time?
I have a table with date and time values in this format:
Start
1/13/2009 7:00:00 AM
End
1/13/2008 2:57:00 PM
I use the’str to date’ function to convert them Date and
Is it possible to have a whole result set in MySQL?
Is it possible to apply a hash function to the entire result set in mysql.
I know how to hash values in each row of the result set< /p> For example, SELECT md5(‘something’)
But say I
Mysql8.0 version installation tutorial
In the past few days, I have been crazy about the configuration of various environments. I have inquired a lot of information. It is a bit of experience. ForMysql installation and solutions to poss