![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MYSQL
jialechan
这个作者很懒,什么都没留下…
展开
-
MySQL BETWEEN 顺序问题
<br />一句话就是:Mysql认为between 1 and 10和between 10 and 1不是一回事,后者是找不到“1到10之间”的数据的,和平时我想像中有点出入。原创 2011-05-12 21:10:00 · 510 阅读 · 0 评论 -
建立数据库时指定编码
CREATE DATABASE `test` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci原创 2011-06-10 18:59:00 · 134 阅读 · 0 评论 -
Ubuntu下自动备份MySQL
#!/bin/bash#This mysql backup script for dsm db by daily#environment: ubuntu 10.4#2011-6-12#def the name of dbdbname=dsm#def the username and passworddbuser=dsmdbpasswd=dsm#def the p原创 2011-06-12 13:02:00 · 296 阅读 · 0 评论 -
制定字符集的mysql url链接
jdbc:mysql://localhost:3306/af1234?useUnicode=true&characterEncoding=utf-8 xml里面的写法jdbc:mysql://localhost:3306/af1234?useUnicode=true&characterEncoding=utf-8原创 2011-06-28 18:59:00 · 246 阅读 · 0 评论