Others

As shown below: Add the following code to [Mysqld] in the #在/etc/my.cnf: slow-query-log=on Slow_query_log_file=/data/mysql/log/mysql_slow_ Query.log long_query_time=2 log_queries_not_using_indexes = On The first sentence is to open the slow

One-click to close dangerous port (prevent hacker intrusion)Dangerous, port, hackerCopy all of the followingSave the suffix with NotepadBatPress prompt to copy from below @ Copy Code code as follows: @echo off Color 1f Title close a

Copy Code code as follows: ECHO off REM QBFC Project Options Begin REM Hasversioninfo:no REM Companyname: REM Productname: REM filedescription: REM Copyrights: REM Trademarks: REM Originalname: REM Comments: REM productversion:0.0. 0.

Mysqldumpslow is MySQL's own tool for analyzing slow queries. Often use a few commands -S order what to sort by (Al, in, AR, C, L, R, T), ' at ' is default-T NUM just show the top n queriesThe-G pattern grep:only Consider stmts the include this

When you double-click Run, enter the name of the process Batch code: Copy Code code as follows: @ echo off Color 6e del 1.txt del ildd.txt TASKLIST &G T;>ildd.txt title kills the process and deletes the source

Windows XP Pro systems, Windows user names and passwords for network sharing authentication, intranet or proxy domain authentication, runas/savecred, and so on can be managed in the password management of users and Accounts in Control Panel, or you

Copy Code code as follows: /* Date: 2009-03-19 Function: Get the Game country task list data according to various conditions */ Create procedure [dbo]. [Prgs_nation_task_getlist] @PageSize int = 100--Displays the number of record bars

Copy Code code as follows: @echo off Echo starts backing up important data from this site! xcopy "D:\web\yunsafe.com\wwwroot\*.*" "D:\web\yunsafe.com\bak\bakup%date:~0,10%\wwwroot\"/i/q xcopy "D:\web\YUNSAFE.COM\WWWROOT\api"

Mssql Error log file storage location: C:\Program Files\Microsoft SQL Server\mssql\log View with Notepad @ @ERROR Returns an integer 0 as normal sysmessages stored Error Information system table (master) Use master SELECT * FROM sysmessages where

Custom Configuration network IP, gateway, Dns.bat Copy Code code as follows: @echo  off set slection1= set/p slection1= Please enter the IP address: netsh interface ip set address name= Local Area Connection

EQV operator Performs the logical equivalence operation of two expressions. result = expression1 Eqv expression2 Parameters Result Any numeric variable. Expression1 An arbitrary expression. Expression2 An arbitrary expression. Description If any of

Rasphone-h ADSL --------------------------- Dial-Up Networking command line --------------------------- Rasphone [-F file] [[e |-d |-H |-r] entry] Rasphone [-F file]-a [entry] Rasphone [-F file]-LX link Rasphone -A Popup New Project dialog box -e

GetObject function Returns a reference to the Automation object in the file. GetObject([pathname] [, class]) Parameters Pathname Options available. A string that contains the full path and name of the file to retrieve the object. If you omit

InputBox function Displays a prompt in the dialog box, waits for the user to enter text or clicks a button, and returns the contents of the text box. InputBox(prompt[,title][,default][,xpos][,ypos][,helpfile,context]) Parameters Prompt A string

But beginners use caution, do not casually take to cover up the error, otherwise the program will appear inexplicable problems, change can not be changed When you're done, remember to turn off the error trap on Error Goto 0 The syntax is as

So I studied for a while. Write a rough demo. Exe2hex.vbs//xiaolu wrote the Exe2vbs, I modified it into a direct drag-and-drop, turned to hexadecimal ================================================ Copy Code code as follows: ' Code by

Copy Code code as follows: '/*========================================================================= ' * Intro scheduled automatic backup folder to a new directory named after time, set up to add to the boot, as long as a start machine

The following four kinds of 99 multiplication tables of SQL statements written with the while and if conditions SQL statement implementation--x lower left corner 99 multiplication table DECLARE @i INT, @j int,@s VARCHAR () set @i= while

Copy Code code as follows: REM File update list batch Cls Title Yipingsoft CopyRight2006 REM "==================================================" FOR/R%%i in (.) Do del%%i\ latest file directory. txt Del Reference directory. txt Del

Following the previous two experiments, this experiment to master the use of SELECT statements for a variety of query operations: single-table query, multiple table connection and query, nested query, set query, etc., consolidate database query