ITPub博客

环境: centos5.3(x86_64)+mysql5.5+tomcat6.0+jdk1.5(64bit)下载mysql5.5免安装版本mysql-5.5.0-m2-linux-x86_64-glibc23.tar.gz,找到目录下INSTALL-BINARY文件,打开安装如下:shell> groupadd mysqlshell> useradd -g mysql mysqlshell> cd /usr/localshell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -shell> ln -s full-path-to-mysql-VERSION-OS mysqlshell> cd mysqlshell> chown -R mysql .shell> chgrp -R mysql .shell> scripts/mysql_install_db --user=mysqlshell> chown -R root

create talbe test1 (sendto varchar(50), name1 varchar(50), name2 varchar(50))insert into kafa.test1 (sendto, name1, name2) SELECT sendto, name1, name2 FROM (SELECT DISTINCT sendto as sendto, p.name as name1, r.name as name2 FROM smsreport s left join kafa.region r on s.region_id = r.id left join kafa.region p on s.province_id = p.id ) 不需要创建表test1SELECT sendto, name1, name2 insert into test1 FROM (SELECT DISTINCT sendto as sendto, p.name as name1, r.name as name2 FROM smsreport s left join

使用xmanager连接AIX后，修改oracle用户下.profile文件：设置export DISPLAY=你的IP地址。[@more@]

Linux kernel 2.6.11支持iscsi的版本为iscsitarget-0.4.11.tar.gzLinux kernel 2.6.14 支持iscsi的版本为iscsitarget-0.4.13.tar.gz[@more@]