sebastopol things to

an object and do not want to change the code that uses the object, you can use decorator mode. Decorator mode can be applied to a function in addition to the class (which is, in fact, the higher order function). For example, we want to measure the execution time of a function, so I can write a decorator like this: function func() { console.log('func');}function timeProfileDecorator(func) { return function (...args) { const startTime = new Date(); func.call(this, ...args

SELECT DBT. database_id, Db_name (DBT). database_id) ' database name ', DBT. transaction_id, At.name, at. Transaction_begin_time, case at. Transaction_type when 1 Then ' read/write Transaction ' When 2 Then ' read-only transaction ' when 3 Then ' system transaction ' When 4 Then ' Distributed transaction ' END ' transaction type ', case at. Transaction_state when 0 Then ' transaction has not been fully initialized ' when 1 Then ' transaction has been initialized but not started ' whe

ontology. Otherwise, when the table information is modified, when you query the record again, you will find that the situation is inconsistent with the actual situation. For example, a company's courier delivery is the company's front desk, but the front desk will always have personnel changes, people are not, but the work number is still in the transfer to the new use. The sender's name is stored directly when the sender's information is recorded. Sometimes, we also choose to store the primary

Select the database that needs to shrink the log, right-click Properties-Options, and change the recovery mode to simple.650) this.width=650; "title=" QQ picture 20141229141044.jpg "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M01/57/A1 /wkiol1sg83ytcuh3aaruahsla9w538.jpg "alt=" Wkiol1sg83ytcuh3aaruahsla9w538.jpg "/>Select the database, right-task-shrink-file.650) this.width=650; "title=" 1 "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M01/57/A3/ Wkiom1sg8sri7450aak1ezebu6s957.

Label:When creating a table, a field is non-empty timestamp, timestamp NOT null problem comes, when using Workbench to build a table, if the value is not empty, you need to have a default value, otherwise it will be an error. Then, if auto-population is updated with the default on update Current_timestamp, and inserted only at INSERT, Current_timestamp is used if not updated; The problem is, if you don't want to use Current_Timestamp how to do mud? ' End_time ' timestamp not NULL DEFAULT ' 0000-

Label:ACID Atomicity (atomicity), atomicity means that transactions in a database are executed as atoms. That is, the entire statement is either executed or not executed. Consistency (consistency), consistency, that is, the integrity constraints of the database are not compromised until the transaction begins and after the transaction has ended. Isolation (isolation), the execution of a transaction is non-disruptive, and a transaction cannot see the data in the middle of a time

Label: BEGIN TRANTran_money--Start a transaction DECLARE @tran_error int; SET @tran_error = 0; BEGINTRYUPDATETb_moneySETMymoney=Mymoney- - WHEREName= 'Liu Bei'; SET @tran_error = @tran_error + @ @ERROR; --test the error code to see if Liu Bei's money is reduced and whether Guan Yu's money will increase --SET @tran_error = 1; UPDATETb_moneySETMymoney=Mymoney+ - WHEREName= 'Guan Yu'; SET @tran_error = @tran_error + @ @ERROR; ENDTRYBEGINCATCHPRINT 'An exception occurred, error nu

represents the first line, tail means from the back intercept,-F can monitor the last 10 rows of changes.Here a new knowledge is referred to as the regular expression (BRE), the BRE basic regular characters also have matches, character matches, number of matches \? + {n} {m,n}, location anchors, grouping, and referencingEre is known as an extended regular expression, ere extended: character matching. [] [^], number of matches? + {M,n}Fgrep is a fastgrep that represents a quick match. Search for

. sudoapt-get install Skype 9. Installing RAR and other archiving toolsTo create a RAR archive from a context menu in a file manager such as Nemo, install the RAR tool. While installing RAR, several additional packages can be installed to increase support for other archive formats. sudoapt-get install unace p7zip-rar sharutils rar arj lunzip Lzip 10. Installing the Clipboard ManagerThe Clipboard Manager allows you to maintain and Access project history through

column separately. Sqlite> SELECT t1.first_col from TestTable T1,mydb.testtableT2 WHERE t.first_col = T2.first_col;First_col----------1Second, detach database:Uninstall the specified database in the current connection, and note that the main and temp databases cannot be uninstalled. See the example below:--The example hosts the results of the above example, where the MyDB database has been attach to the current connection. Sqlite>DETACH DATABASEMyDBSqlite> SELECT t1.first_col from testtable T1,

tempdb on a fast, dedicated I/O subsystem.6. Use SQL Server agent or mscom with SQL knowledge Pack to create an alert for the monitoring environment to ensure that trace 1101 or 1105 (data is full).The main monitoring of these counters: SQLServer:Databases:LogFile (s) Size (KB), SQLServer:Databases:DataFile (s) Size (KB), sqlserver:databases : Log File (s) used (KB).7. Initialize with an instant database file. Be sure to grant Se_manage_volume_name permissions to the service account. or run wit

AA-rw-r--r--1 root root 0 June 19:33 ABC-rw-r--r--1 root root 0 June 19:33 b[[email protected] tmp]# ll "*"-rw-r--r--1 root root 0 June 25 19:32 *1.3 double quotes and single quotation marks difference 1:About $[Email protected] ~]# echo "$LANG"en_US. UTF-8[Email protected] ~]# echo ' $LANG '$LANG1.4 double quotes and single quotation marks difference 2:About ' '[Email protected] ~]# echo "' which awk '"/bin/awk[[email protected] ~]# echo ' which awk '' Which awk '1.5 double quotes and single q

1, Programming things Programming refers to the implementation of things by coding, that is, like JDBC programming to implement things management Spring's support for programmatic things The things in spring can be divided into physical