mysql
iteye_14794
这个作者很懒,什么都没留下…
展开
-
解决MySQL不允许从远程访问的方法
http://blog.chinaunix.net/uid-23215128-id-2951624.html http://www.jb51.net/article/24508.htm #mysql -hip -uroot -p123456 grant all PRIVILEGES on discuz.* to ted@'123.123.123.123' identified by '1...原创 2015-06-17 16:40:36 · 80 阅读 · 0 评论 -
mysql on DUPLICATE KEY UPDATE test1.name=test2.name;
mysql> create table test1(id int,name varchar(5),type int,primary key(id)); Query OK, 0 rows affected (0.01 sec) mys mysql> create table test2(id int,name varchar(5),type int,primary key(id...原创 2014-12-10 15:59:57 · 118 阅读 · 0 评论 -
mysql授权 远程访问授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY WITH GRANT OPTION FLUSH PRIVILEGES mysql授权 远程访问授权 mysql> grant all privileges on lfchat.* to dbname@localhost identified by 'pas...原创 2015-01-22 10:01:06 · 150 阅读 · 0 评论 -
mysql 字段不区分大小写问题
ALTER TABLE `zanbao`.`zb_dev_cus_audio` MODIFY COLUMN `MUSICID` VARCHAR(15) BINARY; 语法有误 alter table zanbao.zb_dev_cus_audio change musicid name varchar(12) binary 正确原创 2015-01-29 15:44:30 · 114 阅读 · 0 评论 -
mysql sql
select concat('OD',date_format(now(),'%Y%m%d'),LPAD(NEXTVAL(date_format(now(),'%Y%m%d')),4,'0')); select length('OD201504040000'); select LOCATE('e','eqwe,rqwe'); select left('eqwe,rqwe',2)...原创 2015-04-04 17:04:51 · 71 阅读 · 0 评论 -
mysql定时器 初始化订单日期
-- 查看是否开启定时器 SHOW VARIABLES LIKE '%sche%'; -- 开启定时器 0:off 1:on SET GLOBAL event_scheduler = 1; -- 创建事件 -- 每隔一秒自动调用e_test()存储过程 CREATE EVENT IF NOT EXISTS event_test ON SCHEDULE EVERY 5 ...原创 2015-04-08 17:15:53 · 99 阅读 · 0 评论 -
mysql 更新状态 注意放到最后
UPDATE zanbao.t_order SET step = CASE stat WHEN '2' THEN '1' WHEN '4' THEN '2' END, sh_person = CASE stat WHEN '4' THEN '100006' ELSE sh_person ...原创 2015-04-09 22:34:10 · 195 阅读 · 0 评论 -
压缩备份Mysql数据库
[1].[代码] 压缩备份Mysql数据库 跳至 [1] #!/bin/bash shijie=`date +%Y%m%d` backRenRenDb=renren_minishijie$shijie.sql back4399Db=4399_minishijie$shijie.sql backManyouDb=Manyou$shijie.sql backRenRenFile=ren...原创 2015-04-10 14:51:56 · 115 阅读 · 0 评论 -
mysql 类型
CREATE TABLE db_set ( set1 SET('x', 'y', 'z') NOT NULL, enum1 ENUM('one', 'two', 'three') NOT NULL ); truncate table db_set; insert into db_set values(1,1); -- 'x', 'one' insert into db...原创 2015-04-23 16:13:17 · 81 阅读 · 0 评论 -
mysql集群配置
http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-installation.html原创 2014-09-16 19:57:24 · 76 阅读 · 0 评论 -
Nginx+Memcached+Tomcat集群配置
https://github.com/magro/memcached-session-manager http://code.google.com/p/memcached-session-manager/wiki/SetupAndConfigurationhttp://wenku.baidu.com/link?url=h-alwoByq5fqUpIVEO1v0CQ61CvF0nCxQG...原创 2014-08-14 12:21:11 · 84 阅读 · 0 评论 -
统计排名
CREATE DEFINER=`root`@`192.168.1.%` PROCEDURE `paimin`() BEGIN DECLARE zan1 INT DEFAULT 1; DECLARE cai1 INT DEFAULT 1; DECLARE ping1 INT DEFAULT 1; DECLARE fen1 INT DEFAULT 1; ...原创 2016-06-29 18:35:36 · 349 阅读 · 0 评论 -
mysql 配置字符集 5。5
show variables like "%char%"; service mysql restart; vim /etc/mysql/my.cnf [mysqld] 已有 在下面添加一行 character-set-server=utf8原创 2015-06-17 22:20:45 · 66 阅读 · 0 评论 -
计算两点距离
CREATE DEFINER=`root`@`%` FUNCTION `tow_point_distance_function`(lat1 INTEGER,lng1 INTEGER,lat2 INTEGER,lng2 INTEGER ) RETURNS int(11) BEGIN RETURN round(2 *6378.137 * asin(sqrt(power(sin((radian...原创 2015-06-19 10:59:34 · 136 阅读 · 0 评论 -
mysql集群
http://www.linuxde.net/2013/06/14431.html mysql集群原创 2015-07-02 15:57:07 · 84 阅读 · 0 评论 -
MySQL远程访问设置终极方法
MySQL远程访问设置终极方法 http://www.jb51.net/article/58096.htm原创 2015-07-11 09:51:55 · 119 阅读 · 0 评论 -
mysql2postgresql
PostgreSQL数据的导出导入 导出PostgreSQL数据库中的数据: $ pg_dump -U postgres -f mydatabase.sql mydatabase 导入数据时首先创建数据库再用psql导入: $ createdb newdatabase $ psql -d newdatabase -U postgres -f mydatabase.sql ...原创 2015-07-14 16:01:39 · 792 阅读 · 0 评论 -
POSTGRESQL
CREATE OR REPLACE FUNCTION "public"."tradegift3(src_id int4, dst_id int4, gift_id int4, gift_count i"(IN src_id int4, IN dst_id int4, IN gift_id int4, IN gift_count int4, IN gift_type int4, IN total_...原创 2016-06-06 20:54:19 · 106 阅读 · 0 评论 -
mysql 游标 排名
CREATE DEFINER=`root`@`192.168.1.%` PROCEDURE `paimin`() BEGIN DECLARE zan1 INT DEFAULT 1; DECLARE cai1 INT DEFAULT 1; DECLARE ping1 INT DEFAULT 1; DECLARE fen1 INT DEFAULT 1; ...原创 2016-06-25 18:54:58 · 142 阅读 · 0 评论 -
让mysql快速兼容postgresql
CREATE DEFINER=`root`@`192.168.1.%` FUNCTION `to_char`(`date` datetime,`format` VARCHAR(20)) RETURNS date BEGIN #Routine body goes here... RETURN date_format(date, '%Y-%m-%d'); END原创 2016-06-29 16:43:06 · 565 阅读 · 0 评论 -
mysql多个TimeStamp设置
http://www.cnblogs.com/yjf512/archive/2012/11/02/27510 mysql多个TimeStamp设置 58.html原创 2015-05-16 15:46:24 · 238 阅读 · 0 评论