daily cryptoquote

space.NOTE: varchar will add one to two extra bytes to store the true length of the data, so the storage: ABCD, the space will occupy: 4+1, where the 1 is used to store the true length of the data.If the length of the data is longer than 255 characters, then the space that stores the true length becomes 2.A varchar type can store 65,535 characters.How should char and varchar be chosen?Char Type: Faster calculationVARCHAR type: more space-saving.Decide for yourself according to your needs.1.3.3

of the MySQL databaseExport1. Export the database as a SQL fileMysqldump database name-uroot-p > XXX.SQL Export data table structure and dataeg. Mysqldump cloudres-uroot-p > Cloudres.sql2. Export to GZ compressed fileMysqldump Database name-uroot-p | gzip > xxx.sql.gz3. Importing SQL filesFirst build a database with the same name in the database, and then execute the following command to importMysql-uroot-p Database name 4. If the exported. sql file is on the server, you need to download the. sq

1. Test the monomer application before this side of the application and the database into a virtual machine, so that you can directly use the snapshot rollback, the application and the database is a complete state for easy testing.2. But there are many virtual machines in the LAN clone, most of the virtual machine password is also consistent, in order to increase the flexibility, so this piece has a problem sometimes the IP address changes or other circumstances may have a situation of confusion

first)Show index from Your_table_name#SET foreign_key_checks = 0;#查看开关状态Show variables like ' sql_safe_updates ';#修改下数据库模式SET sql_safe_updates = 0;#导入本地csv文件 (excerpt: 71436108)LOAD DATA LOCAL INFILE ' e:\\db\\data.csv 'into table Your_db_name.your_table_nameFields terminated by ', ' optionally-enclosed by ' "' escaped by '" 'Lines terminated by ' \ r \ n ';#导入本地csv文件 (excerpt: https://www.cnblogs.com/ahudyan-forever/p/5817847.html)LOAD DATA LOCAL INFILE ' e:\\db\\data.csv 'Into TABLE ' your_db

/oracLe_backup "oracle_u01=" u01 "oracle_u02=" u02 "oracle_password1=" U01_password "oracle_password2=" U02_password "EXPDP ${oracle_u01}/${oracle_password1}directory=dpdata1dumpfile=${oracle_u01}_${datetime} Logfile=${oracle_u01}_${datetime}.logif[$?-ne0];thenecho "$ (date+"%y-%m-%d_%h:%m:%s ") oracle_${oracle_u01}_backup_file!" >${dpdata1_dir}/${datetime}_err.logfiexpdp${oracle_u02}/${oracle_password2} directory=dpdata1dumpfile=${oracle_u02}_${datetime}logfile=${oracle_u02}_${datetime}.logif[

design and development, some of which are overlooked in business details. Please forgive me for your mistakes, thank you for your criticism. The first thing to do is to determine the type of system, and the survey system is a OLTP System. second, assess the amount of data that will be -Users , active users will have $million. -million users of course not small,1byte bits are20Mdata, if a member record information is0.5K, the size of the membership table is10G. From the above two assessment and

1. query table name or column name in Chinese comments (SQL Server 2008)Select T.object_id from sys.tables tjoins on T. object_id=and='ms_description' and p.minor_id=0;1.1 Query Table name Chinese commentsSelectT1.*, T2.name ascolumn_name from (SelectT.object_id, P.major_id,p.minor_id,t.name asTables_name, P.value,t.type,t.type_desc fromsys.tables TJoinsys.extended_properties P onT.object_id =p.major_id andP.name= 'ms_description') T1 Left Joinsyscolumns T2 onT1.object_id=t2.id andt1.minor_id=

Tags: mysql backupI believe that many of the small partners will use the MySQL database, the following provides a script to share with gentlemen.#!/bin/bashscript_dir=$ (dirname)Backup_dir= "/data1/mysqlbackup"backup_days=480RM-RF ${backup_dir}/*db_ip= '/sbin/ifconfig-a|grep inet|grep-v 127.0.0.1|grep-v Inet6|awk ' {print $} ' |tr-d ' addr: ' |head-1 'Backup_type= ' Xtra_full 'For i in ' Ps-ef |grep port= |grep-v grep|cut-d "="-F 10 'Dodb_port= $iNew_dir= "/data1/mysqlbackup/${db_port}"If [-E "$

Label:This article has been redirected from an excessive number of Oracle Dblink connections (Ora-02020)Today, when dealing with data synchronization issues, it is necessary to synchronize data from several other DB servers to a single target repository, in the following way: Dblink+job, however, Ora-02020 errors occur during the write process compilation. As follows: Environment: Target server (alias: DB) Other servers that need to be synchronized (DB1, DB2, DB3, DB4, DB5) Practice: Establish

"Move must first remove database MDB01, this will be all our users will not be able to access the database" Asked if we continue, we click Yes:650) this.width=650; "height=" 484 "title=" clip_image034 "style=" border:0px;padding-top:0px;padding-right:0px; Padding-left:0px;background-image:none, "alt=" clip_image034 "src=" http://s3.51cto.com/wyfs02/M00/6D/27/ Wkiol1vdndsqpexcaaf6z3ouf2q914.jpg "border=" 0 "/>The database moves successfully, we click Finish:650) this.width=650; "height=" 286 "ti

/log.tar.xz/var/log/[Email protected] ~]# du-sh/tmp/day03/*B. Unzip the. Tar PackageBasic usageFormat: TAR-XPF backup file. tar.gzFormat: tar-xf backup file. tar.bz2Format: tar-xf backup file. tar.xz [-C destination Folder]eg[Email protected] ~]# cd/tmp/day03/[[email protected] day03]# ls[Email protected] day03]# TAR-XF log.tar.gz[[email protected] day03]# ls[Email protected] day03]# RM-RF var[[email protected] day03]# ls[Email protected] day03]# TAR-XF log.tar.bz2[[email protected] day03]# ls[E

/article/details/52117463TCP three handshake and four breakupHttps://www.cnblogs.com/leezhxing/p/4524176.htmlIv. Grasping the bagyum install -y tcpdump抓包工具tcpdump 用法：tcpdump -nn tcpdump -nn -i ens33 tcpdump -nn port 80 //指定端口80 tcpdump -nn not port 22 and host 192.168.0.100 //指定host和端口不是22tcpdump -nn -i ens33 -c 10 -w /tmp/1.cap // 抓10个包放入1.cap中，可以用file命令查看信息tcpdump -r /tmp/1.cap //读取抓到的包信息 tshark -n -t a -R http.request -T fields -e "frame.time" -e "ip.src" -e "http.host" -e "http.r

The uptime is used to view the load information for the system.It displays information such as the current system time, the system elapsed time, the number of enabled endpoints, and the average load value, in turn. Average load refers to the system in the last 1 minutes, 5 minutes, 15 minutes of the pressure situation, the lower the load value of the better, try not to more than 1 long-term, in the production environment not more than 5. who is used to view the user terminal information of the c

; otherwise, no action is takenREBUILDDB: RebuildingRecreate the database directly, whether it is present or not25. Compile C source code:First Step: Configure script--helpOption Categories:Installation path settings:--prefix=/path/to/somewhere: Specify the default installation location--sysconfdir=/path/to/somewhere: Configuration File Installation LocationStep Two: MakeStep Three: Make installPost-installation configuration:(1) Export the binary program directory to the PATH environment variab

Useradd command for creating user accountsUseradd can be used to create user accounts. After the account is built, then use passwd to set the password of the account. You can delete an account by using Userdel. The account number created by using the USERADD directive is actually saved in the/etc/passwd text file.Parameter description:-c-d-e: Specify the account validity period-F: Specify how many days after the password expires to close the account-G: Specifies the group to which the user belon

/aa.shTime=date +%Y%m%dTar czvf $time-opt/opt/MV $time-opt/data/backup/5. Use a command to count the number of visits per IP address in Apache access log access.log, and list the top 10 by traffic.Examples of the log grid styles are as follows:192.168.1.10--[24/jul/2017:23:55:55 +0800] "get/http/1.1" 200 19More Access_log | awk ' {print '} ' | uniq-c | Sort-rn | Head-106, print out the test.conf file does not start with "#", and is not a blank line of content.Sed-e "/^#/d" test.conf | awk ' {if

First, the Web front-end and Ajax part of the file index.htmlif (data==1) { alert ("Sign success!"); window.location.href= '/'; }else if (data==2) { alert ("Already sign today! Next tomorrow! "); } ); 　 sign.php file Check is continuous? 　　　　　　Reset with login set Signdays as 0!!!!! $yesterdayBegin = Strtotime (Date ("Y-m-d", Strtotime ("1 day")). " 　　　　　　00:00:00 "); $yesterdayEnd = Strtotime (Date ("Y-m-d", Strtotime ("1 day")). " 　　　　　　23:59:59 "); $CHECKCONTINUSQL = "SELECT * from

Tags: Scan set echo copy install read amp out shellFunction: Quickly and automatically generate keys and bulk push to remote host, suitable for batch push key for ansible environment#!/bin/bashkeypath=/root/.sshiplist=/root/ip.txt[[ -e ${iplist} ]] > ${iplist}for i in `seq 81 91`do echo -E "192.168.118.$i" >> ${iplist} ssh-keyscan 192.168.118.$i >> ${keypath}/known_hostsdonecat ${iplist}[ -d {keypath} ] || mkdir -p ${keypath}rpm -q expect > /dev/null || yum install expect -y[[ -e ${keypath}

command please install Bind-utilsprintf "%-5s|%-10s|%-10s|%-13s|%-33s|%s" $ucount "$user" "$ATTEMPTS" "$IP" "$HOST" "$TIME _range"FiDoneDoneRm-f/tmp/valid.$$.logRm-f/tmp/$$.logRm-f/tmp/$$.timeRm-f/tmp/temp.$$.log-------------------------------------------------------This is the solution to solve the 3 login failures of illegal users.Vim/etc/pam.d/sshdAuth Required pam_tally2.so deny=3 unlock_time=300 even_deny_root root_unlock_time=10#参数解释#even_deny_root also restrict root users;#deny set the m

Linux Installation System SelectionCentos7Program Volume 7 g, if it is the beginning of learning,Be careful not to choose that small size, because I have to go in and find this wifie also have to carry out some strong command to connect successfully. It's a lot of trouble.The installation is quite smooth but this installation time is very long. Note the point is the boot partition, if you do not toss 200M purchased, but if you want to download kernel upgrade and so on that is divided into 500M,