![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySql
evayukimp5
这个作者很懒,什么都没留下…
展开
-
阿里云部署的时候常用的Linux步骤
1、安装JDK rpm -ivh jdk-6u32-linux-i586-rpm 解压 tar -zxvf apache-tomcat-6.0.10.tar.gz; 2、安装mysql 检测是否安装 #rpm -qa|grep mysql # yum repolist all | grep mysql yum安装 yum install mysql 常见错误 ERR原创 2017-03-06 13:12:38 · 270 阅读 · 0 评论 -
使用mysq的information_schema导出字典
#mysql SELECT TABLE_NAME as 表名, COLUMN_NAME as 列名, IS_NULLABLE as 是否可空, DATA_TYPE as 数据类型, COLUMN_TYPE as 字段长度, COLUMN_KEYas 是否主键 , COLUMN_COMMENT as 注释 FROM information_schema.COLUMNS WHERE TABLE_...转载 2017-11-07 15:27:52 · 326 阅读 · 0 评论 -
常用Sql(一点都不常用)
Mysql 使用replace函数update table t set t.fied = replace(t.field,oldStr,newStr) where condtiion;多表更新update table a,table b set a.field = b.filed where conditionmysql调用md5UPDATE 表 SET 字段 = md5(right('15231...原创 2017-03-06 13:10:17 · 252 阅读 · 0 评论