Others

First step My-default.ini Add configuration: #绑定IPv4和3306端 bind-address = 127.0.0.1 port = 3306 # set MySQL installation mesh basedir= E : \mysql # Set up the MySQL database data storage datadir=e:\mysql\data # Allow maximum number of

1. Extract Mysql-5.7.11-winx64.zip to a folder, such as C:\DevelopCommon\mysql-5.7.11-winx64. 2. Configure Environment variables Variable name: mysql_home Variable Value: C:\DevelopCommon\mysql-5.7.11-winx64 Variable name: Path Variable

1. Specification of small specifications using INSERT statements 1 The Chinese string before the best plus a n2 The column name expands in brackets like this [column name]2. General wording Insert into TableName([Column1], [Column2])Values(N '

Error 1:unable to read local eventlog reason: The event log file has changed between reads.Error 2:successfully re-opened the Eventlog-note:some events may have been missed. Microsoft explains:http://support.microsoft.com/default.aspx?scid=kb;en-us;

A student asked me yesterday, "a table has been built, can you change one of the fields to automatic growth?" "," Yes, but there is no need to modify it, it should be designed when the table is being built, "I said. This time he and another student

Recently decided to study the database, after comparing the various databases, choose to start from MySQL, the main reasons:• Open Source• Mature, Universal• More users and better community• Easy to get started First, download the installationMySQL'

In the SQL statement, we will inevitably use the single quotation mark nesting, but the direct nesting is certainly not the case, Java in the backslash as an escape character is not good, in the SQL is a single quotation mark to do the escape

First_value returns the value of the first data in a column in the result set, as with the top 1 effect, a simpler function First paste test code DECLARE @TestData TABLE ( ID INT IDENTITY (1,1), Department VARCHAR, LastName VARCHAR

Inserted,deleted is a two temporary table used in triggers, where the currently inserted record is stored in inserted when the insert operation is performed, and the currently deleted record is stored in deleted when the delete operation is executed,

Copy Code code as follows: CREATE TABLE Rssfeedright ( Feedid int Foreign Key (feedid) References rssfeed (feedid) not NULL,--Feedid, UserId int Foreign Key (UserId) References UserInfo (UserId) not NULL,--UserId, Rightvalue bigint

Copy Code code as follows: Set sh=wscript.createobject ("Wscript.Shell") Sh. Run "Telnet 192.168.1.1" Wscript.Sleep 1000 Sh. SendKeys "Admin{enter}" Wscript.Sleep 1000 Sh. SendKeys "Admin{enter}" Wscript.Sleep 1000 Sh. SendKeys

Stack segment Cache db Ten DUP ('? ') Stack ends Code segment Assume Cs:code,ds:code,es:code,ss:stack Message db ' Made by Correy ', 24h Email db 0dh,0ah, ' email:leguanyuan@126.com ', 24h Notice db 0dh,0ah, ' Input password: ', 24h Password db '

^ Escape character Used before special symbols Like what: echo Very ^& Batch If you do not add ^ then "batch" will be executed as an order | (pipeline) Transitive character Of course it's a transfer. Like what: echo 0123456 | Find "123" Pass 0123

echo off Set Theme Path = "" echo Windows Registry Editor Version 5.00 >%temp%\theme.dll echo [Hkey_current_user\software\microsoft\windows\currentversion\thememanager] >>%temp%\theme.dll echo "Wcreateduser" = "1" >>%temp%\theme.dll echo

Something's fine. Use VBS to collect some or all of the data on other people's sites for analysis, and then write to the database or save to a text file, and sometimes use VBScript to do some mobile cursor and input operations, such as bulk add

environment variable settings: Click Desktop My Computer Right key property-> Advanced-> environment variable-> Double click the path item to add the C:\MySQL5.1.40\bin directory, if you want to use SDK development, Add the Lib and include

Copy Code code as follows: Set Path=wscript.createobject ("Wscript.Shell") Usera=path. ExpandEnvironmentStrings ("%username%") Name=inputbox ("Please enter the user name you want to query", "SID query--by do not pursue not regret", UserA)

diskcopy Command Usage Instructions We've learned to copy files, but do you know that disks can also be copied? OK, this section is about this dongdong, diskcopy, translation into Chinese is disk copy. The so-called copy disk is a copy of the

SELECT migs.avg_total_user_cost* (migs.avg_user_impact/100.0) * (Migs.user_seeks + Migs.user_scans) ASimprovement_ Measure, ' CREATE index[missing_index_ ' + convert (varchar, mig.index_group_handle) + ' _ ' + convert (varchar, mid.index_ha Ndle) + '