-------【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 · 713 阅读 · 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 · 1067 阅读 · 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 · 298 阅读 · 0 评论