![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
-------【MySQL】
KimZing
Programming as a Way of Thinking
展开
-
MySQL控制流程语句-CASEWHEN,IF,IFNULL,NULLIF--简易版
表结构create table teacher( id int primary key auto_increment, name varchar(10) not null, gender char(1) not null, age int(2) not null, job varchar(10), createDate date);数据准备:insert into teacher values(原创 2017-03-29 15:19:08 · 708 阅读 · 0 评论 -
MySQL行转列操作
一、准备建表语句CREATE TABLE StudentScores( userName NVARCHAR(20), subject NVARCHAR(30), score FLOAT)数据插入INSERT INTO StudentScores values('Nick', '语文', 80);INSERT INTO原创 2017-11-12 16:49:09 · 1064 阅读 · 0 评论 -
CentOS7使用yum安装MySQL
1.下载mysql的repo源$ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm2.安装mysql-community-release-el7-5.noarch.rpm包$ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm安装这个包后,会获得两个mysq转载 2017-12-10 23:31:47 · 297 阅读 · 0 评论