rn 85856

# _*_ Coding:utf-8Import Xlrd,sysImport PickleImport JSONData=xlrd.open_workbook ("D:/test/6.xlsx")# #读取工作表, methods can be indexed sequentially, or you can use Sheet_by_name (U "Sheet1")Table = Data.sheet_by_index (0)# # #读取内容摘要表并存入nrarrnrarr={}Table1 = Data.sheet_by_index (1)For RO in range (2,table1.nrows):jj= table1.row (RO) [0].value#print roIf JJ! = "":Nr=table1.row (RO) [1].valueNrarr[jj]=nr#print nrarr[jj].encode (' gbk ', ' ignore ')‘‘‘#for k,v in Nrarr.items ():# print K, V.encode (' G

/** * @name after the collection of processing . PHP * @date Sat Dec 02:07:45 CST 2007 * @copyright Mayong accounted for (Myz) * @author Mayong accounted for (Myz) * @link http://blog.111cn.net/mayongzhan/ */ After the collection of documents And then take care of it. The things here Let me copy 5 books, which is inconvenient to provide, find it yourself. Header (' Content-type:text/html;charset=utf8 '); function writer ($content, $url) { $fp = fopen ($url, ' ab '); fwrite ($fp, $content);

project, just a system expert), So he had the opportunity to use his three strengths (laziness, impatience, and arrogance) to develop and improve all the useful tools--RN, Patch, and warp. (Note: It was at this time that Larry was drawn into the category of "Computer Animals", which was judged on the basis of the irresistible desire of those people to "add a trait", as this behavior was almost a biological necessity. After all, if life is too complic

constraints when it is converted to the base table's DML, and the DML of the view will also fail if there is a violation."What kind of a view can be a DML, is very flexible, we have the general rules on the line, the general rule is what we have just said: "In our views as DML, consider whether Oracle can convert this DML to the base table of DML." If not, the DML operation on the view will fail. Also consider whether the DML of the view will violate the base table's constraints if it is conver

Preface: A week has passed, has been in demand, in addition to their own use of spare time to study the outside there is no time to study new things, Alas ~ Program Ape is so, live to learn old!! Nonsense not to say, the company's products feel a certain e-commerce Product Details page very nice, asked if we can achieve (baby heart bitter ), so studied a wave, the following to my study of things to share, small partners have what good way to achieve also thank you for sharing oh ~ humbly! Let's

Tags: field ASC technology share ROM style images. com Blog TestTable test Data SELECT * FROM Test ORDER BY name Desc Results: 1-1:select * FROM (select A.*,rownum rn from Test A order by name ASC) where RN between 0 and 10 Results: 1-2:select * FROM (select A.*,rownum rn from Test A ORDER by name Desc) where RN be

A few days ago, the system was migrated from oracle to mysql. Many statements are relatively simple, that is, some function modifications, such as to-date. A few days ago, the system was migrated from oracle to mysql. Many statements are relatively simple, that is, some function modifications, such as to-date. Convert some statements from Oracle to MySQL [Date:] Source: Linux community Author: jimmy609 [Font:] A few days ago, the system was migrated from Oracle to mysql. Many statements ar

@example.com", "My Subject", "line 1nLine 2nLine 3"); Two. If you use the fourth parameter, the parameter string will be inserted at the end of the letter header. This is a typical insert used to illustrate additional letter header information. Multiple additional letter header information is separated by a carriage return R and a newline n character.Example 2. Send additional letter Header message: Mail ("nobody@example.com", "the subject", $message, "from:webmaster@{$_server[' server_name ']}

Using php code to back up a database makes website management very convenient. we can back up the database directly in the background. key technologies: 1. first, you need to obtain the tables in the database. the Function mysql_list_tables ()... using php code to back up a database makes website management very convenient. we can back up the database directly in the background. Key technologies: 1. First, you need to obtain the tables in the database, and use the mysql_list_tables () function.

()); Stack.pop (); if(Tr.getrnode ()! =NULL) {Tree rn=Tr.getrnode (); while(rn!=NULL) {Stack.add (RN); RN=Rn.getlnode (); } } } } /** * @authorYin * post-traversal non-recursive **/ Public voidAftertraversal (Tree node) {StackNewStack(); while(node!=NULL) {Stack

, '20140901', ename, null) "7499 ",Max (decode (empno, '20140901', ename, null) "7654"From EMPWhere Mgr in (7566,769 8)And deptno in (20, 30)Group by Mgr, deptnoOrder by 1, 2; Here, the transposed column is empno, and the fixed column is MGR and deptno. Another way to convert rows to columns is to change the row values in the same group to a single column value, but the transposed row values are not changed to column names: Id cn_1 cv_1 cn_2 cv_2 cn_3 cv_31 C1 V11 C2 V21 C3 v312 C1 V12 C2 v

d, B,2 Z, T In the execution plan, you only need to perform a table scan. However, this function is encrypted and the execution plan does not display internal operations of the function. ----- Column and column conversion 1Data Format 1Card_code Q bal-----------------------------001 1 27001 2 10001 3 36001 4 97002 1 96002 2 12002 3 15002 4 32 Data Format 2Card_code q1 q2 Q3 Q4-------------------------------------------------001 27 10 36 97002 96 12 15 32 -- Format 1 To Format 2 Select. card_co

obtain the largest field and then OK. The test is as follows: Select max (sys_connect_by_path (industry ,'/'))From orgindustriesStart with indid = 3Connect by indid = prior pindid; Result:/Women's Wear/clothing and apparel Complex tree structure-changing multiple columns to a single columnTree structures are also divided into single-tree and multi-tree structures (My name actually refers to single-tree and multi-tree structures)In the following case, the tree we must construct belongs to the si

A few days ago, the system was migrated from Oracle to mysql. Many statements are relatively simple, that is, some function modifications, such as to-date. But there are also a few tricky ones, which are recorded here 1. row_number () over (partition First, let's take a look at the usage of this function in oracle. Select t. *, row_number () over (partition by t. owner order by y. createDate desc) rn from test t This statement indicates that the data

-- Problem: query the average salary of each department's position And display it in a query Idea: first, we will find out the three tables, assuming a B c, and then combine a B with each other. There is no relationship between them, so to connect them, we need to use rownum to use the full outer join and rownum to make table a B in the form of fields (rather than rows) in this way, data in different tables can be merged in the form of columns (the reason is that the union all minus interse

the requirements, the ROWNUM of the second row becomes 1, so there will never be a record that meets the conditions. However, if you want to use rownum> 10, you need to use nested statements to convert Mr. rownum into and then query it.Select *From (selet rownum as rn, r. * from tbrole r where ...)Where rn> 10 This is usually the case when the result set is paged in the code. Oracle rownum is generated

I. Paging query: 1. Minute by rowidSelect * from t_xiaoxi where rowid in (select rid from (select rownum rn, rid from (select rowid rid, cid from t_xiaoxi order by cid desc) where rownum Execution time: 0.03 seconds 2. Score by Analysis FunctionSelect * from (select t. *, row_number () over (order by cid desc) rk from t_xiaoxi t) where rk Execution time: 1.01 seconds 3. Divide by rownumSelect * from (select t. *, rownum

// Data Ta Col_1 col_2 ----------- A B C D // Result: Col_1 col_2 ----------- A z0001 B z0002 C z0003 D z0004 // Create table ta ( Col_1 varchar2 (2 ), Col_2 varchar2 (7 )) / Insert into ta Select'A',''From dual union all Select'B',''From dual union all Select'C',''From dual union all Select'D',''From dual / // Solution 1: Declare Rn number: = 0; Begin ForClIn(Select col_1 from ta order by col_1) loop

1 BC3 3 1 de4 4 1 FG5 5 2 hij6 6 4 KLM7 7 6 nopq Let's take a look at the functions of connect_by_isleaf: View plaincopy to clipboardprint?Select ID, father_id, name, connect_by_isleaf leafFrom t_treeStart with father_id = 0Connect by prior id = father_id;Select ID, father_id, name, connect_by_isleaf leafFrom t_treeStart with father_id = 0Connect by prior id = father_id; Id father_id name leaf1 1 0 A 02 2 1 BC 03 5 2 hij 14 3 1 de 15 4 1 FG 06 6 4 KlM 07 7 6 nopq 1 View plaincopy to clipbo

A beautiful female DBA wants to learn SQL optimization, and is often confused with me. My favorite beauty. Today, he sent an SQL statement asking me to help you. The execution plan is as follows: Select "A1 ". "code", "A1 ". "device_id", "A1 ". "sideb_port_id", "A1 ". "version" from (select "A2 ". "Code" "code", "A2 ". "device_id" "device_id", "A2 ". "sideb_port_id" "sideb_port_id", "A3 ". "version" "version", row_number () over (partition by "A4 ". "prod_id" order by "A4 ". "hist_time" DESC) "