From: Date: August 6 2004 3:20am Subject: bk commit - mysqldoc tree (MHillyer:1.1926) List-Archive: http://lists.mysql.com/internals/15765 Message-Id: <0I20008743QA4A@l-daemon> MIME-Version: 1.0 Content-Type: TEXT/PLAIN Content-Transfer-Encoding: 8BIT Below is the list of changes that have just been committed into a local mysqldoc repository of MHillyer. When MHillyer does a push these changes will be propagated to the main repository and, within 24 hours after the push, to the public repository. For information on how to access the public repository see http://www.mysql.com/doc/I/n/Installing_source_tree.html ChangeSet 1.1926 04/08/05 19:20:25 MHillyer@doomhammer. +2 -0 Changed and new content for query browser docs. Docs/query-browser-en-images/dynamiclist.png 1.1 04/08/05 19:20:24 MHillyer@doomhammer. +277 -0 Docs/query-browser-en.xml 1.10 04/08/05 19:20:24 MHillyer@doomhammer. +124 -23 Tag changes, added using sections on master-detail and code editing. Docs/query-browser-en-images/dynamiclist.png 1.0 04/08/05 19:20:24 MHillyer@doomhammer. +0 -0 BitKeeper file C:/cygwin/home/MHillyer/mysqldoc/Docs/query-browser-en-images/dynamiclist.png # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: MHillyer # Host: doomhammer. # Root: C:/cygwin/home/MHillyer/mysqldoc --- 1.9/Docs/query-browser-en.xml 2004-08-05 15:16:15 -06:00 +++ 1.10/Docs/query-browser-en.xml 2004-08-05 19:20:24 -06:00 @@ -546,8 +546,8 @@ The center panel provides buttons for query management. The Explain button can be used to get the EXPLAIN output for the current query from the - MySQL server, while the Compare button will allow - you to compare the results of two queries graphically. + MySQL server, while the Compare button will + allow you to compare the results of two queries graphically. @@ -905,13 +905,13 @@ Once a table is selected, you can choose specific columns to query; - click the Select button from the query building - buttons on the button bar. Your mouse pointer will now change to a - Select pointer, which you can use to choose - fields from the schema browser. For example, by clicking on the Id, - Name, and Country fields of the World sample database, the query - SELECT C.Id, C.Name, C.Country FROM City C will - be built in the query area. + click the Select button from the query + building buttons on the button bar. Your mouse pointer will now + change to a Select pointer, which you can use to + choose fields from the schema browser. For example, by clicking on + the Id, Name, and Country fields of the World sample database, the + query SELECT C.Id, C.Name, C.Country FROM City C + will be built in the query area. @@ -928,9 +928,12 @@ You can change between the different query building pointers by clicking on the query building buttons in the button bar, or by - using a combination of Ctrl+Alt and the first - letter of the pointer you wish to use (Ctrl+Alt+S - for SELECT, Ctrl+Alt+W for WHERE). + using a combination of Ctrl+Alt + and the first letter of the pointer you wish to use + (Ctrl+Alt+S for + SELECT, + Ctrl+Alt+W for + WHERE). @@ -952,11 +955,11 @@ You can navigate the tabsheet using the arrow keys, tab key, and PageUp/PageDown keys. The Home and End keys can be used to move to the first and last column within a given row. The - First and Last buttons at the - bottom of the tabsheet can be used to move to the first and last - rows of the resultset. The Search button at the - bottom of the tabsheet can be used to find a specific value within - the tabsheet. + First and Last buttons + at the bottom of the tabsheet can be used to move to the first and + last rows of the resultset. The Search button + at the bottom of the tabsheet can be used to find a specific value + within the tabsheet. @@ -977,9 +980,9 @@ [MH] THIS WILL CHANGE, UPDATE WHEN APPROPRIATE - To edit a resultset click the Edit button. If the - Edit button is not active, your resultset is not - editable. + To edit a resultset click the Edit button. If + the Edit button is not active, your resultset + is not editable. @@ -1063,19 +1066,117 @@ - + + + Creating Master-Detail Views - + + MySQL Query Browser makes it easy to view data that is in a + master-detail (one to many) relationship. This can be useful for + viewing customer/order data, group/member data, etc. + + + + To display a master-detail view, first query the master table in a + new tabsheet. For example, using the World sample database, you + could issue a query like SELECT Code, Name, Continent FROM + Country. + + + + Once you have created the master resultset, right-click on the + tabsheet and choose the Split Tab Vertically + option. For the detail query, create a query that uses the dynamic + parameters available from the master query, as seen in the parameter + browser. In this example, we could query the City table like this: + SELECT Id, Name FROM City WHERE Country = :Code. + + + + The colon character indicates to the MySQL Query Browser that you + are adding a dynamic parameter, and a pop-up list of available + parameters should appear within the query area, allowing you to + choose a dynamic parameter using the arrow keys. You can also type + the name of the field from the master resultset that you would like + to use to link the detail query. + + +
+ + The dynamic parameter list + + +
+ + + Once you execute the detail query it will automatically refresh any + time you change the active row in the master query, allowing you to + quickly see all detail rows as you navigate the master resultset. + + + + You can repeat this process, splitting the tabsheet additional + times, allowing you to have detail resultsets for detail resultsets. + - + + + + Editing Queries From a Development Tool + + + + In order to help programmers optimize and troubleshoot their queries + more effectively, the MySQL Query Browser can copy queries from + application code using your favorite IDE. + + + + This functionality is only available for the Windows + version of MySQL Query Browser. + + + + The following PHP code will be used as an example: + + + $SQL = "SELECT Id, Name, Country FROM City"; + mysql_query($SQL,$db); + + + To copy the listing into the MySQL Query Browser, highlight the + first line from within your editor and press Ctrl + + Alt + Shift + C. + The non-query portions of the line will be stripped and the query + will be pasted into the query area. + + + + After editing the query, press Ctrl + + Alt + Shift + V + to load the modified query back into your original code. The + surrounding PHP code will be re-inserted along with the modified + query. This functionality will allow you to edit queries quickly + while programming. + + + + In order to use this functionality your editing application will + need to support the standard Windows clipboard system, which most + applications do. + + + + + --- New file --- +++ Docs/query-browser-en-images/dynamiclist.png 04/08/05 19:20:24 PNG  4( 2)L\-&.&X$hpO[Y՗sNޕ?vۇ }'{ .@? p@7 /  BL5r)Ģ9s9{Z\D"L|'o! \سg#vfr+K ^`uO>Q[S!3;ocE\%eMXYҦ"vEgLoBY/s'ImP<{¤m7-bx/#C]V5 R`hRanzHNwq/ mqU]re >N? ?.ϼ1(9ke+K"稬}TcJn*bߨ(_PRzAtA_F+ےJ/6LE.?gK&[xϬPV( MmM͊n:i銕׵Y0U e3G3.5[_Hy֬cvU] elW Q@;p UZMwoCi~I6NPP/CP@ "?9bs/-u+iJ*H8T={Y0Z ]b_FME0O/vhߤHyV+]P鑜#9G+X/EΊ%!<=}Ҫ߽/4v^(yز+Wuǖ5LT/_dbq3JD"ZorYG1sӨ?.8G>uڔ4gЛU÷{?@ p Dy眵M[R@3Uf풫 M!?m)uAuԜR֌wr\A9kjY;XT"XWWF͉YTshZʝ4NϼЍ([66Tj +3+otY{9bo4kD<SVz],+HdJ+4<0wD?7oZ|le]CVy/1P6& \kӺ#Pjf\/[rA_ft"Mr [OL= snJT̠VKJTl R5kHu _uv3zvlle]Ck__$hKP@ "7ԟIL1s)̤ʳ*Slߟʉj9JQ|4+n/98x:94e\z#̦)4?(=V $(o{x;Uc&u_~C'zyHP@ "kv9jr, ߤ#yε+M1`A*뺶9lJ H{o޶ I$2 Lr@j >N~sègϚC @$GZwm\: ",:y. ` 1/tO~(A@>sy X6~g7yBCYc$utL~~qSpS8^:,<hǰu'J'$E#M  ðuss}՟W]>io%tݛ?./uq?.o}v$):d7D1H e韦j7MIaf?|j2X?$m?1X3_J~!\p =|&1e3ljֱjjgO3Kݟ'g[ʃ ~cп;Rn8]V7vF߭(7"&?~~OFY-ӿO9M2ZN+zw %ѺK$c_cȆ@c_-vDD^^dMWv'aV_nʶQbi¹o{LΗ64,G^?~5d"X~w?(E;vOuJﾍ~;8y{km3 a ZIe)٧I#h,)B  B{9[bluO%4{FvqiC`ψj4Ϥ?p^, $fwOUl~rgm~Rpo8x4֚·6MS}