哈哈__哈哈的专栏

把两个xml文件放入src中applicationContext.xml<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:jee="http://www.springframework.or

select * from user_memberwhere uid in (select uid from user_member group by uid having count(uid) &gt; 1) 

-- 还是分库备份，但是：要是我要在五六十个数据库中排除指定数据库不备份呢？-- 你这个for 循环是不是还得加逻辑判断去控制，-- 而我先用SQL语句去得到当前的所有数据库的名字，同时构建备份语句，-- 那么我是不是可以更灵活的在SQL语句中去排除指定的数据库不备份呢？-- 我想：这也是我的方法较你的方法的更为灵活之处！---- Windows下My SQL自动按库备...

Packet for query is too large(mysql写入数据过大)  修改此变量的值：MySQL安装目录下的my.ini文件中的[mysqld]段中的＂max_allowed_packet = 1M＂，(可能有些文件会没有这一行的)格式为：[mysqld]max_allowed_packet = 1M （ 将1M更改为4...

有的时候要分析别人的数据库但看表不能很好的体现业务逻辑所以可以用PowerDesigner的反向工程来解决 这里用mysql 来举例子，因为pd中没有mysql的odbc，得用Connection Profiles来解决。 新建一个工作空间-&gt;数据库-&gt;Configure Connections-&gt;Connection Profiles-&gt;Add D...

UNIX_TIMESTAMP(), UNIX_TIMESTAMP(date)若无参数调用，则返回一个Unix timestamp ('1970-01-01 00:00:00' GMT 之后的秒数) 作为无符号整数。若用date 来调用UNIX_TIMESTAMP()，它会将参数值以'1970-01-01 00:00:00' GMT后的秒数的形式返回。date 可以是一个DATE 字符串、一个 ...

在mysql的文件夹下的my.ini添加[code="java"]max_allowed_packet=200M[/code]这样就可以了

Dump ALL MySQL Databases:[code="java"]mysqldump --user=XXXXXXXX --password=XXXXXXX -A > /PATH/TO/DUMPFILE.SQL[/code]Dump Individual or Multiple MySQL Databases:[code="java"]mysqldump --user=XX...

导出：[code="java"]select sfid,sftags from hf_subfitment where flag = 1 into outfile 'c:/a1.txt'[/code]导入：[code="java"]LOAD DATA INFILE 'c:/a1.txt' INTO TABLE hf_subfit_tags(sfid,tagname);...

select * from vitae awhere (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) &gt; 1)

转的MySQL 的CAST()和CONVERT()函数可用来获取一个类型的值，并产生另一个类型的值。两者具体的语法如下： CAST(value as type);CONVERT(value, type); 就是CAST(xxx AS 类型), CONVERT(xxx,类型)。mysql&gt; SELECT CAST('3.35' AS signed);+------...

mysql中如果表的字段设成了关键字，那么在做某些操作时会抛1604 42000错误。在关键字的get上添加下面的注解即可，给关键字打上引号@Column(name="`interval`")   ...

转的：先删除linux 可能存在的mysql#rpm -qa|grep mysql 1、导入第三方源webtaticrpm -Uvh http://repo.webtatic.com/yum/centos/5/latest.rpm2、如果已安装低版本的mysql就删除yum remove mysql mysql-* 3、安装libmysqlclient15y...

刚写的，做个记录： -- ---------------------------------------------------------------------------------- Routine DDL-- Note: comments before and after the routine body will not be stored by the serve...

update controller c inner join controller_copy cc on c.cCode = cc.cCode set c.latitude=cc.latitude, c.longitude=cc.longitudeWHERE c.groupId = 41 

在这样的SQL文中:INSERT INTO table_name (column1, column2, column3,...)VALUES (value1, value2, value3,...), (value1, value2, value3,...),...  执行时，mysql会出现错误，此时在mysql的my.ini最后一行中添加max_allowed_pac...

beginDECLARE h_aid int;DECLARE h_num int;DECLARE b INT(1);DECLARE rows CURSOR FOR select aid, sum(viewnum) as h_num from ikea_hfarticle_s group by aid;DECLARE CONTINUE HANDLER FOR NOT FOUN...

mysql v 5.0.22 CREATE PROCEDURE `p1`(in param integer)begin declare var1 varchar(20); if param = 1 then set @var1 = 'qq520'; else set @var1 = 'wunder'; end if; set...

在mysql的文件夹下的my.ini添加max_allowed_packet=200M这样就可以了

Dump ALL MySQL Databases:mysqldump --user=XXXXXXXX --password=XXXXXXX -A > /PATH/TO/DUMPFILE.SQLDump Individual or Multiple MySQL Databases:mysqldump --user=XXXXXXXX --password=XXXXXXX --databases

导出：select sfid,sftags from hf_subfitment where flag = 1 into outfile 'c:/a1.txt'导入：LOAD DATA INFILE 'c:/a1.txt' INTO TABLE hf_subfit_tags(sfid,tagname);

select * from vitae awhere (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)

PHP是解压缩版，不是安装版 1、在PHP安装目录下，找到文件php5ts.dll，将其复制到C盘system32目录下。2、在PHP安装目录下，找到文件libmysql.dll，将其复制到C盘system32目录下。3、在PHP安装目录下，找到文件php.ini，将其复制到C:\windows下。   这个文件是配置PHP的基本文件，如设置服务器根目录配置，用文本编辑器打开p

mysql v 5.0.22 CREATE PROCEDURE `p1`(in param integer)begin declare var1 varchar(20); if param = 1 then set @var1 = 'qq520'; else set @var1 = 'wunder'; end if; set

在这样的SQL文中:INSERT INTO table_name (column1, column2, column3,...)VALUES (value1, value2, value3,...), (value1, value2, value3,...),...  执行时，mysql会出现错误，此时在mysql的my.ini最后一行中添加max_allowed_pack

select * from user_memberwhere uid in (select uid from user_member group by uid having count(uid) > 1)

yum -y install httpd php mysql mysql-server php-mysql httpd-manual mod_ssl mod_perl mod_auth_mysql php-mcrypt php-gd php-xml php-mbstring php-ldap php-pear php-xmlrpc mysql-connector-odbc mysql-devel

UNIX_TIMESTAMP(), UNIX_TIMESTAMP(date)若无参数调用，则返回一个Unix timestamp ('1970-01-01 00:00:00' GMT 之后的秒数) 作为无符号整数。若用date 来调用UNIX_TIMESTAMP()，它会将参数值以'1970-01-01 00:00:00' GMT后的秒数的形式返回。date 可以是一个DATE 字符串、一个

先把nas开启NFS服务再把NAS的共享盘挂载到Linux里，sudo mkdir mybackupsudo mount -o username=***,password=*** //192.168.0.***/database /mnt/mybackupshell注意权限#!/bin/bash# Database infoDB_USER="root"D

转的：http://www.cnblogs.com/batsing/p/4938986.html

刚写的，做个记录： -- ---------------------------------------------------------------------------------- Routine DDL-- Note: comments before and after the routine body will not be stored by the server

SELECT CASE 3 WHEN 1  THEN one WHEN 2  THEN twoELSE  more END

 ALTER TABLE controller MODIFY COLUMN phoneNo VARCHAR(200)