摘要： 1.查询可用数据库，排除系统库select * from sysdatabases where dbid>42.查询可用表，排除系统表select * from sysobjects where xtype='u'3.删除/建立数据库drop/create database students;4.删除/新建表drop table tablename;create table tb (id int,name varchar(20),sex varchar(20))5.插入记录insert into tb (id,name,sex) values ('1',& 阅读全文

摘要： 1.全局环境变量/etc/profile2.特定用户环境变量在用户home目录下的.bash_profile诸如/home/oracle/.bash_profile3.临时环境变量export PATH=/usr/local/webuserver/php/bin:$PATH 阅读全文

摘要： insert into tongxunlu (name,address,email) select sname,saddress,semail from students;select students.sname,students.saddress,students.semail into tongxunlu from students;select students.sname,students.saddress,students.semail,identity(int,1,1) as studentid into tongxunlu from students;update studen 阅读全文

摘要： %java_home%../,,/,,/database%windir%../../ 阅读全文

摘要： mysqld_safe --user=mysql --skip-grant-tables --skip-networking &;myisamchk -c -r /var/lib/mysql/mysql/user.MYI 阅读全文

摘要： 1.sharemount -t cifs -o username=awk,password=nayezi312 //192.168.1.133/Pbw$ /mnt/share2.usblsusbfdisk -lmount -f ntfs-3g /dev/sdb1 /mnt/udisk3.harddiskll /dev/disk/by-pathdf -hfdisk -lfdisk /dev/sdbmake.ext4 /dev/sdbmkdir /datamount /dev/sdb /dataecho "/dev/sdb1 /data ext4 defaults 0 0" & 阅读全文

摘要： select distinct concat('User:''',user,'''@''',host,''';') AS query from mysql.user;grant select,update,insert,delete on *.* to root@192.168.1.133 identified by "root";select host,user.password from user; 阅读全文

摘要： for /f "tokens=1-3 delims=.: " %%1 in ("%time%") do set ttt=%%1%%2%set /a ttt=%ttt%+2for /f "tokens=1-3 delims=- " %%1 in ("%date%") do set ttt=%ttt%%%3%%2%set ttt=%ttt:~1,-1% 阅读全文

摘要： #!/bin/bashDB_NAME="test"DB_USER="username"DB_PASS="password“BIN_DIR="/usr/local/mysql/bin"BCK_DIR="/home/mysql/backup"DATE=`date+%F`$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS $DB_NAME|gzip>$BCK_DIR/db_$DATE.gz 阅读全文

摘要： while read linedoecho "Good!"done<file 阅读全文