#!/bin/bash#data:20171104#qq:654996537#name:zhang# determine if root user if [ $ (id -u) != "0" ]; then echo " Not the root user! Try using sudo command ! " exit 1fi# Install dependency package yum -y groupinstall
MySQL does not have the Split function, here manually write one:CREATE PROCEDURESp_split (inchC1varchar( -),inchSplit1varchar( -))BEGINCREATE Temporary TABLE IF not EXISTSTemp_split (Colvarchar( -));DELETE fromTemp_split; while(InStr (C1,SPLIT1)<>
L Download the zip package:
Official website: https://dev.mysql.com/downloads/mysql/5.1.html#downloads
The first step: Unzip the downloaded package to the directory you want to install
Step two: Go to the bin directory and copy the
First, the database operation1. View the databaseShow databases2. Create a databaseCreate Database Kameng;3. Enter the databaseUse Kameng;4. Deleting a databaseDrop database Kameng;Second, table operation:1. View the tableShow tables;2. Create a
To do the project today, there is a requirement to get data for the date seven days ago. Then on Baidu MySQL in the function of time. Collected a few. It is now recorded as follows:Reference Address: http://www.w3school.com.cn/sql/sql_dates.asp--Get
#链接数据库Mysql-h 192.168.101.148-u Root-p#允许远程链接Mysql> GRANT All privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT OPTION;After the operation, remember to perform the following command refresh permissionsFLUSH
advanced operations for data in MySQL (five clauses)data manipulation: Adding and deleting changesNew DataSyntax:insert into Table name [(field list)] VALUES (list of values);PRIMARY KEY violationwhen a primary key is in conflict (Duplicate key), it
Stored procedures in the YsqlStored Procedures
Stored procedure procedure is a way of handling data. is a function that has no return value.
Create a stored procedure
------------------------------------------------------------
Method 1:1. Stop the MySQL service# Kill ' Cat/var/run/mysqld/mysqld.pid 'Or# Pkill Mysqld2. Create a text file for a password assignment statement# VI Mysql-initALTER USER ' root ' @ ' localhost ' identifiedby ' mynewpass!6 ';Resets the password
node is asynchronous, so the database query operation is usually done through callbacks to manipulate the results of the query. But in the es7 of async/await, basically no longer need callback, so this article is based on async/await to the MySQL
First, InnoDB:deal with a large number of short-term transactions;data is stored in "table space";1, the data and index of all InnoDB tables are placed in the same table space;tablespace file: Under directory defined by DataDirdata file:
1. For complex queries such as multi-join queries such as reports, use caching as much as possible, and when using caching, be aware that now (), Randy (), Currdate (), and so on, are unable to use the cache, for example: SELECT username from user
foreign keys in MySQLFOREIGN KeyFOREIGN key: foreign key, outside the key (the key is not in its own table), if one table has a field (non-primary key) to the other table's primary key, then the field is called a foreign key.A table can have more
FTP is a file transfer protocol, to implement this protocol, you need to install a number of appropriate services and tools. In the client needs to install the connection tool, our common Client Connection tool has Ftp,lftp,wget,curl, etc., on the
1.MySQL Getting Started with master-slave replicationFirst, let's look at a diagram:
Operations that affect the MYSQL-A database are written to the local log system A after the database is executed.Suppose that the real-time database
Even if you think you've had a deep understanding of MySQL's left JOIN, I bet this article might probably get you to learn something!
The ON clause differs from the WHERE clause
A better understanding with WHERE ... A simple method for
I. Connecting the databaseThere are two ways to connect, one is to use command-line arguments, and the other is to write parameter information to a configuration file1. Using parameters in the command line-u user name-p password-d database name-p
Queries About JOIN Databases
JOIN: If the table has at least one match, the row is returned.
Left join: returns all rows from the LEFT table even if no match exists in the right table.
Right join: returns all rows from the RIGHT table even
Mysql must know meeting Reading Notes-security management and database maintenance,Security Management
You can view all user information in the user table of the mysql database.Create a user account
CREATE USER ben IDENTIFIED BY 'p@$$wOrd'
Rename a
Mysql installation configuration, mysql
L download the compressed package:
Official Website: https://dev.mysql.com/downloads/mysql/5.1.html#downloads
Step 1: Decompress the downloaded package to the directory you want to install
Step 2: Go
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