mysql
hackcoder
记录技术点滴
展开
-
Mysql图片存取
创建数据库表 photo:CREATE TABLE Photo(ID INT primary key auto_increment,FILE BLOB//存放二进制文件,如图片);把图片插入数据库://前提数据库已拿到连接public class MysqlInsertPhoto {public static void main(String args[原创 2013-08-30 19:31:52 · 914 阅读 · 0 评论 -
can't login as mysql user root from normal user account in ubuntu 16.04
I recently upgrade my Ubuntu 15.04 to 16.04 and this has worked for me:1 - First, connect in sudo mysqlsudo mysql -u root2 - Check your accounts present in your dbSELECT User,Host FROM my转载 2016-12-23 22:57:15 · 678 阅读 · 0 评论 -
MySQL Split String Function
MySQL does not include a function to split a delimited string. However, it’s very easy to create your own function.Create function syntaxA user-defined function is a way to extend MySQL with a new fun转载 2016-01-29 16:03:45 · 1215 阅读 · 0 评论 -
Mac install mysql
首先在mysql官网下载应用http://dev.mysql.com/downloads/ 选择MySQL Community Server下载完后直接普通点击安装,安装完后不着急启动mysql,需要重置下root密码!在终端中 sudo mysqld_safe--skip-grant-tables (以安全模式运行,绕过root密码检验,需上步骤中停止mysql服务)原创 2016-01-17 16:57:49 · 495 阅读 · 0 评论 -
复购率
SELECT m.*, temp_Two.cnt FROM merchant m, (SELECT DISTINCT(order1.merchantId), count(distinct(order1.uid)) cnt FROM `order` order1 WHERE order1.uid IN(SELECT DISTINCT(o.uid) FR原创 2015-10-20 22:59:13 · 4711 阅读 · 0 评论 -
Mysql 查看具体行排名
set @mycnt = 0; select * from ( select (@mycnt := @mycnt + 1) as ROWNUM , othercol from tblname order by othercol ) as A where othercol=OneKeyID;原创 2015-09-18 20:54:05 · 749 阅读 · 0 评论 -
Access denied for user 'bill'@'localhost' (using password: YES)
创建用户分配权限CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass'; grant all privileges on *.* to bill@localhost identified by 'passpass' with grant option;原创 2014-12-26 15:06:02 · 915 阅读 · 0 评论 -
ubuntu下mysql的启动
sudo /etc/init.d/mysql start原创 2013-11-13 10:27:19 · 801 阅读 · 0 评论 -
修改mysql字符编码出现Job failed to start解决办法
从网上找到如下资料:$sudo gedit /etc/mysql/my.cnf[client]下添加:default-character-set=utf8[mysqld]下添加:default-character-set=utf8 然后保存退出$ /etc/init.d/mysql restart原创 2013-11-17 16:50:19 · 1933 阅读 · 0 评论 -
mysql中获取下一个自增长的id值
简单的一句话搞定:其中的 TABLE_SCHEMA='wanku' 代表数据库名称 TABLE_NAME='wankudata' 代表数据表的名称SELECT auto_increment FROM information_schema.`TABLES` WHERE TABLE_SCHEMA='wanku' AND TABLE_NAME='wankudata';原创 2013-10-17 17:31:31 · 2170 阅读 · 0 评论 -
Tomcat Mysql Datasource配置
关于Tomcat中的datasource的配置可以有多种方式下面介绍两种:第一种用将配置文件放置在%TOMCAT_HOME%/conf/Catalina/localhost文件夹下创建配置文件WebDemo.xml内容为: maxActive="100" maxIdle="30" maxWait="10000" username="root" pa原创 2013-10-18 13:42:19 · 1523 阅读 · 0 评论 -
mysql date_format 参数
参数格式描述%a缩写星期名%b缩写月名%c月,数值%D带有英文前缀的月中的天%d月的天,数值(00-31)%e月的天,数值(0-31)%f微秒%H小时 (00-23)原创 2017-02-07 16:12:47 · 668 阅读 · 0 评论