home *** CD-ROM | disk | FTP | other *** search
| MIME HTML Archive | 2002-11-10 | 58.0 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
browse contents |
view JSON data
|
view as text
This file was processed as: MIME HTML Archive
(archive/mimeHTMLArchive).
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| dexvert
| MIME HTML Archive (archive/mimeHTMLArchive)
| magic
| Supported |
| 100%
| dexvert
| Newsgroup Content (archive/news)
| magic
| Supported |
| 100%
| dexvert
| Internet Message Format (text/imf)
| magic
| Supported |
| 10%
| dexvert
| Mailbox/MIME Entity (archive/mbox)
| magic
| Supported |
| 1%
| dexvert
| Text File (text/txt)
| fallback
| Supported |
| 100%
| file
| news or mail text
| default
| |
| 99%
| file
| HTML document text
| default (weak)
| |
| 98%
| file
| exported SGML document, ASCII text, with CRLF line terminators
| default
| |
| 88%
| TrID
| MIME HTML archive format
| default
| |
| 11%
| TrID
| E-Mail message (Var. 2)
| default
| |
| 100%
| checkBytes
| Printable ASCII
| default
| |
| 100%
| perlTextCheck
| Likely Text (Perl)
| default
| |
| 100%
| siegfried
| x-fmt/429 MHTML
| default
| |
| 100%
| gt2
| HTML (Hyper Text Markup Language) Datei
| default
| |
| 100%
| detectItEasy
| Format: Plain text[CRLF]
| default
| |
| 100%
| xdgMime
| message/rfc822
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 46 72 6f 6d 3a 20 3c 53 | 61 76 65 64 20 62 79 20 |From: <S|aved by |
|00000010| 4d 69 63 72 6f 73 6f 66 | 74 20 49 6e 74 65 72 6e |Microsof|t Intern|
|00000020| 65 74 20 45 78 70 6c 6f | 72 65 72 20 35 3e 0d 0a |et Explo|rer 5>..|
|00000030| 53 75 62 6a 65 63 74 3a | 20 77 65 62 79 6f 67 20 |Subject:| webyog |
|00000040| 2d 20 73 71 6c 79 6f 67 | 20 2d 20 66 61 71 0d 0a |- sqlyog| - faq..|
|00000050| 44 61 74 65 3a 20 4d 6f | 6e 2c 20 31 31 20 4e 6f |Date: Mo|n, 11 No|
|00000060| 76 20 32 30 30 32 20 30 | 31 3a 31 31 3a 35 39 20 |v 2002 0|1:11:59 |
|00000070| 2b 30 35 33 30 0d 0a 4d | 49 4d 45 2d 56 65 72 73 |+0530..M|IME-Vers|
|00000080| 69 6f 6e 3a 20 31 2e 30 | 0d 0a 43 6f 6e 74 65 6e |ion: 1.0|..Conten|
|00000090| 74 2d 54 79 70 65 3a 20 | 6d 75 6c 74 69 70 61 72 |t-Type: |multipar|
|000000a0| 74 2f 72 65 6c 61 74 65 | 64 3b 0d 0a 09 62 6f 75 |t/relate|d;...bou|
|000000b0| 6e 64 61 72 79 3d 22 2d | 2d 2d 2d 3d 5f 4e 65 78 |ndary="-|---=_Nex|
|000000c0| 74 50 61 72 74 5f 30 30 | 30 5f 30 30 30 30 5f 30 |tPart_00|0_0000_0|
|000000d0| 31 43 32 38 39 31 46 2e | 35 35 38 30 37 41 37 30 |1C2891F.|55807A70|
|000000e0| 22 3b 0d 0a 09 74 79 70 | 65 3d 22 74 65 78 74 2f |";...typ|e="text/|
|000000f0| 68 74 6d 6c 22 0d 0a 58 | 2d 4d 69 6d 65 4f 4c 45 |html"..X|-MimeOLE|
|00000100| 3a 20 50 72 6f 64 75 63 | 65 64 20 42 79 20 4d 69 |: Produc|ed By Mi|
|00000110| 63 72 6f 73 6f 66 74 20 | 4d 69 6d 65 4f 4c 45 20 |crosoft |MimeOLE |
|00000120| 56 36 2e 30 30 2e 32 36 | 30 30 2e 30 30 30 30 0d |V6.00.26|00.0000.|
|00000130| 0a 0d 0a 54 68 69 73 20 | 69 73 20 61 20 6d 75 6c |...This |is a mul|
|00000140| 74 69 2d 70 61 72 74 20 | 6d 65 73 73 61 67 65 20 |ti-part |message |
|00000150| 69 6e 20 4d 49 4d 45 20 | 66 6f 72 6d 61 74 2e 0d |in MIME |format..|
|00000160| 0a 0d 0a 2d 2d 2d 2d 2d | 2d 3d 5f 4e 65 78 74 50 |...-----|-=_NextP|
|00000170| 61 72 74 5f 30 30 30 5f | 30 30 30 30 5f 30 31 43 |art_000_|0000_01C|
|00000180| 32 38 39 31 46 2e 35 35 | 38 30 37 41 37 30 0d 0a |2891F.55|807A70..|
|00000190| 43 6f 6e 74 65 6e 74 2d | 54 79 70 65 3a 20 74 65 |Content-|Type: te|
|000001a0| 78 74 2f 68 74 6d 6c 3b | 0d 0a 09 63 68 61 72 73 |xt/html;|...chars|
|000001b0| 65 74 3d 22 69 73 6f 2d | 38 38 35 39 2d 31 22 0d |et="iso-|8859-1".|
|000001c0| 0a 43 6f 6e 74 65 6e 74 | 2d 54 72 61 6e 73 66 65 |.Content|-Transfe|
|000001d0| 72 2d 45 6e 63 6f 64 69 | 6e 67 3a 20 71 75 6f 74 |r-Encodi|ng: quot|
|000001e0| 65 64 2d 70 72 69 6e 74 | 61 62 6c 65 0d 0a 43 6f |ed-print|able..Co|
|000001f0| 6e 74 65 6e 74 2d 4c 6f | 63 61 74 69 6f 6e 3a 20 |ntent-Lo|cation: |
|00000200| 68 74 74 70 3a 2f 2f 77 | 77 77 2e 77 65 62 79 6f |http://w|ww.webyo|
|00000210| 67 2e 63 6f 6d 2f 73 71 | 6c 79 6f 67 2f 66 61 71 |g.com/sq|lyog/faq|
|00000220| 2e 68 74 6d 6c 0d 0a 0d | 0a 3c 21 44 4f 43 54 59 |.html...|.<!DOCTY|
|00000230| 50 45 20 48 54 4d 4c 20 | 50 55 42 4c 49 43 20 22 |PE HTML |PUBLIC "|
|00000240| 2d 2f 2f 57 33 43 2f 2f | 44 54 44 20 48 54 4d 4c |-//W3C//|DTD HTML|
|00000250| 20 34 2e 30 20 54 72 61 | 6e 73 69 74 69 6f 6e 61 | 4.0 Tra|nsitiona|
|00000260| 6c 2f 2f 45 4e 22 3e 0d | 0a 3c 48 54 4d 4c 3e 3c |l//EN">.|.<HTML><|
|00000270| 48 45 41 44 3e 3c 54 49 | 54 4c 45 3e 77 65 62 79 |HEAD><TI|TLE>weby|
|00000280| 6f 67 20 2d 20 73 71 6c | 79 6f 67 20 2d 20 66 61 |og - sql|yog - fa|
|00000290| 71 3c 2f 54 49 54 4c 45 | 3e 3c 4c 49 4e 4b 3d 32 |q</TITLE|><LINK=2|
|000002a0| 30 0d 0a 68 72 65 66 3d | 33 44 22 2e 2e 2f 6d 79 |0..href=|3D"../my|
|000002b0| 73 71 6c 79 6f 67 2f 77 | 65 62 73 74 79 6c 65 2e |sqlyog/w|ebstyle.|
|000002c0| 63 73 73 22 20 72 65 6c | 3d 33 44 73 74 79 6c 65 |css" rel|=3Dstyle|
|000002d0| 73 68 65 65 74 3e 0d 0a | 3c 4d 45 54 41 20 68 74 |sheet>..|<META ht|
|000002e0| 74 70 2d 65 71 75 69 76 | 3d 33 44 43 6f 6e 74 65 |tp-equiv|=3DConte|
|000002f0| 6e 74 2d 54 79 70 65 20 | 63 6f 6e 74 65 6e 74 3d |nt-Type |content=|
|00000300| 33 44 22 74 65 78 74 2f | 68 74 6d 6c 3b 20 3d 0d |3D"text/|html; =.|
|00000310| 0a 63 68 61 72 73 65 74 | 3d 33 44 69 73 6f 2d 38 |.charset|=3Diso-8|
|00000320| 38 35 39 2d 31 22 3e 0d | 0a 3c 4d 45 54 41 3d 32 |859-1">.|.<META=2|
|00000330| 30 0d 0a 63 6f 6e 74 65 | 6e 74 3d 33 44 22 77 65 |0..conte|nt=3D"we|
|00000340| 62 79 6f 67 20 6d 79 73 | 71 6c 79 6f 67 20 73 71 |byog mys|qlyog sq|
|00000350| 6c 79 6f 67 20 6d 79 73 | 71 6c 20 66 72 6f 6e 74 |lyog mys|ql front|
|00000360| 20 65 6e 64 20 6d 79 73 | 71 6c 20 63 6c 69 65 6e | end mys|ql clien|
|00000370| 74 20 6d 79 73 71 6c 20 | 3d 0d 0a 71 75 65 72 79 |t mysql |=..query|
|00000380| 20 61 6e 61 6c 79 7a 65 | 72 20 73 71 6c 20 6d 79 | analyze|r sql my|
|00000390| 73 71 6c 20 47 55 49 20 | 73 74 72 75 63 74 75 72 |sql GUI |structur|
|000003a0| 65 64 20 71 75 65 72 79 | 20 6c 61 6e 67 75 61 67 |ed query| languag|
|000003b0| 65 20 72 69 74 65 73 68 | 20 6e 61 64 68 61 6e 69 |e ritesh| nadhani|
|000003c0| 20 3d 0d 0a 72 6f 68 69 | 74 20 6e 61 64 68 61 6e | =..rohi|t nadhan|
|000003d0| 69 20 76 69 6b 61 73 68 | 20 61 67 61 72 77 61 6c |i vikash| agarwal|
|000003e0| 20 3c 54 54 3e 6d 79 73 | 71 6c 20 77 69 6e 64 6f | <TT>mys|ql windo|
|000003f0| 77 73 20 74 6f 6f 6c 20 | 65 64 69 74 6f 72 20 66 |ws tool |editor f|
|00000400| 72 6f 6e 74 20 65 6e 64 | 20 3d 0d 0a 66 72 6f 6e |ront end| =..fron|
|00000410| 74 2d 65 6e 64 20 67 75 | 69 20 67 72 61 70 68 69 |t-end gu|i graphi|
|00000420| 63 61 6c 20 63 6c 69 65 | 6e 74 20 71 75 65 72 79 |cal clie|nt query|
|00000430| 20 61 6e 61 6c 79 7a 65 | 72 20 64 65 76 65 6c 6f | analyze|r develo|
|00000440| 70 6d 65 6e 74 20 65 6e | 76 69 72 6f 6e 6d 65 6e |pment en|vironmen|
|00000450| 74 20 3d 0d 0a 49 44 45 | 20 77 69 6e 33 32 20 73 |t =..IDE| win32 s|
|00000460| 69 6d 70 6c 65 20 66 61 | 73 74 20 65 61 73 79 20 |imple fa|st easy |
|00000470| 62 65 67 69 6e 6e 65 72 | 20 64 75 6d 6d 79 22 3d |beginner| dummy"=|
|00000480| 32 30 0d 0a 6e 61 6d 65 | 3d 33 44 6b 65 79 77 6f |20..name|=3Dkeywo|
|00000490| 72 64 73 3e 0d 0a 3c 4d | 45 54 41 20 63 6f 6e 74 |rds>..<M|ETA cont|
|000004a0| 65 6e 74 3d 33 44 22 77 | 65 62 79 6f 67 20 2d 20 |ent=3D"w|ebyog - |
|000004b0| 63 72 65 61 74 6f 72 73 | 20 6f 66 20 73 71 6c 79 |creators| of sqly|
|000004c0| 6f 67 2c 20 74 68 65 20 | 64 65 66 69 6e 69 74 69 |og, the |definiti|
|000004d0| 76 65 20 6d 79 73 71 6c | 20 71 75 65 72 79 20 3d |ve mysql| query =|
|000004e0| 0d 0a 61 6e 61 6c 79 7a | 65 72 22 3d 32 30 0d 0a |..analyz|er"=20..|
|000004f0| 6e 61 6d 65 3d 33 44 64 | 65 73 63 72 69 70 74 69 |name=3Dd|escripti|
|00000500| 6f 6e 3e 3c 4c 49 4e 4b | 20 68 72 65 66 3d 33 44 |on><LINK| href=3D|
|00000510| 22 68 74 74 70 3a 2f 2f | 77 77 77 2e 77 65 62 79 |"http://|www.weby|
|00000520| 6f 67 2e 63 6f 6d 2f 77 | 65 62 73 74 79 6c 65 2e |og.com/w|ebstyle.|
|00000530| 63 73 73 22 20 3d 0d 0a | 74 79 70 65 3d 33 44 74 |css" =..|type=3Dt|
|00000540| 65 78 74 2f 63 73 73 3d | 32 30 0d 0a 72 65 6c 3d |ext/css=|20..rel=|
|00000550| 33 44 73 74 79 6c 65 73 | 68 65 65 74 3e 0d 0a 3c |3Dstyles|heet>..<|
|00000560| 4d 45 54 41 20 63 6f 6e | 74 65 6e 74 3d 33 44 22 |META con|tent=3D"|
|00000570| 4d 53 48 54 4d 4c 20 36 | 2e 30 30 2e 32 36 30 30 |MSHTML 6|.00.2600|
|00000580| 2e 30 22 20 6e 61 6d 65 | 3d 33 44 47 45 4e 45 52 |.0" name|=3DGENER|
|00000590| 41 54 4f 52 3e 3c 2f 48 | 45 41 44 3e 0d 0a 3c 42 |ATOR></H|EAD>..<B|
|000005a0| 4f 44 59 20 74 65 78 74 | 3d 33 44 23 30 30 30 30 |ODY text|=3D#0000|
|000005b0| 30 30 20 62 67 43 6f 6c | 6f 72 3d 33 44 23 66 66 |00 bgCol|or=3D#ff|
|000005c0| 66 66 66 66 20 6c 65 66 | 74 4d 61 72 67 69 6e 3d |ffff lef|tMargin=|
|000005d0| 33 44 30 20 74 6f 70 4d | 61 72 67 69 6e 3d 33 44 |3D0 topM|argin=3D|
|000005e0| 30 20 3d 0d 0a 6d 61 72 | 67 69 6e 68 65 69 67 68 |0 =..mar|ginheigh|
|000005f0| 74 3d 33 44 22 30 22 3d | 32 30 0d 0a 6d 61 72 67 |t=3D"0"=|20..marg|
|00000600| 69 6e 77 69 64 74 68 3d | 33 44 22 30 22 3e 0d 0a |inwidth=|3D"0">..|
|00000610| 3c 54 41 42 4c 45 20 63 | 65 6c 6c 53 70 61 63 69 |<TABLE c|ellSpaci|
|00000620| 6e 67 3d 33 44 30 20 63 | 65 6c 6c 50 61 64 64 69 |ng=3D0 c|ellPaddi|
|00000630| 6e 67 3d 33 44 30 20 77 | 69 64 74 68 3d 33 44 22 |ng=3D0 w|idth=3D"|
|00000640| 31 30 30 25 22 20 62 6f | 72 64 65 72 3d 33 44 30 |100%" bo|rder=3D0|
|00000650| 3e 0d 0a 20 20 3c 54 42 | 4f 44 59 3e 0d 0a 20 20 |>.. <TB|ODY>.. |
|00000660| 3c 54 52 3e 0d 0a 20 20 | 20 20 3c 54 44 3e 0d 0a |<TR>.. | <TD>..|
|00000670| 20 20 20 20 20 20 3c 54 | 41 42 4c 45 20 63 65 6c | <T|ABLE cel|
|00000680| 6c 53 70 61 63 69 6e 67 | 3d 33 44 30 20 63 65 6c |lSpacing|=3D0 cel|
|00000690| 6c 50 61 64 64 69 6e 67 | 3d 33 44 30 20 77 69 64 |lPadding|=3D0 wid|
|000006a0| 74 68 3d 33 44 22 31 30 | 30 25 22 20 62 6f 72 64 |th=3D"10|0%" bord|
|000006b0| 65 72 3d 33 44 30 3e 0d | 0a 20 20 20 20 20 20 20 |er=3D0>.|. |
|000006c0| 20 3c 54 42 4f 44 59 3e | 0d 0a 20 20 20 20 20 20 | <TBODY>|.. |
|000006d0| 20 20 3c 54 52 3e 0d 0a | 20 20 20 20 20 20 20 20 | <TR>..| |
|000006e0| 20 20 3c 54 44 20 76 41 | 6c 69 67 6e 3d 33 44 74 | <TD vA|lign=3Dt|
|000006f0| 6f 70 20 63 6f 6c 53 70 | 61 6e 3d 33 44 33 3e 3c |op colSp|an=3D3><|
|00000700| 49 4d 47 20 68 65 69 67 | 68 74 3d 33 44 36 30 3d |IMG heig|ht=3D60=|
|00000710| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00000720| 73 72 63 3d 33 44 22 68 | 74 74 70 3a 2f 2f 77 77 |src=3D"h|ttp://ww|
|00000730| 77 2e 77 65 62 79 6f 67 | 2e 63 6f 6d 2f 69 6d 61 |w.webyog|.com/ima|
|00000740| 67 65 73 2f 77 65 62 62 | 61 6e 2e 6a 70 67 22 20 |ges/webb|an.jpg" |
|00000750| 3d 0d 0a 77 69 64 74 68 | 3d 33 44 36 30 30 3e 3c |=..width|=3D600><|
|00000760| 2f 54 44 3e 3c 2f 54 52 | 3e 0d 0a 20 20 20 20 20 |/TD></TR|>.. |
|00000770| 20 20 20 3c 54 52 3e 0d | 0a 20 20 20 20 20 20 20 | <TR>.|. |
|00000780| 20 20 20 3c 54 44 20 76 | 41 6c 69 67 6e 3d 33 44 | <TD v|Align=3D|
|00000790| 74 6f 70 20 77 69 64 74 | 68 3d 33 44 22 32 30 25 |top widt|h=3D"20%|
|000007a0| 22 20 62 67 43 6f 6c 6f | 72 3d 33 44 23 33 33 33 |" bgColo|r=3D#333|
|000007b0| 33 36 36 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |366>.. | |
|000007c0| 20 20 3c 54 41 42 4c 45 | 20 63 65 6c 6c 53 70 61 | <TABLE| cellSpa|
|000007d0| 63 69 6e 67 3d 33 44 30 | 20 63 65 6c 6c 50 61 64 |cing=3D0| cellPad|
|000007e0| 64 69 6e 67 3d 33 44 30 | 20 77 69 64 74 68 3d 33 |ding=3D0| width=3|
|000007f0| 44 22 31 30 30 25 22 20 | 3d 0d 0a 62 67 43 6f 6c |D"100%" |=..bgCol|
|00000800| 6f 72 3d 33 44 23 33 33 | 33 33 36 36 3d 32 30 0d |or=3D#33|3366=20.|
|00000810| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 62 6f 72 |. | bor|
|00000820| 64 65 72 3d 33 44 30 3e | 0d 0a 20 20 20 20 20 20 |der=3D0>|.. |
|00000830| 20 20 20 20 20 20 20 20 | 3c 54 42 4f 44 59 3e 0d | |<TBODY>.|
|00000840| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c |. | <|
|00000850| 54 52 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |TR>.. | |
|00000860| 20 20 20 20 20 3c 54 44 | 20 76 41 6c 69 67 6e 3d | <TD| vAlign=|
|00000870| 33 44 74 6f 70 20 63 6f | 6c 53 70 61 6e 3d 33 44 |3Dtop co|lSpan=3D|
|00000880| 32 3e 26 6e 62 73 70 3b | 3c 2f 54 44 3e 0d 0a 20 |2> |</TD>.. |
|00000890| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c | | <|
|000008a0| 54 44 20 77 69 64 74 68 | 3d 33 44 22 34 25 22 3e |TD width|=3D"4%">|
|000008b0| 26 6e 62 73 70 3b 3c 2f | 54 44 3e 3c 2f 54 52 3e | </|TD></TR>|
|000008c0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000008d0| 3c 54 52 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |<TR>.. | |
|000008e0| 20 20 20 20 20 20 3c 54 | 44 20 76 41 6c 69 67 6e | <T|D vAlign|
|000008f0| 3d 33 44 63 65 6e 74 65 | 72 3e 0d 0a 20 20 20 20 |=3Dcente|r>.. |
|00000900| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 44 | | <D|
|00000910| 49 56 20 61 6c 69 67 6e | 3d 33 44 72 69 67 68 74 |IV align|=3Dright|
|00000920| 3e 3c 46 4f 4e 54 3d 32 | 30 0d 0a 20 20 20 20 20 |><FONT=2|0.. |
|00000930| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 66 61 63 | | fac|
|00000940| 65 3d 33 44 22 56 65 72 | 64 61 6e 61 2c 20 41 72 |e=3D"Ver|dana, Ar|
|00000950| 69 61 6c 2c 20 48 65 6c | 76 65 74 69 63 61 2c 20 |ial, Hel|vetica, |
|00000960| 73 61 6e 73 2d 73 65 72 | 69 66 22 20 3d 0d 0a 63 |sans-ser|if" =..c|
|00000970| 6f 6c 6f 72 3d 33 44 23 | 66 66 66 66 66 66 3d 32 |olor=3D#|ffffff=2|
|00000980| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00000990| 20 20 20 20 20 73 69 7a | 65 3d 33 44 32 3e 3c 2f | siz|e=3D2></|
|000009a0| 46 4f 4e 54 3e 3c 2f 44 | 49 56 3e 3c 2f 54 44 3e |FONT></D|IV></TD>|
|000009b0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000009c0| 20 20 3c 54 44 20 76 41 | 6c 69 67 6e 3d 33 44 63 | <TD vA|lign=3Dc|
|000009d0| 65 6e 74 65 72 20 62 67 | 43 6f 6c 6f 72 3d 33 44 |enter bg|Color=3D|
|000009e0| 23 33 33 33 33 36 36 3e | 0d 0a 20 20 20 20 20 20 |#333366>|.. |
|000009f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 44 49 56 | | <DIV|
|00000a00| 20 61 6c 69 67 6e 3d 33 | 44 72 69 67 68 74 3e 3c | align=3|Dright><|
|00000a10| 46 4f 4e 54 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |FONT=20.|. |
|00000a20| 20 20 20 20 20 20 20 20 | 20 20 20 66 61 63 65 3d | | face=|
|00000a30| 33 44 22 56 65 72 64 61 | 6e 61 2c 20 41 72 69 61 |3D"Verda|na, Aria|
|00000a40| 6c 2c 20 48 65 6c 76 65 | 74 69 63 61 2c 20 73 61 |l, Helve|tica, sa|
|00000a50| 6e 73 2d 73 65 72 69 66 | 22 20 3d 0d 0a 63 6f 6c |ns-serif|" =..col|
|00000a60| 6f 72 3d 33 44 23 66 66 | 66 66 66 66 3d 32 30 0d |or=3D#ff|ffff=20.|
|00000a70| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00000a80| 20 20 20 73 69 7a 65 3d | 33 44 32 3e 3c 42 20 63 | size=|3D2><B c|
|00000a90| 6c 61 73 73 3d 33 44 6d | 65 6e 75 69 74 65 6d 3e |lass=3Dm|enuitem>|
|00000aa0| 3c 41 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |<A=20.. | |
|00000ab0| 20 20 20 20 20 20 20 20 | 20 3d 0d 0a 68 72 65 66 | | =..href|
|00000ac0| 3d 33 44 22 68 74 74 70 | 3a 2f 2f 77 77 77 2e 77 |=3D"http|://www.w|
|00000ad0| 65 62 79 6f 67 2e 63 6f | 6d 2f 69 6e 64 65 78 2e |ebyog.co|m/index.|
|00000ae0| 68 74 6d 6c 22 3e 77 65 | 6c 63 6f 6d 65 3c 2f 41 |html">we|lcome</A|
|00000af0| 3e 3c 2f 42 3e 3c 2f 46 | 4f 4e 54 3e 3c 2f 44 49 |></B></F|ONT></DI|
|00000b00| 56 3e 3c 2f 54 3d 0d 0a | 44 3e 0d 0a 20 20 20 20 |V></T=..|D>.. |
|00000b10| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 54 44 20 | | <TD |
|00000b20| 77 69 64 74 68 3d 33 44 | 22 34 25 22 20 62 67 43 |width=3D|"4%" bgC|
|00000b30| 6f 6c 6f 72 3d 33 44 23 | 33 33 33 33 36 36 3e 26 |olor=3D#|333366>&|
|00000b40| 6e 62 73 70 3b 3c 2f 54 | 44 3e 3c 2f 54 52 3e 0d |nbsp;</T|D></TR>.|
|00000b50| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c |. | <|
|00000b60| 54 52 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |TR>.. | |
|00000b70| 20 20 20 20 20 3c 54 44 | 20 76 41 6c 69 67 6e 3d | <TD| vAlign=|
|00000b80| 33 44 74 6f 70 20 77 69 | 64 74 68 3d 33 44 22 31 |3Dtop wi|dth=3D"1|
|00000b90| 35 25 22 20 62 67 43 6f | 6c 6f 72 3d 33 44 23 33 |5%" bgCo|lor=3D#3|
|00000ba0| 33 33 33 36 36 3e 0d 0a | 20 20 20 20 20 20 20 20 |33366>..| |
|00000bb0| 20 20 20 20 20 20 20 20 | 20 20 3c 44 49 56 20 61 | | <DIV a|
|00000bc0| 6c 69 67 6e 3d 33 44 72 | 69 67 68 74 3e 3c 46 4f |lign=3Dr|ight><FO|
|00000bd0| 4e 54 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |NT=20.. | |
|00000be0| 20 20 20 20 20 20 20 20 | 20 66 61 63 65 3d 33 44 | | face=3D|
|00000bf0| 22 56 65 72 64 61 6e 61 | 2c 20 41 72 69 61 6c 2c |"Verdana|, Arial,|
|00000c00| 20 48 65 6c 76 65 74 69 | 63 61 2c 20 73 61 6e 73 | Helveti|ca, sans|
|00000c10| 2d 73 65 72 69 66 22 20 | 3d 0d 0a 63 6f 6c 6f 72 |-serif" |=..color|
|00000c20| 3d 33 44 23 66 66 66 66 | 66 66 3d 32 30 0d 0a 20 |=3D#ffff|ff=20.. |
|00000c30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000c40| 20 73 69 7a 65 3d 33 44 | 32 3e 3c 2f 46 4f 4e 54 | size=3D|2></FONT|
|00000c50| 3e 3c 2f 44 49 56 3e 3c | 2f 54 44 3e 0d 0a 20 20 |></DIV><|/TD>.. |
|00000c60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 54 | | <T|
|00000c70| 44 20 76 41 6c 69 67 6e | 3d 33 44 63 65 6e 74 65 |D vAlign|=3Dcente|
|00000c80| 72 20 77 69 64 74 68 3d | 33 44 22 38 31 25 22 20 |r width=|3D"81%" |
|00000c90| 62 67 43 6f 6c 6f 72 3d | 33 44 23 66 66 66 66 66 |bgColor=|3D#fffff|
|00000ca0| 66 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |f>.. | |
|00000cb0| 20 20 20 20 20 20 3c 44 | 49 56 20 63 6c 61 73 73 | <D|IV class|
|00000cc0| 3d 33 44 6d 65 6e 75 69 | 74 65 6d 61 63 74 69 76 |=3Dmenui|temactiv|
|00000cd0| 65 20 3d 0d 0a 61 6c 69 | 67 6e 3d 33 44 72 69 67 |e =..ali|gn=3Drig|
|00000ce0| 68 74 3e 73 71 6c 79 6f | 67 3c 2f 44 49 56 3e 3c |ht>sqlyo|g</DIV><|
|00000cf0| 2f 54 44 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |/TD>.. | |
|00000d00| 20 20 20 20 20 20 3c 54 | 44 20 77 69 64 74 68 3d | <T|D width=|
|00000d10| 33 44 22 34 25 22 20 62 | 67 43 6f 6c 6f 72 3d 33 |3D"4%" b|gColor=3|
|00000d20| 44 23 66 66 66 66 66 66 | 3e 26 6e 62 73 70 3b 3c |D#ffffff|> <|
|00000d30| 2f 54 44 3e 3c 2f 54 52 | 3e 0d 0a 20 20 20 20 20 |/TD></TR|>.. |
|00000d40| 20 20 20 20 20 20 20 20 | 20 3c 54 52 3e 0d 0a 20 | | <TR>.. |
|00000d50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c | | <|
|00000d60| 54 44 20 76 41 6c 69 67 | 6e 3d 33 44 63 65 6e 74 |TD vAlig|n=3Dcent|
|00000d70| 65 72 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |er>.. | |
|00000d80| 20 20 20 20 20 20 20 3c | 44 49 56 20 61 6c 69 67 | <|DIV alig|
|00000d90| 6e 3d 33 44 72 69 67 68 | 74 3e 3c 46 4f 4e 54 3d |n=3Drigh|t><FONT=|
|00000da0| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00000db0| 20 20 20 20 20 20 66 61 | 63 65 3d 33 44 22 56 65 | fa|ce=3D"Ve|
|00000dc0| 72 64 61 6e 61 2c 20 41 | 72 69 61 6c 2c 20 48 65 |rdana, A|rial, He|
|00000dd0| 6c 76 65 74 69 63 61 2c | 20 73 61 6e 73 2d 73 65 |lvetica,| sans-se|
|00000de0| 72 69 66 22 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |rif"=20.|. |
|00000df0| 20 20 20 20 20 20 20 20 | 20 20 20 73 69 7a 65 3d | | size=|
|00000e00| 33 44 32 3e 3c 42 3e 3c | 2f 42 3e 3c 2f 46 4f 4e |3D2><B><|/B></FON|
|00000e10| 54 3e 3c 2f 44 49 56 3e | 3c 2f 54 44 3e 0d 0a 20 |T></DIV>|</TD>.. |
|00000e20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c | | <|
|00000e30| 54 44 20 76 41 6c 69 67 | 6e 3d 33 44 63 65 6e 74 |TD vAlig|n=3Dcent|
|00000e40| 65 72 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |er>.. | |
|00000e50| 20 20 20 20 20 20 20 3c | 44 49 56 20 61 6c 69 67 | <|DIV alig|
|00000e60| 6e 3d 33 44 72 69 67 68 | 74 3e 3c 46 4f 4e 54 3d |n=3Drigh|t><FONT=|
|00000e70| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00000e80| 20 20 20 20 20 20 66 61 | 63 65 3d 33 44 22 56 65 | fa|ce=3D"Ve|
|00000e90| 72 64 61 6e 61 2c 20 41 | 72 69 61 6c 2c 20 48 65 |rdana, A|rial, He|
|00000ea0| 6c 76 65 74 69 63 61 2c | 20 73 61 6e 73 2d 73 65 |lvetica,| sans-se|
|00000eb0| 72 69 66 22 20 3d 0d 0a | 73 69 7a 65 3d 33 44 32 |rif" =..|size=3D2|
|00000ec0| 3e 3c 42 3e 3c 46 4f 4e | 54 3d 32 30 0d 0a 20 20 |><B><FON|T=20.. |
|00000ed0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000ee0| 63 6c 61 73 73 3d 33 44 | 6d 65 6e 75 69 74 65 6d |class=3D|menuitem|
|00000ef0| 20 63 6f 6c 6f 72 3d 33 | 44 23 66 66 66 66 66 66 | color=3|D#ffffff|
|00000f00| 3e 3c 41 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |><A=20..| |
|00000f10| 20 20 20 20 20 20 20 20 | 20 20 68 72 65 66 3d 33 | | href=3|
|00000f20| 44 22 68 74 74 70 3a 2f | 2f 77 77 77 2e 77 65 62 |D"http:/|/www.web|
|00000f30| 79 6f 67 2e 63 6f 6d 2f | 63 6f 6e 74 61 63 74 75 |yog.com/|contactu|
|00000f40| 73 2e 68 74 6d 6c 22 3e | 63 6f 6e 74 61 63 74 20 |s.html">|contact |
|00000f50| 3d 0d 0a 75 73 3d 32 30 | 0d 0a 20 20 20 20 20 20 |=..us=20|.. |
|00000f60| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 2f 41 3e | | </A>|
|00000f70| 3c 2f 46 4f 4e 54 3e 3c | 2f 42 3e 3c 2f 46 4f 4e |</FONT><|/B></FON|
|00000f80| 54 3e 3c 2f 44 49 56 3e | 3c 2f 54 44 3e 0d 0a 20 |T></DIV>|</TD>.. |
|00000f90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c | | <|
|00000fa0| 54 44 20 77 69 64 74 68 | 3d 33 44 22 34 25 22 3e |TD width|=3D"4%">|
|00000fb0| 26 6e 62 73 70 3b 3c 2f | 54 44 3e 3c 2f 54 52 3e | </|TD></TR>|
|00000fc0| 3c 2f 54 42 4f 44 59 3e | 3c 2f 54 41 42 4c 45 3e |</TBODY>|</TABLE>|
|00000fd0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 50 |.. | <P|
|00000fe0| 20 61 6c 69 67 6e 3d 33 | 44 72 69 67 68 74 3e 3c | align=3|Dright><|
|00000ff0| 46 4f 4e 54 20 66 61 63 | 65 3d 33 44 22 56 65 72 |FONT fac|e=3D"Ver|
|00001000| 64 61 6e 61 2c 20 41 72 | 69 61 6c 2c 20 48 65 6c |dana, Ar|ial, Hel|
|00001010| 76 65 74 69 63 61 2c 20 | 3d 0d 0a 73 61 6e 73 2d |vetica, |=..sans-|
|00001020| 73 65 72 69 66 22 3d 32 | 30 0d 0a 20 20 20 20 20 |serif"=2|0.. |
|00001030| 20 20 20 20 20 20 20 63 | 6f 6c 6f 72 3d 33 44 23 | c|olor=3D#|
|00001040| 66 66 66 66 66 66 20 73 | 69 7a 65 3d 33 44 31 3e |ffffff s|ize=3D1>|
|00001050| 3c 42 3e 3c 2f 42 3e 3c | 2f 46 4f 4e 54 3e 3c 2f |<B></B><|/FONT></|
|00001060| 50 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |P>.. | |
|00001070| 3c 50 3e 26 6e 62 73 70 | 3b 3c 2f 50 3e 0d 0a 20 |<P> |;</P>.. |
|00001080| 20 20 20 20 20 20 20 20 | 20 20 20 3c 50 3e 26 6e | | <P>&n|
|00001090| 62 73 70 3b 3c 2f 50 3e | 3c 2f 54 44 3e 0d 0a 20 |bsp;</P>|</TD>.. |
|000010a0| 20 20 20 20 20 20 20 20 | 20 3c 54 44 20 76 41 6c | | <TD vAl|
|000010b0| 69 67 6e 3d 33 44 74 6f | 70 20 77 69 64 74 68 3d |ign=3Dto|p width=|
|000010c0| 33 44 22 36 30 25 22 3e | 0d 0a 20 20 20 20 20 20 |3D"60%">|.. |
|000010d0| 20 20 20 20 20 20 3c 54 | 41 42 4c 45 20 63 65 6c | <T|ABLE cel|
|000010e0| 6c 53 70 61 63 69 6e 67 | 3d 33 44 30 20 63 65 6c |lSpacing|=3D0 cel|
|000010f0| 6c 50 61 64 64 69 6e 67 | 3d 33 44 30 20 77 69 64 |lPadding|=3D0 wid|
|00001100| 74 68 3d 33 44 22 39 35 | 25 22 20 3d 0d 0a 61 6c |th=3D"95|%" =..al|
|00001110| 69 67 6e 3d 33 44 63 65 | 6e 74 65 72 3d 32 30 0d |ign=3Dce|nter=20.|
|00001120| 0a 62 6f 72 64 65 72 3d | 33 44 30 3e 0d 0a 20 20 |.border=|3D0>.. |
|00001130| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 54 42 4f | | <TBO|
|00001140| 44 59 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |DY>.. | |
|00001150| 20 20 20 3c 54 52 3e 0d | 0a 20 20 20 20 20 20 20 | <TR>.|. |
|00001160| 20 20 20 20 20 20 20 20 | 20 3c 54 44 20 63 6c 61 | | <TD cla|
|00001170| 73 73 3d 33 44 74 65 78 | 74 20 76 41 6c 69 67 6e |ss=3Dtex|t vAlign|
|00001180| 3d 33 44 74 6f 70 20 61 | 6c 69 67 6e 3d 33 44 6c |=3Dtop a|lign=3Dl|
|00001190| 65 66 74 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |eft>.. | |
|000011a0| 20 20 20 20 20 20 20 20 | 3c 50 3e 3c 42 52 3e 3c | |<P><BR><|
|000011b0| 2f 50 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |/P>.. | |
|000011c0| 20 20 20 20 20 20 20 3c | 50 20 61 6c 69 67 6e 3d | <|P align=|
|000011d0| 33 44 6c 65 66 74 3e 3c | 49 4d 47 20 68 65 69 67 |3Dleft><|IMG heig|
|000011e0| 68 74 3d 33 44 33 37 20 | 61 6c 74 3d 33 44 22 53 |ht=3D37 |alt=3D"S|
|000011f0| 51 4c 79 6f 67 20 46 41 | 51 22 3d 32 30 0d 0a 20 |QLyog FA|Q"=20.. |
|00001200| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001210| 20 73 72 63 3d 33 44 22 | 68 74 74 70 3a 2f 2f 77 | src=3D"|http://w|
|00001220| 77 77 2e 77 65 62 79 6f | 67 2e 63 6f 6d 2f 69 6d |ww.webyo|g.com/im|
|00001230| 61 67 65 73 2f 6d 79 73 | 71 6c 66 61 71 2e 67 69 |ages/mys|qlfaq.gi|
|00001240| 66 22 20 3d 0d 0a 77 69 | 64 74 68 3d 33 44 34 30 |f" =..wi|dth=3D40|
|00001250| 35 3e 3c 2f 50 3e 0d 0a | 20 20 20 20 20 20 20 20 |5></P>..| |
|00001260| 20 20 20 20 20 20 20 20 | 20 20 3c 50 20 63 6c 61 | | <P cla|
|00001270| 73 73 3d 33 44 66 61 71 | 68 65 61 64 65 72 20 61 |ss=3Dfaq|header a|
|00001280| 6c 69 67 6e 3d 33 44 63 | 65 6e 74 65 72 3e 3c 41 |lign=3Dc|enter><A|
|00001290| 20 3d 0d 0a 6e 61 6d 65 | 3d 33 44 67 65 6e 65 72 | =..name|=3Dgener|
|000012a0| 61 6c 3e 3c 2f 41 3e 47 | 65 6e 65 72 61 6c 3d 32 |al></A>G|eneral=2|
|000012b0| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|000012c0| 20 20 20 20 20 51 75 65 | 73 74 69 6f 6e 73 3c 2f | Que|stions</|
|000012d0| 50 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |P>.. | |
|000012e0| 20 20 20 20 20 20 3c 50 | 20 63 6c 61 73 73 3d 33 | <P| class=3|
|000012f0| 44 71 75 65 73 74 69 6f | 6e 3e 51 2e 20 57 68 61 |Dquestio|n>Q. Wha|
|00001300| 74 20 69 73 20 53 51 4c | 79 6f 67 20 3f 3c 2f 50 |t is SQL|yog ?</P|
|00001310| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00001320| 20 20 20 20 20 3c 50 20 | 63 6c 61 73 73 3d 33 44 | <P |class=3D|
|00001330| 61 6e 73 77 65 72 3e 41 | 2e 20 53 51 4c 79 6f 67 |answer>A|. SQLyog|
|00001340| 20 69 73 20 61 20 76 65 | 72 79 20 3c 42 3e 66 61 | is a ve|ry <B>fa|
|00001350| 73 74 3c 2f 42 3e 2c 3d | 32 30 0d 0a 20 20 20 20 |st</B>,=|20.. |
|00001360| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 42 | | <B|
|00001370| 3e 63 6f 6d 70 61 63 74 | 3c 2f 42 3e 20 61 6e 64 |>compact|</B> and|
|00001380| 20 3c 42 3e 73 69 6d 70 | 6c 65 3c 2f 42 3e 20 74 | <B>simp|le</B> t|
|00001390| 6f 20 75 73 65 20 47 55 | 49 20 74 6f 6f 6c 20 74 |o use GU|I tool t|
|000013a0| 6f 20 3d 0d 0a 6d 61 6e | 61 67 65 3d 32 30 0d 0a |o =..man|age=20..|
|000013b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000013c0| 20 20 79 6f 75 72 20 4d | 79 53 51 4c 20 73 65 72 | your M|ySQL ser|
|000013d0| 76 65 72 2e 20 54 68 65 | 20 73 6f 66 74 77 61 72 |ver. The| softwar|
|000013e0| 65 20 69 73 20 70 72 69 | 6d 61 72 69 6c 79 20 66 |e is pri|marily f|
|000013f0| 6f 72 20 74 68 65 20 3d | 0d 0a 75 73 65 72 73 20 |or the =|..users |
|00001400| 77 68 6f 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |who=20..| |
|00001410| 20 20 20 20 20 20 20 20 | 20 20 77 6f 72 6b 20 77 | | work w|
|00001420| 69 74 68 20 4d 79 53 51 | 4c 20 64 75 72 69 6e 67 |ith MySQ|L during|
|00001430| 20 74 68 65 20 64 65 76 | 65 6c 6f 70 6d 65 6e 74 | the dev|elopment|
|00001440| 20 70 72 6f 63 65 73 73 | 2e 20 3c 2f 50 3e 0d 0a | process|. </P>..|
|00001450| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001460| 20 20 3c 50 20 63 6c 61 | 73 73 3d 33 44 61 6e 73 | <P cla|ss=3Dans|
|00001470| 77 65 72 3e 3c 49 4d 47 | 20 68 65 69 67 68 74 3d |wer><IMG| height=|
|00001480| 33 44 37 30 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |3D70=20.|. |
|00001490| 20 20 20 20 20 20 20 20 | 20 20 20 73 72 63 3d 33 | | src=3|
|000014a0| 44 22 68 74 74 70 3a 2f | 2f 77 77 77 2e 77 65 62 |D"http:/|/www.web|
|000014b0| 79 6f 67 2e 63 6f 6d 2f | 69 6d 61 67 65 73 2f 6f |yog.com/|images/o|
|000014c0| 63 63 61 6d 2e 67 69 66 | 22 20 3d 0d 0a 77 69 64 |ccam.gif|" =..wid|
|000014d0| 74 68 3d 33 44 35 31 3d | 32 30 0d 0a 20 20 20 20 |th=3D51=|20.. |
|000014e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 61 6c | | al|
|000014f0| 69 67 6e 3d 33 44 6c 65 | 66 74 3e 4c 69 6b 65 20 |ign=3Dle|ft>Like |
|00001500| 4d 79 53 51 4c 2c 20 53 | 51 4c 79 6f 67 20 61 6c |MySQL, S|QLyog al|
|00001510| 73 6f 20 66 6f 6c 6c 6f | 77 73 20 74 68 65 20 3d |so follo|ws the =|
|00001520| 0d 0a 70 72 69 6e 63 69 | 70 6c 65 20 6f 66 3d 32 |..princi|ple of=2|
|00001530| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00001540| 20 20 20 20 20 74 68 65 | 20 31 34 74 68 20 63 65 | the| 14th ce|
|00001550| 6e 74 75 72 79 20 70 68 | 69 6c 6f 73 6f 70 68 65 |ntury ph|ilosophe|
|00001560| 72 20 6d 6f 6e 6b 20 4f | 63 63 61 6d 2e 20 57 65 |r monk O|ccam. We|
|00001570| 20 66 6f 6c 6c 6f 77 20 | 68 69 73 20 3d 0d 0a 72 | follow |his =..r|
|00001580| 75 6c 65 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ule=20..| |
|00001590| 20 20 20 20 20 20 20 20 | 20 20 6b 6e 6f 77 6e 20 | | known |
|000015a0| 61 73 20 4f 63 63 61 6d | 3d 39 32 73 20 72 61 7a |as Occam|=92s raz|
|000015b0| 6f 72 3a 20 3c 42 3e 4e | 6f 20 63 6f 6d 70 6c 65 |or: <B>N|o comple|
|000015c0| 78 69 74 79 20 62 65 79 | 6f 6e 64 20 77 68 61 74 |xity bey|ond what|
|000015d0| 20 3d 0d 0a 69 73 3d 32 | 30 0d 0a 20 20 20 20 20 | =..is=2|0.. |
|000015e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 6e 65 63 | | nec|
|000015f0| 65 73 73 61 72 79 2e 3c | 2f 42 3e 3c 2f 50 3e 0d |essary.<|/B></P>.|
|00001600| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00001610| 20 20 20 3c 50 20 63 6c | 61 73 73 3d 33 44 61 6e | <P cl|ass=3Dan|
|00001620| 73 77 65 72 3e 26 6e 62 | 73 70 3b 3c 2f 50 3e 0d |swer>&nb|sp;</P>.|
|00001630| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00001640| 20 20 20 3c 50 20 63 6c | 61 73 73 3d 33 44 61 6e | <P cl|ass=3Dan|
|00001650| 73 77 65 72 3e 3c 42 3e | 51 2e 20 57 68 69 63 68 |swer><B>|Q. Which|
|00001660| 20 69 73 20 74 68 65 20 | 6c 61 74 65 73 74 20 76 | is the |latest v|
|00001670| 65 72 73 69 6f 6e 20 6f | 66 20 3d 0d 0a 53 51 4c |ersion o|f =..SQL|
|00001680| 79 6f 67 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |yog=20..| |
|00001690| 20 20 20 20 20 20 20 20 | 20 20 3f 3c 2f 42 3e 3c | | ?</B><|
|000016a0| 2f 50 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |/P>.. | |
|000016b0| 20 20 20 20 20 20 20 3c | 50 20 63 6c 61 73 73 3d | <|P class=|
|000016c0| 33 44 61 6e 73 77 65 72 | 3e 41 2e 20 54 68 65 20 |3Danswer|>A. The |
|000016d0| 6c 61 74 65 73 74 20 76 | 65 72 73 69 6f 6e 20 6f |latest v|ersion o|
|000016e0| 66 20 53 51 4c 79 6f 67 | 20 69 73 20 3d 0d 0a 32 |f SQLyog| is =..2|
|000016f0| 2e 35 31 2c 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |.51,=20.|. |
|00001700| 20 20 20 20 20 20 20 20 | 20 20 20 72 65 6c 65 61 | | relea|
|00001710| 73 65 64 20 69 6e 20 74 | 68 65 20 74 68 69 72 64 |sed in t|he third|
|00001720| 20 77 65 65 6b 20 6f 66 | 20 4e 6f 76 65 6d 62 65 | week of| Novembe|
|00001730| 72 20 32 30 30 32 2e 20 | 49 74 20 3d 0d 0a 63 6f |r 2002. |It =..co|
|00001740| 6e 74 61 69 6e 73 20 73 | 6f 3d 32 30 0d 0a 20 20 |ntains s|o=20.. |
|00001750| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001760| 6d 61 6e 79 20 6e 65 77 | 20 66 65 61 74 75 72 65 |many new| feature|
|00001770| 73 20 74 68 61 74 20 69 | 74 20 69 73 20 61 20 6d |s that i|t is a m|
|00001780| 75 73 74 20 75 70 67 72 | 61 64 65 20 66 6f 72 20 |ust upgr|ade for |
|00001790| 61 6c 6c 20 3d 0d 0a 66 | 72 6f 6d 3d 32 30 0d 0a |all =..f|rom=20..|
|000017a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000017b0| 20 20 53 51 4c 79 6f 67 | 20 31 2e 37 31 2e 3c 2f | SQLyog| 1.71.</|
|000017c0| 50 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |P>.. | |
|000017d0| 20 20 20 20 20 20 3c 50 | 20 63 6c 61 73 73 3d 33 | <P| class=3|
|000017e0| 44 61 6e 73 77 65 72 3e | 3c 53 50 41 4e 20 63 6c |Danswer>|<SPAN cl|
|000017f0| 61 73 73 3d 33 44 71 75 | 65 73 74 69 6f 6e 3e 51 |ass=3Dqu|estion>Q|
|00001800| 2e 20 57 68 65 72 65 20 | 63 61 6e 20 3d 0d 0a 49 |. Where |can =..I|
|00001810| 20 6f 62 74 61 69 6e 3d | 32 30 0d 0a 20 20 20 20 | obtain=|20.. |
|00001820| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 53 51 | | SQ|
|00001830| 4c 79 6f 67 20 3f 3c 2f | 53 50 41 4e 3e 3c 2f 50 |Lyog ?</|SPAN></P|
|00001840| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00001850| 20 20 20 20 20 3c 48 33 | 20 63 6c 61 73 73 3d 33 | <H3| class=3|
|00001860| 44 61 6e 73 77 65 72 3e | 41 2e 20 59 6f 75 20 63 |Danswer>|A. You c|
|00001870| 61 6e 20 64 6f 77 6e 6c | 6f 61 64 20 61 20 63 6f |an downl|oad a co|
|00001880| 70 79 20 6f 66 20 3d 0d | 0a 53 51 4c 79 6f 67 20 |py of =.|.SQLyog |
|00001890| 66 72 6f 6d 20 74 68 65 | 3d 32 30 0d 0a 20 20 20 |from the|=20.. |
|000018a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c | | <|
|000018b0| 41 20 3d 0d 0a 68 72 65 | 66 3d 33 44 22 68 74 74 |A =..hre|f=3D"htt|
|000018c0| 70 3a 2f 2f 77 77 77 2e | 77 65 62 79 6f 67 2e 63 |p://www.|webyog.c|
|000018d0| 6f 6d 2f 73 71 6c 79 6f | 67 2f 64 6f 77 6e 6c 6f |om/sqlyo|g/downlo|
|000018e0| 61 64 2e 68 74 6d 6c 22 | 3e 53 51 4c 79 6f 67 3d |ad.html"|>SQLyog=|
|000018f0| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00001900| 20 20 20 20 20 20 44 6f | 77 6e 6c 6f 61 64 20 50 | Do|wnload P|
|00001910| 61 67 65 3c 2f 41 3e 2e | 20 4a 75 73 74 20 70 72 |age</A>.| Just pr|
|00001920| 6f 76 69 64 65 20 75 73 | 20 77 69 74 68 20 79 6f |ovide us| with yo|
|00001930| 75 72 20 6e 61 6d 65 20 | 61 6e 64 20 3d 0d 0a 65 |ur name |and =..e|
|00001940| 2d 6d 61 69 6c 3d 32 30 | 0d 0a 20 20 20 20 20 20 |-mail=20|.. |
|00001950| 20 20 20 20 20 20 20 20 | 20 20 20 20 61 64 64 72 | | addr|
|00001960| 65 73 73 20 73 6f 20 74 | 68 61 74 20 77 65 20 63 |ess so t|hat we c|
|00001970| 61 6e 20 69 6e 66 6f 72 | 6d 20 79 6f 75 20 61 62 |an infor|m you ab|
|00001980| 6f 75 74 20 66 75 74 75 | 72 65 20 3d 0d 0a 72 65 |out futu|re =..re|
|00001990| 6c 65 61 73 65 73 20 6f | 66 3d 32 30 0d 0a 20 20 |leases o|f=20.. |
|000019a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000019b0| 53 51 4c 79 6f 67 2e 3c | 2f 48 33 3e 0d 0a 20 20 |SQLyog.<|/H3>.. |
|000019c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000019d0| 3c 50 20 63 6c 61 73 73 | 3d 33 44 71 75 65 73 74 |<P class|=3Dquest|
|000019e0| 69 6f 6e 3e 51 2e 20 49 | 73 20 74 68 65 72 65 20 |ion>Q. I|s there |
|000019f0| 61 6e 79 20 6d 61 69 6c | 69 6e 67 20 6c 69 73 74 |any mail|ing list|
|00001a00| 20 66 6f 72 20 3d 0d 0a | 53 51 4c 79 6f 67 3d 32 | for =..|SQLyog=2|
|00001a10| 30 0d 0a 3f 3c 2f 50 3e | 0d 0a 20 20 20 20 20 20 |0..?</P>|.. |
|00001a20| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 50 20 63 | | <P c|
|00001a30| 6c 61 73 73 3d 33 44 61 | 6e 73 77 65 72 3e 41 2e |lass=3Da|nswer>A.|
|00001a40| 20 41 73 20 6f 66 20 6e | 6f 77 20 77 65 20 64 6f | As of n|ow we do|
|00001a50| 6e 27 74 20 68 61 76 65 | 20 61 20 6d 61 69 6c 69 |n't have| a maili|
|00001a60| 6e 67 20 3d 0d 0a 6c 69 | 73 74 20 66 6f 72 3d 32 |ng =..li|st for=2|
|00001a70| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00001a80| 20 20 20 20 20 53 51 4c | 79 6f 67 2e 20 59 6f 75 | SQL|yog. You|
|00001a90| 20 63 61 6e 20 63 6f 6d | 6d 75 6e 69 63 61 74 65 | can com|municate|
|00001aa0| 20 64 69 72 65 63 74 6c | 79 20 74 6f 20 75 73 20 | directl|y to us |
|00001ab0| 72 65 67 61 72 64 69 6e | 67 20 3d 0d 0a 61 6e 79 |regardin|g =..any|
|00001ac0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00001ad0| 20 20 20 20 20 20 20 70 | 72 6f 62 6c 65 6d 73 2f | p|roblems/|
|00001ae0| 71 75 65 72 69 65 73 2f | 73 75 67 67 65 73 74 69 |queries/|suggesti|
|00001af0| 6f 6e 73 20 61 62 6f 75 | 74 20 53 51 4c 79 6f 67 |ons abou|t SQLyog|
|00001b00| 20 75 73 69 6e 67 20 74 | 68 69 73 20 3d 0d 0a 3c | using t|his =..<|
|00001b10| 41 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |A=20.. | |
|00001b20| 20 20 20 20 20 20 20 20 | 3d 0d 0a 68 72 65 66 3d | |=..href=|
|00001b30| 33 44 22 68 74 74 70 3a | 2f 2f 77 77 77 2e 77 65 |3D"http:|//www.we|
|00001b40| 62 79 6f 67 2e 63 6f 6d | 2f 73 71 6c 79 6f 67 2f |byog.com|/sqlyog/|
|00001b50| 62 75 67 73 73 75 67 67 | 2e 68 74 6d 6c 22 3e 66 |bugssugg|.html">f|
|00001b60| 6f 72 6d 3c 2f 41 3e 2e | 3c 2f 50 3e 0d 0a 20 20 |orm</A>.|</P>.. |
|00001b70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001b80| 3c 50 20 63 6c 61 73 73 | 3d 33 44 71 75 65 73 74 |<P class|=3Dquest|
|00001b90| 69 6f 6e 3e 51 2e 20 49 | 20 74 68 69 6e 6b 20 49 |ion>Q. I| think I|
|00001ba0| 20 66 6f 75 6e 64 20 61 | 20 62 75 67 2c 20 77 68 | found a| bug, wh|
|00001bb0| 6f 6d 20 3d 0d 0a 73 68 | 6f 75 6c 64 20 49 20 74 |om =..sh|ould I t|
|00001bc0| 65 6c 6c 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ell=20..| |
|00001bd0| 20 20 20 20 20 20 20 20 | 20 20 3f 3c 2f 50 3e 0d | | ?</P>.|
|00001be0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00001bf0| 20 20 20 3c 50 20 63 6c | 61 73 73 3d 33 44 61 6e | <P cl|ass=3Dan|
|00001c00| 73 77 65 72 3e 41 2e 20 | 4d 61 6b 65 20 73 75 72 |swer>A. |Make sur|
|00001c10| 65 20 74 68 61 74 20 79 | 6f 75 20 61 72 65 20 75 |e that y|ou are u|
|00001c20| 73 69 6e 67 20 74 68 65 | 20 3d 0d 0a 6c 61 74 65 |sing the| =..late|
|00001c30| 73 74 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |st=20.. | |
|00001c40| 20 20 20 20 20 20 20 20 | 20 76 65 72 73 69 6f 6e | | version|
|00001c50| 20 6f 66 20 53 51 4c 79 | 6f 67 20 62 79 20 63 68 | of SQLy|og by ch|
|00001c60| 65 63 6b 69 6e 67 20 69 | 74 20 61 74 20 74 68 65 |ecking i|t at the|
|00001c70| 20 53 51 4c 79 6f 67 20 | 3d 0d 0a 77 65 62 73 69 | SQLyog |=..websi|
|00001c80| 74 65 2e 20 49 66 20 79 | 6f 75 3d 32 30 0d 0a 20 |te. If y|ou=20.. |
|00001c90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001ca0| 20 61 72 65 20 73 75 72 | 65 20 74 68 61 74 20 79 | are sur|e that y|
|00001cb0| 6f 75 20 68 61 76 65 20 | 74 68 65 20 6c 61 74 65 |ou have |the late|
|00001cc0| 73 74 20 6f 6e 65 20 74 | 68 65 6e 20 70 6c 65 61 |st one t|hen plea|
|00001cd0| 73 65 20 75 73 65 20 3d | 0d 0a 74 68 65 20 42 75 |se use =|..the Bu|
|00001ce0| 67 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |g=20.. | |
|00001cf0| 20 20 20 20 20 20 20 20 | 52 65 70 6f 72 74 69 6e | |Reportin|
|00001d00| 67 20 66 6f 72 6d 20 61 | 74 20 3c 41 3d 32 30 0d |g form a|t <A=20.|
|00001d10| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00001d20| 20 20 20 3d 0d 0a 68 72 | 65 66 3d 33 44 22 68 74 | =..hr|ef=3D"ht|
|00001d30| 74 70 3a 2f 2f 77 77 77 | 2e 77 65 62 79 6f 67 2e |tp://www|.webyog.|
|00001d40| 63 6f 6d 2f 73 71 6c 79 | 6f 67 2f 62 75 67 73 73 |com/sqly|og/bugss|
|00001d50| 75 67 67 2e 68 74 6d 6c | 22 3e 42 75 67 73 3d 32 |ugg.html|">Bugs=2|
|00001d60| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00001d70| 20 20 20 20 20 50 61 67 | 65 3c 2f 41 3e 20 2e 20 | Pag|e</A> . |
|00001d80| 57 65 20 77 69 6c 6c 20 | 72 65 70 6c 79 20 79 6f |We will |reply yo|
|00001d90| 75 20 62 61 63 6b 20 61 | 62 6f 75 74 20 74 68 65 |u back a|bout the|
|00001da0| 20 73 74 61 74 75 73 20 | 6f 66 20 3d 0d 0a 74 68 | status |of =..th|
|00001db0| 65 20 62 75 67 2e 3d 32 | 30 0d 0a 20 20 20 20 20 |e bug.=2|0.. |
|00001dc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 49 66 20 | | If |
|00001dd0| 69 74 73 20 61 20 6b 6e | 6f 77 6e 20 62 75 67 20 |its a kn|own bug |
|00001de0| 74 68 65 6e 20 77 65 20 | 77 69 6c 6c 20 62 65 20 |then we |will be |
|00001df0| 61 62 6c 65 20 74 6f 20 | 72 65 70 6c 79 20 62 61 |able to |reply ba|
|00001e00| 63 6b 20 3d 0d 0a 77 69 | 74 68 20 74 68 65 3d 32 |ck =..wi|th the=2|
|00001e10| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00001e20| 20 20 20 20 20 73 6f 6c | 75 74 69 6f 6e 20 6f 72 | sol|ution or|
|00001e30| 20 6d 61 79 62 65 20 79 | 6f 75 20 68 61 76 65 20 | maybe y|ou have |
|00001e40| 74 6f 20 77 61 69 74 20 | 66 6f 72 20 74 68 65 20 |to wait |for the |
|00001e50| 6e 65 78 74 20 3d 0d 0a | 72 65 6c 65 61 73 65 2e |next =..|release.|
|00001e60| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00001e70| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|00001e80| 3d 33 44 61 6e 73 77 65 | 72 3e 3c 53 50 41 4e 20 |=3Danswe|r><SPAN |
|00001e90| 63 6c 61 73 73 3d 33 44 | 71 75 65 73 74 69 6f 6e |class=3D|question|
|00001ea0| 3e 51 2e 20 44 6f 20 49 | 20 6e 65 65 64 20 3d 0d |>Q. Do I| need =.|
|00001eb0| 0a 74 6f 20 72 65 61 64 | 20 61 6e 79 3d 32 30 0d |.to read| any=20.|
|00001ec0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00001ed0| 20 20 20 64 6f 63 75 6d | 65 6e 74 61 74 69 6f 6e | docum|entation|
|00001ee0| 20 74 6f 20 70 75 74 20 | 53 51 4c 79 6f 67 20 69 | to put |SQLyog i|
|00001ef0| 6e 74 6f 20 75 73 65 20 | 3f 3c 2f 53 50 41 4e 3e |nto use |?</SPAN>|
|00001f00| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00001f10| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|00001f20| 3d 33 44 61 6e 73 77 65 | 72 3e 41 2e 20 41 62 73 |=3Danswe|r>A. Abs|
|00001f30| 6f 6c 75 74 65 6c 79 20 | 6e 6f 74 2e 20 53 51 4c |olutely |not. SQL|
|00001f40| 79 6f 67 20 68 61 73 20 | 67 6f 74 20 61 6e 20 3d |yog has |got an =|
|00001f50| 0d 0a 69 6e 74 75 69 74 | 69 76 65 3d 32 30 0d 0a |..intuit|ive=20..|
|00001f60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001f70| 20 20 69 6e 74 65 72 66 | 61 63 65 2c 20 79 6f 75 | interf|ace, you|
|00001f80| 20 77 69 6c 6c 20 62 65 | 20 75 70 20 61 6e 64 20 | will be| up and |
|00001f90| 72 75 6e 6e 69 6e 67 20 | 77 69 74 68 69 6e 20 6d |running |within m|
|00001fa0| 6f 6d 65 6e 74 73 2e 20 | 3d 0d 0a 53 70 65 63 69 |oments. |=..Speci|
|00001fb0| 61 6c 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |al=20.. | |
|00001fc0| 20 20 20 20 20 20 20 20 | 20 63 61 72 65 20 68 61 | | care ha|
|00001fd0| 73 20 62 65 65 6e 20 74 | 61 6b 65 6e 20 74 6f 20 |s been t|aken to |
|00001fe0| 70 72 6f 76 69 64 65 20 | 61 20 6e 6f 6e 2d 63 6c |provide |a non-cl|
|00001ff0| 75 74 74 65 72 65 64 20 | 61 6e 64 20 3d 0d 0a 65 |uttered |and =..e|
|00002000| 78 74 72 65 6d 65 6c 79 | 3d 32 30 0d 0a 20 20 20 |xtremely|=20.. |
|00002010| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 73 | | s|
|00002020| 69 6d 70 6c 65 20 69 6e | 74 65 72 66 61 63 65 2e |imple in|terface.|
|00002030| 20 3c 2f 50 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 | </P>.. | |
|00002040| 20 20 20 20 20 20 20 20 | 20 3c 50 20 63 6c 61 73 | | <P clas|
|00002050| 73 3d 33 44 66 61 71 68 | 65 61 64 65 72 20 61 6c |s=3Dfaqh|eader al|
|00002060| 69 67 6e 3d 33 44 63 65 | 6e 74 65 72 3e 3c 41 3d |ign=3Dce|nter><A=|
|00002070| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00002080| 20 20 20 20 20 20 6e 61 | 6d 65 3d 33 44 74 65 63 | na|me=3Dtec|
|00002090| 68 6e 6f 6c 6f 67 79 3e | 3c 2f 41 3e 54 65 63 68 |hnology>|</A>Tech|
|000020a0| 6e 6f 6c 6f 67 79 3c 2f | 50 3e 0d 0a 20 20 20 20 |nology</|P>.. |
|000020b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 50 | | <P|
|000020c0| 3e 3c 53 50 41 4e 20 63 | 6c 61 73 73 3d 33 44 71 |><SPAN c|lass=3Dq|
|000020d0| 75 65 73 74 69 6f 6e 3e | 51 2e 20 49 20 61 6d 20 |uestion>|Q. I am |
|000020e0| 6e 65 77 20 74 6f 20 4d | 79 53 51 4c 2f 53 51 4c |new to M|ySQL/SQL|
|000020f0| 20 3f 20 3d 0d 0a 43 61 | 6e 20 53 51 4c 79 6f 67 | ? =..Ca|n SQLyog|
|00002100| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00002110| 20 20 20 20 20 20 20 68 | 65 6c 70 20 6d 65 20 69 | h|elp me i|
|00002120| 6e 20 6c 65 61 72 6e 69 | 6e 67 20 4d 79 53 51 4c |n learni|ng MySQL|
|00002130| 20 3f 3c 2f 53 50 41 4e | 3e 3c 2f 50 3e 0d 0a 20 | ?</SPAN|></P>.. |
|00002140| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002150| 20 3c 50 20 63 6c 61 73 | 73 3d 33 44 61 6e 73 77 | <P clas|s=3Dansw|
|00002160| 65 72 3e 41 2e 20 59 65 | 73 21 20 49 66 20 79 6f |er>A. Ye|s! If yo|
|00002170| 75 20 61 72 65 20 6e 65 | 77 20 74 6f 20 4d 79 53 |u are ne|w to MyS|
|00002180| 51 4c 20 6f 72 20 3d 0d | 0a 53 51 4c 20 74 68 65 |QL or =.|.SQL the|
|00002190| 6e 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |n=20.. | |
|000021a0| 20 20 20 20 20 20 20 20 | 53 51 4c 79 6f 67 20 69 | |SQLyog i|
|000021b0| 73 20 74 68 65 20 69 64 | 65 61 6c 20 74 6f 6f 6c |s the id|eal tool|
|000021c0| 20 74 6f 20 67 65 74 20 | 79 6f 75 20 73 74 61 72 | to get |you star|
|000021d0| 74 65 64 2e 20 41 70 61 | 72 74 20 3d 0d 0a 66 72 |ted. Apa|rt =..fr|
|000021e0| 6f 6d 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |om=20.. | |
|000021f0| 20 20 20 20 20 20 20 20 | 20 70 72 6f 76 69 64 69 | | providi|
|00002200| 6e 67 20 74 65 6d 70 6c | 61 74 65 73 20 6f 66 20 |ng templ|ates of |
|00002210| 61 6c 6c 20 53 51 4c 20 | 73 74 61 74 65 6d 65 6e |all SQL |statemen|
|00002220| 74 73 20 73 75 70 70 6f | 72 74 65 64 20 62 79 20 |ts suppo|rted by |
|00002230| 3d 0d 0a 4d 79 53 51 4c | 2c 3d 32 30 0d 0a 20 20 |=..MySQL|,=20.. |
|00002240| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002250| 71 75 65 72 69 65 73 20 | 67 65 6e 65 72 61 74 65 |queries |generate|
|00002260| 64 20 62 79 20 53 51 4c | 79 6f 67 20 74 6f 20 70 |d by SQL|yog to p|
|00002270| 65 72 66 6f 72 6d 20 76 | 61 72 69 6f 75 73 20 74 |erform v|arious t|
|00002280| 61 73 6b 73 20 3d 0d 0a | 61 72 65 20 61 6c 73 6f |asks =..|are also|
|00002290| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|000022a0| 20 20 20 20 20 20 20 6c | 6f 67 67 65 64 2e 20 3c | l|ogged. <|
|000022b0| 41 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |A=20.. | |
|000022c0| 20 20 20 20 20 20 20 20 | 3d 0d 0a 68 72 65 66 3d | |=..href=|
|000022d0| 33 44 22 68 74 74 70 3a | 2f 2f 77 77 77 2e 77 65 |3D"http:|//www.we|
|000022e0| 62 79 6f 67 2e 63 6f 6d | 2f 73 71 6c 79 6f 67 2f |byog.com|/sqlyog/|
|000022f0| 73 71 6c 79 6f 67 69 6d | 61 67 65 73 2f 69 6d 61 |sqlyogim|ages/ima|
|00002300| 67 65 38 2e 67 69 66 22 | 3e 63 6c 69 63 6b 3d 32 |ge8.gif"|>click=2|
|00002310| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00002320| 20 20 20 20 20 68 65 72 | 65 20 74 6f 20 73 65 65 | her|e to see|
|00002330| 20 61 20 73 63 72 65 65 | 6e 73 68 6f 74 20 6f 66 | a scree|nshot of|
|00002340| 20 71 75 65 72 79 20 70 | 72 6f 66 69 6c 65 72 3c | query p|rofiler<|
|00002350| 2f 41 3e 3c 2f 50 3e 0d | 0a 20 20 20 20 20 20 20 |/A></P>.|. |
|00002360| 20 20 20 20 20 20 20 20 | 20 20 20 3c 50 20 63 6c | | <P cl|
|00002370| 61 73 73 3d 33 44 71 75 | 65 73 74 69 6f 6e 3e 3c |ass=3Dqu|estion><|
|00002380| 2f 50 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |/P>.. | |
|00002390| 20 20 20 20 20 20 20 3c | 50 3e 3c 53 50 41 4e 20 | <|P><SPAN |
|000023a0| 63 6c 61 73 73 3d 33 44 | 71 75 65 73 74 69 6f 6e |class=3D|question|
|000023b0| 3e 51 2e 20 4f 6e 20 77 | 68 61 74 20 70 6c 61 74 |>Q. On w|hat plat|
|000023c0| 66 6f 72 6d 20 53 51 4c | 79 6f 67 20 3d 0d 0a 68 |form SQL|yog =..h|
|000023d0| 61 73 20 62 65 65 6e 3d | 32 30 0d 0a 20 20 20 20 |as been=|20.. |
|000023e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 64 65 | | de|
|000023f0| 76 65 6c 6f 70 65 64 20 | 3f 3c 2f 53 50 41 4e 3e |veloped |?</SPAN>|
|00002400| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00002410| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|00002420| 3d 33 44 61 6e 73 77 65 | 72 3e 41 2e 20 53 51 4c |=3Danswe|r>A. SQL|
|00002430| 79 6f 67 20 68 61 73 20 | 62 65 65 6e 20 77 72 69 |yog has |been wri|
|00002440| 74 74 65 6e 20 75 73 69 | 6e 67 20 3d 0d 0a 43 2f |tten usi|ng =..C/|
|00002450| 43 2b 2b 2f 57 69 6e 33 | 32 3d 32 30 0d 0a 20 20 |C++/Win3|2=20.. |
|00002460| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002470| 41 50 49 73 2e 20 49 74 | 20 61 63 63 65 73 73 65 |APIs. It| accesse|
|00002480| 73 20 4d 79 53 51 4c 20 | 75 73 69 6e 67 20 74 68 |s MySQL |using th|
|00002490| 65 20 6e 61 74 69 76 65 | 20 4d 79 53 51 4c 20 43 |e native| MySQL C|
|000024a0| 20 41 50 49 20 3d 0d 0a | 61 6e 64 20 64 6f 65 73 | API =..|and does|
|000024b0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|000024c0| 20 20 20 20 20 20 20 6e | 6f 74 20 75 73 65 73 20 | n|ot uses |
|000024d0| 61 6e 79 20 77 72 61 70 | 70 65 72 20 63 6c 61 73 |any wrap|per clas|
|000024e0| 73 65 73 2e 20 54 68 69 | 73 20 6d 61 6b 65 73 20 |ses. Thi|s makes |
|000024f0| 53 51 4c 79 6f 67 20 3d | 0d 0a 70 72 6f 62 61 62 |SQLyog =|..probab|
|00002500| 6c 79 20 74 68 65 3d 32 | 30 0d 0a 20 20 20 20 20 |ly the=2|0.. |
|00002510| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 66 61 73 | | fas|
|00002520| 74 65 73 74 20 66 72 6f | 6e 74 20 65 6e 64 20 74 |test fro|nt end t|
|00002530| 6f 20 4d 79 53 51 4c 20 | 69 6e 20 74 68 65 20 6d |o MySQL |in the m|
|00002540| 61 72 6b 65 74 2e 20 4d | 6f 72 65 6f 76 65 72 20 |arket. M|oreover |
|00002550| 74 68 65 20 3d 0d 0a 73 | 69 7a 65 20 6f 66 3d 32 |the =..s|ize of=2|
|00002560| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00002570| 20 20 20 20 20 53 51 4c | 79 6f 67 20 62 69 6e 61 | SQL|yog bina|
|00002580| 72 79 20 69 73 20 6f 6e | 65 20 6f 66 20 74 68 65 |ry is on|e of the|
|00002590| 20 73 6d 61 6c 6c 65 73 | 74 2e 20 28 20 26 6c 74 | smalles|t. ( <|
|000025a0| 3b 20 33 34 38 20 4b 42 | 20 3d 0d 0a 29 3c 2f 50 |; 348 KB| =..)</P|
|000025b0| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|000025c0| 20 20 20 20 20 3c 50 20 | 63 6c 61 73 73 3d 33 44 | <P |class=3D|
|000025d0| 71 75 65 73 74 69 6f 6e | 3e 51 2e 20 44 6f 20 79 |question|>Q. Do y|
|000025e0| 6f 75 20 68 61 76 65 20 | 61 6e 79 20 70 6c 61 6e |ou have |any plan|
|000025f0| 73 20 74 6f 20 3d 0d 0a | 72 65 6c 65 61 73 65 20 |s to =..|release |
|00002600| 61 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |a=20.. | |
|00002610| 20 20 20 20 20 20 20 20 | 4c 69 6e 75 78 2f 55 6e | |Linux/Un|
|00002620| 69 78 20 76 65 72 73 69 | 6f 6e 20 6f 66 20 53 51 |ix versi|on of SQ|
|00002630| 4c 79 6f 67 20 3f 3c 2f | 50 3e 0d 0a 20 20 20 20 |Lyog ?</|P>.. |
|00002640| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 50 | | <P|
|00002650| 20 63 6c 61 73 73 3d 33 | 44 61 6e 73 77 65 72 3e | class=3|Danswer>|
|00002660| 41 2e 20 59 65 73 2e 20 | 57 65 20 6d 61 79 20 6d |A. Yes. |We may m|
|00002670| 61 6b 65 20 53 51 4c 79 | 6f 67 20 63 72 6f 73 73 |ake SQLy|og cross|
|00002680| 20 3d 0d 0a 70 6c 61 74 | 66 6f 72 6d 20 69 6e 3d | =..plat|form in=|
|00002690| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|000026a0| 20 20 20 20 20 20 6f 75 | 72 20 6e 65 78 74 20 6d | ou|r next m|
|000026b0| 61 6a 6f 72 20 72 65 6c | 65 61 73 65 2e 3c 2f 50 |ajor rel|ease.</P|
|000026c0| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|000026d0| 20 20 20 20 20 3c 50 20 | 63 6c 61 73 73 3d 33 44 | <P |class=3D|
|000026e0| 66 61 71 68 65 61 64 65 | 72 20 61 6c 69 67 6e 3d |faqheade|r align=|
|000026f0| 33 44 63 65 6e 74 65 72 | 3e 3c 41 20 3d 0d 0a 6e |3Dcenter|><A =..n|
|00002700| 61 6d 65 3d 33 44 64 65 | 76 65 6c 6f 70 65 72 3e |ame=3Dde|veloper>|
|00002710| 3c 2f 41 3e 46 6f 72 3d | 32 30 0d 0a 20 20 20 20 |</A>For=|20.. |
|00002720| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 44 65 | | De|
|00002730| 76 65 6c 6f 70 65 72 73 | 3c 2f 50 3e 0d 0a 20 20 |velopers|</P>.. |
|00002740| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002750| 3c 50 20 63 6c 61 73 73 | 3d 33 44 74 65 78 74 20 |<P class|=3Dtext |
|00002760| 61 6c 69 67 6e 3d 33 44 | 6c 65 66 74 3e 3c 53 50 |align=3D|left><SP|
|00002770| 41 4e 20 63 6c 61 73 73 | 3d 33 44 71 75 65 73 74 |AN class|=3Dquest|
|00002780| 69 6f 6e 3e 51 2e 20 3d | 0d 0a 49 20 77 6f 75 6c |ion>Q. =|..I woul|
|00002790| 64 20 6c 69 6b 65 3d 32 | 30 0d 0a 20 20 20 20 20 |d like=2|0.. |
|000027a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 74 6f 20 | | to |
|000027b0| 67 65 74 20 6d 79 20 72 | 65 73 75 6c 74 73 20 69 |get my r|esults i|
|000027c0| 6e 20 74 65 78 74 20 66 | 6f 72 6d 20 73 6f 20 74 |n text f|orm so t|
|000027d0| 68 61 74 20 49 20 63 61 | 6e 20 73 65 61 72 63 68 |hat I ca|n search|
|000027e0| 20 3d 0d 0a 66 6f 72 20 | 61 3d 32 30 0d 0a 20 20 | =..for |a=20.. |
|000027f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002800| 73 74 72 69 6e 67 20 6f | 72 20 63 6f 70 79 20 70 |string o|r copy p|
|00002810| 6f 72 74 69 6f 6e 73 20 | 6f 66 20 72 65 73 75 6c |ortions |of resul|
|00002820| 74 73 65 74 20 61 73 20 | 74 65 78 74 20 74 6f 20 |tset as |text to |
|00002830| 74 68 65 20 3d 0d 0a 63 | 6c 69 70 62 6f 61 72 64 |the =..c|lipboard|
|00002840| 2e 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |.=20.. | |
|00002850| 20 20 20 20 20 20 20 20 | 49 73 20 69 74 20 70 6f | |Is it po|
|00002860| 73 73 69 62 6c 65 20 3f | 3c 2f 53 50 41 4e 3e 3c |ssible ?|</SPAN><|
|00002870| 2f 50 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |/P>.. | |
|00002880| 20 20 20 20 20 20 20 3c | 50 20 63 6c 61 73 73 3d | <|P class=|
|00002890| 33 44 74 65 78 74 20 61 | 6c 69 67 6e 3d 33 44 6c |3Dtext a|lign=3Dl|
|000028a0| 65 66 74 3e 41 2e 20 53 | 51 4c 79 6f 67 20 61 6c |eft>A. S|QLyog al|
|000028b0| 6c 6f 77 73 20 79 6f 75 | 20 74 6f 20 3d 0d 0a 76 |lows you| to =..v|
|000028c0| 69 65 77 20 79 6f 75 72 | 3d 32 30 0d 0a 20 20 20 |iew your|=20.. |
|000028d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 72 | | r|
|000028e0| 65 73 75 6c 74 73 65 74 | 20 69 6e 20 47 72 69 64 |esultset| in Grid|
|000028f0| 20 61 73 20 77 65 6c 6c | 20 61 73 20 54 65 78 74 | as well| as Text|
|00002900| 20 4d 6f 64 65 2e 20 59 | 6f 75 20 63 61 6e 20 74 | Mode. Y|ou can t|
|00002910| 6f 67 67 6c 65 20 3d 0d | 0a 62 65 74 77 65 65 6e |oggle =.|.between|
|00002920| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00002930| 20 20 20 20 20 20 20 74 | 68 65 20 6d 6f 64 65 73 | t|he modes|
|00002940| 20 62 79 20 70 72 65 73 | 73 69 6e 67 20 43 74 72 | by pres|sing Ctr|
|00002950| 6c 2b 4c 2e 20 49 6e 20 | 74 68 65 20 54 65 78 74 |l+L. In |the Text|
|00002960| 20 6d 6f 64 65 20 73 65 | 74 20 3d 0d 0a 79 6f 75 | mode se|t =..you|
|00002970| 72 20 63 75 72 73 6f 72 | 3d 32 30 0d 0a 20 20 20 |r cursor|=20.. |
|00002980| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 69 | | i|
|00002990| 6e 20 74 68 65 20 72 65 | 73 75 6c 74 20 70 61 6e |n the re|sult pan|
|000029a0| 65 20 61 6e 64 20 70 72 | 65 73 73 20 43 74 72 6c |e and pr|ess Ctrl|
|000029b0| 2b 46 20 74 6f 20 73 65 | 61 72 63 68 20 66 6f 72 |+F to se|arch for|
|000029c0| 20 61 20 3d 0d 0a 73 74 | 72 69 6e 67 2e 20 3c 41 | a =..st|ring. <A|
|000029d0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|000029e0| 20 20 20 20 20 20 20 3d | 0d 0a 68 72 65 66 3d 33 | =|..href=3|
|000029f0| 44 22 68 74 74 70 3a 2f | 2f 77 77 77 2e 77 65 62 |D"http:/|/www.web|
|00002a00| 79 6f 67 2e 63 6f 6d 2f | 73 71 6c 79 6f 67 2f 73 |yog.com/|sqlyog/s|
|00002a10| 71 6c 79 6f 67 69 6d 61 | 67 65 73 2f 69 6d 61 67 |qlyogima|ges/imag|
|00002a20| 65 34 2e 67 69 66 22 3e | 63 6c 69 63 6b 3d 32 30 |e4.gif">|click=20|
|00002a30| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00002a40| 20 20 20 20 68 65 72 65 | 20 74 6f 20 73 65 65 20 | here| to see |
|00002a50| 61 20 73 63 72 65 65 6e | 73 68 6f 74 20 6f 66 20 |a screen|shot of |
|00002a60| 72 65 73 75 6c 74 20 69 | 6e 20 74 65 78 74 3c 2f |result i|n text</|
|00002a70| 41 3e 3c 2f 50 3e 0d 0a | 20 20 20 20 20 20 20 20 |A></P>..| |
|00002a80| 20 20 20 20 20 20 20 20 | 20 20 3c 50 20 63 6c 61 | | <P cla|
|00002a90| 73 73 3d 33 44 74 65 78 | 74 20 61 6c 69 67 6e 3d |ss=3Dtex|t align=|
|00002aa0| 33 44 6c 65 66 74 3e 3c | 53 50 41 4e 20 63 6c 61 |3Dleft><|SPAN cla|
|00002ab0| 73 73 3d 33 44 71 75 65 | 73 74 69 6f 6e 3e 51 2e |ss=3Dque|stion>Q.|
|00002ac0| 20 3d 0d 0a 49 20 68 61 | 76 65 20 61 20 76 65 72 | =..I ha|ve a ver|
|00002ad0| 79 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |y=20.. | |
|00002ae0| 20 20 20 20 20 20 20 20 | 62 69 67 20 71 75 65 72 | |big quer|
|00002af0| 79 20 61 6e 64 20 49 20 | 77 6f 75 6c 64 20 6c 69 |y and I |would li|
|00002b00| 6b 65 20 74 6f 20 75 73 | 65 20 74 68 65 20 63 6f |ke to us|e the co|
|00002b10| 6d 70 6c 65 74 65 20 73 | 63 72 65 65 6e 20 3d 0d |mplete s|creen =.|
|00002b20| 0a 61 72 65 61 20 66 6f | 72 3d 32 30 0d 0a 20 20 |.area fo|r=20.. |
|00002b30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002b40| 65 64 69 74 69 6e 67 2e | 20 48 6f 77 20 63 61 6e |editing.| How can|
|00002b50| 20 49 20 64 6f 20 74 68 | 61 74 20 3f 3c 2f 53 50 | I do th|at ?</SP|
|00002b60| 41 4e 3e 3c 2f 50 3e 0d | 0a 20 20 20 20 20 20 20 |AN></P>.|. |
|00002b70| 20 20 20 20 20 20 20 20 | 20 20 20 3c 50 20 63 6c | | <P cl|
|00002b80| 61 73 73 3d 33 44 74 65 | 78 74 20 61 6c 69 67 6e |ass=3Dte|xt align|
|00002b90| 3d 33 44 6c 65 66 74 3e | 41 2e 20 53 51 4c 79 6f |=3Dleft>|A. SQLyo|
|00002ba0| 67 20 61 6c 6c 6f 77 73 | 20 79 6f 75 20 74 6f 20 |g allows| you to |
|00002bb0| 3d 0d 0a 73 68 6f 77 2f | 68 69 64 65 3d 32 30 0d |=..show/|hide=20.|
|00002bc0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00002bd0| 20 20 20 62 6f 74 68 20 | 74 68 65 20 4f 62 6a 65 | both |the Obje|
|00002be0| 63 74 20 42 72 6f 77 73 | 65 72 20 61 6e 64 20 74 |ct Brows|er and t|
|00002bf0| 68 65 20 52 65 73 75 6c | 74 20 50 61 6e 65 2e 20 |he Resul|t Pane. |
|00002c00| 54 68 65 72 65 66 6f 72 | 65 20 3d 0d 0a 62 79 3d |Therefor|e =..by=|
|00002c10| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00002c20| 20 20 20 20 20 20 68 69 | 64 69 6e 67 20 62 6f 74 | hi|ding bot|
|00002c30| 68 20 6f 66 20 74 68 65 | 6d 20 79 6f 75 20 63 61 |h of the|m you ca|
|00002c40| 6e 20 75 73 65 20 74 68 | 65 20 63 6f 6d 70 6c 65 |n use th|e comple|
|00002c50| 74 65 20 73 70 61 63 65 | 20 69 6e 20 3d 0d 0a 65 |te space| in =..e|
|00002c60| 64 69 74 69 6e 67 3d 32 | 30 0d 0a 20 20 20 20 20 |diting=2|0.. |
|00002c70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 79 6f 75 | | you|
|00002c80| 72 20 71 75 65 72 79 2e | 20 59 6f 75 20 63 61 6e |r query.| You can|
|00002c90| 20 73 68 6f 77 2f 68 69 | 64 65 20 4f 62 6a 65 63 | show/hi|de Objec|
|00002ca0| 74 20 42 72 6f 77 73 65 | 72 20 62 79 20 3d 0d 0a |t Browse|r by =..|
|00002cb0| 70 72 65 73 73 69 6e 67 | 3d 32 30 0d 0a 20 20 20 |pressing|=20.. |
|00002cc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 43 | | C|
|00002cd0| 74 72 6c 2b 31 20 61 6e | 64 20 73 68 6f 77 2f 68 |trl+1 an|d show/h|
|00002ce0| 69 64 65 20 52 65 73 75 | 6c 74 20 50 61 6e 65 20 |ide Resu|lt Pane |
|00002cf0| 62 79 20 70 72 65 73 73 | 69 6e 67 20 3d 0d 0a 43 |by press|ing =..C|
|00002d00| 74 72 6c 2b 32 2e 3c 2f | 50 3e 0d 0a 20 20 20 20 |trl+2.</|P>.. |
|00002d10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 50 | | <P|
|00002d20| 20 63 6c 61 73 73 3d 33 | 44 74 65 78 74 20 61 6c | class=3|Dtext al|
|00002d30| 69 67 6e 3d 33 44 6c 65 | 66 74 3e 3c 53 50 41 4e |ign=3Dle|ft><SPAN|
|00002d40| 20 63 6c 61 73 73 3d 33 | 44 71 75 65 73 74 69 6f | class=3|Dquestio|
|00002d50| 6e 3e 51 2e 20 3d 0d 0a | 49 20 68 61 76 65 20 61 |n>Q. =..|I have a|
|00002d60| 20 68 75 67 65 3d 32 30 | 0d 0a 20 20 20 20 20 20 | huge=20|.. |
|00002d70| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 51 4c 20 | | SQL |
|00002d80| 62 61 74 63 68 20 66 69 | 6c 65 20 28 20 69 6e 20 |batch fi|le ( in |
|00002d90| 67 69 67 61 62 79 74 65 | 73 21 20 29 2e 20 48 6f |gigabyte|s! ). Ho|
|00002da0| 77 20 63 61 6e 20 49 20 | 65 78 65 63 75 74 65 20 |w can I |execute |
|00002db0| 69 74 20 3d 0d 0a 75 73 | 69 6e 67 3d 32 30 0d 0a |it =..us|ing=20..|
|00002dc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002dd0| 20 20 53 51 4c 79 6f 67 | 20 3f 3c 2f 53 50 41 4e | SQLyog| ?</SPAN|
|00002de0| 3e 3c 2f 50 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 |></P>.. | |
|00002df0| 20 20 20 20 20 20 20 20 | 20 3c 50 20 63 6c 61 73 | | <P clas|
|00002e00| 73 3d 33 44 74 65 78 74 | 20 61 6c 69 67 6e 3d 33 |s=3Dtext| align=3|
|00002e10| 44 6c 65 66 74 3e 41 2e | 20 53 51 4c 79 6f 67 20 |Dleft>A.| SQLyog |
|00002e20| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 3d 0d |allows y|ou to =.|
|00002e30| 0a 65 78 65 63 75 74 65 | 20 61 3d 32 30 0d 0a 20 |.execute| a=20.. |
|00002e40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e50| 20 62 61 74 63 68 20 66 | 69 6c 65 20 6f 66 20 61 | batch f|ile of a|
|00002e60| 6e 79 20 73 69 7a 65 20 | 28 79 65 73 2e 2e 2e 2e |ny size |(yes....|
|00002e70| 61 6e 79 20 73 69 7a 65 | 20 2d 20 6c 69 6d 69 74 |any size| - limit|
|00002e80| 65 64 20 62 79 20 3d 0d | 0a 74 68 65 20 4f 53 29 |ed by =.|.the OS)|
|00002e90| 2e 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |.=20.. | |
|00002ea0| 20 20 20 20 20 20 20 20 | 53 65 6c 65 63 74 20 54 | |Select T|
|00002eb0| 6f 6f 6c 73 20 2d 26 67 | 74 3b 20 45 78 65 63 75 |ools -&g|t; Execu|
|00002ec0| 74 65 20 42 61 74 63 68 | 20 46 69 6c 65 20 28 43 |te Batch| File (C|
|00002ed0| 74 72 6c 2b 53 68 69 66 | 74 2b 51 29 2e 20 3d 0d |trl+Shif|t+Q). =.|
|00002ee0| 0a 53 65 6c 65 63 74 3d | 32 30 0d 0a 20 20 20 20 |.Select=|20.. |
|00002ef0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 74 68 | | th|
|00002f00| 65 20 66 69 6c 65 20 61 | 6e 64 20 70 72 65 73 73 |e file a|nd press|
|00002f10| 20 45 78 65 63 75 74 65 | 2e 20 49 66 20 53 51 4c | Execute|. If SQL|
|00002f20| 79 6f 67 20 65 6e 63 6f | 75 6e 74 65 72 73 20 61 |yog enco|unters a|
|00002f30| 6e 20 3d 0d 0a 65 72 72 | 6f 72 20 69 74 3d 32 30 |n =..err|or it=20|
|00002f40| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00002f50| 20 20 20 20 73 74 6f 70 | 73 20 66 75 72 74 68 65 | stop|s furthe|
|00002f60| 72 20 65 78 65 63 75 74 | 69 6f 6e 20 61 6e 64 20 |r execut|ion and |
|00002f70| 6c 6f 67 73 20 74 68 65 | 20 71 75 65 72 79 20 61 |logs the| query a|
|00002f80| 73 20 77 65 6c 6c 20 61 | 73 20 3d 0d 0a 74 68 65 |s well a|s =..the|
|00002f90| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00002fa0| 20 20 20 20 20 20 20 65 | 72 72 6f 72 20 6d 65 73 | e|rror mes|
|00002fb0| 73 61 67 65 20 69 6e 20 | 73 71 6c 79 6f 67 2e 65 |sage in |sqlyog.e|
|00002fc0| 72 72 20 6c 6f 63 61 74 | 65 64 20 69 6e 20 74 68 |rr locat|ed in th|
|00002fd0| 65 20 53 51 4c 79 6f 67 | 20 3d 0d 0a 69 6e 73 74 |e SQLyog| =..inst|
|00002fe0| 61 6c 6c 61 74 69 6f 6e | 3d 32 30 0d 0a 20 20 20 |allation|=20.. |
|00002ff0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 66 | | f|
|00003000| 6f 6c 64 65 72 2e 20 3c | 41 3d 32 30 0d 0a 20 20 |older. <|A=20.. |
|00003010| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003020| 3d 0d 0a 68 72 65 66 3d | 33 44 22 68 74 74 70 3a |=..href=|3D"http:|
|00003030| 2f 2f 77 77 77 2e 77 65 | 62 79 6f 67 2e 63 6f 6d |//www.we|byog.com|
|00003040| 2f 73 71 6c 79 6f 67 2f | 73 71 6c 79 6f 67 69 6d |/sqlyog/|sqlyogim|
|00003050| 61 67 65 73 2f 69 6d 61 | 67 65 32 37 2e 67 69 66 |ages/ima|ge27.gif|
|00003060| 22 3e 63 6c 69 63 6b 3d | 32 30 0d 0a 20 20 20 20 |">click=|20.. |
|00003070| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 68 65 | | he|
|00003080| 72 65 20 74 6f 20 73 65 | 65 20 61 20 73 63 72 65 |re to se|e a scre|
|00003090| 65 6e 73 68 6f 74 20 6f | 66 20 65 78 65 63 75 74 |enshot o|f execut|
|000030a0| 65 20 62 61 74 63 68 20 | 66 69 6c 65 20 64 69 61 |e batch |file dia|
|000030b0| 6c 6f 67 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |log=20..| |
|000030c0| 20 20 20 20 20 20 20 20 | 20 20 62 6f 78 3c 2f 41 | | box</A|
|000030d0| 3e 3c 2f 50 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 |></P>.. | |
|000030e0| 20 20 20 20 20 20 20 20 | 20 3c 50 20 63 6c 61 73 | | <P clas|
|000030f0| 73 3d 33 44 74 65 78 74 | 20 61 6c 69 67 6e 3d 33 |s=3Dtext| align=3|
|00003100| 44 6c 65 66 74 3e 3c 53 | 50 41 4e 20 63 6c 61 73 |Dleft><S|PAN clas|
|00003110| 73 3d 33 44 71 75 65 73 | 74 69 6f 6e 3e 51 2e 20 |s=3Dques|tion>Q. |
|00003120| 3d 0d 0a 49 20 77 61 6e | 74 20 74 6f 3d 32 30 0d |=..I wan|t to=20.|
|00003130| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00003140| 20 20 20 65 78 70 6f 72 | 74 20 74 68 65 20 72 65 | expor|t the re|
|00003150| 73 75 6c 74 73 65 74 20 | 69 6e 20 61 20 66 69 6c |sultset |in a fil|
|00003160| 65 20 6f 6e 20 74 68 65 | 20 63 6c 69 65 6e 74 2e |e on the| client.|
|00003170| 20 54 68 65 20 3d 0d 0a | 4d 79 53 51 4c 3d 32 30 | The =..|MySQL=20|
|00003180| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00003190| 20 20 20 20 63 6f 6d 6d | 61 6e 64 20 53 45 4c 45 | comm|and SELE|
|000031a0| 43 54 20 49 4e 54 4f 20 | 4f 55 54 46 49 4c 45 2e |CT INTO |OUTFILE.|
|000031b0| 2e 2e 20 63 72 65 61 74 | 65 73 20 61 20 66 69 6c |.. creat|es a fil|
|000031c0| 65 20 6f 6e 20 74 68 65 | 20 3d 0d 0a 73 65 72 76 |e on the| =..serv|
|000031d0| 65 72 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |er=20.. | |
|000031e0| 20 20 20 20 20 20 20 20 | 20 6f 6e 6c 79 2e 20 43 | | only. C|
|000031f0| 61 6e 20 53 51 4c 79 6f | 67 20 63 72 65 61 74 65 |an SQLyo|g create|
|00003200| 20 61 20 66 69 6c 65 20 | 6f 6e 20 74 68 65 20 63 | a file |on the c|
|00003210| 6c 69 65 6e 74 20 3d 0d | 0a 3f 3c 2f 53 50 41 4e |lient =.|.?</SPAN|
|00003220| 3e 3c 2f 50 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 |></P>.. | |
|00003230| 20 20 20 20 20 20 20 20 | 20 3c 50 20 63 6c 61 73 | | <P clas|
|00003240| 73 3d 33 44 74 65 78 74 | 20 61 6c 69 67 6e 3d 33 |s=3Dtext| align=3|
|00003250| 44 6c 65 66 74 3e 41 2e | 20 41 66 74 65 72 20 79 |Dleft>A.| After y|
|00003260| 6f 75 20 65 78 65 63 75 | 74 65 20 61 20 3d 0d 0a |ou execu|te a =..|
|00003270| 71 75 65 72 79 2e 20 53 | 65 6c 65 63 74 3d 32 30 |query. S|elect=20|
|00003280| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00003290| 20 20 20 20 74 68 65 20 | 74 61 62 20 6f 66 20 74 | the |tab of t|
|000032a0| 68 65 20 70 61 72 74 69 | 63 75 6c 61 72 20 72 65 |he parti|cular re|
|000032b0| 73 75 6c 74 73 65 74 20 | 77 68 69 63 68 20 79 6f |sultset |which yo|
|000032c0| 75 20 77 61 6e 74 20 74 | 6f 20 3d 0d 0a 65 78 70 |u want t|o =..exp|
|000032d0| 6f 72 74 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ort=20..| |
|000032e0| 20 20 20 20 20 20 20 20 | 20 20 61 6e 64 20 72 69 | | and ri|
|000032f0| 67 68 74 20 63 6c 69 63 | 6b 20 6f 6e 20 69 74 20 |ght clic|k on it |
|00003300| 28 20 43 74 72 6c 2b 53 | 68 69 66 74 2b 45 20 29 |( Ctrl+S|hift+E )|
|00003310| 20 61 6e 64 20 73 65 6c | 65 63 74 20 3d 0d 0a 45 | and sel|ect =..E|
|00003320| 78 70 6f 72 74 3d 32 30 | 0d 0a 20 20 20 20 20 20 |xport=20|.. |
|00003330| 20 20 20 20 20 20 20 20 | 20 20 20 20 52 65 73 75 | | Resu|
|00003340| 6c 74 73 65 74 2e 20 53 | 51 4c 79 6f 67 20 61 6c |ltset. S|QLyog al|
|00003350| 6c 6f 77 73 20 79 6f 75 | 20 65 78 70 6f 72 74 20 |lows you| export |
|00003360| 74 68 65 20 72 65 73 75 | 6c 74 20 73 65 74 20 69 |the resu|lt set i|
|00003370| 6e 20 3d 0d 0a 58 4d 4c | 2c 3d 32 30 0d 0a 20 20 |n =..XML|,=20.. |
|00003380| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003390| 48 54 4d 4c 2c 20 43 53 | 56 20 28 20 66 69 78 65 |HTML, CS|V ( fixe|
|000033a0| 64 20 6c 65 6e 67 74 68 | 20 61 6e 64 20 76 61 72 |d length| and var|
|000033b0| 69 61 62 6c 65 20 6c 65 | 6e 67 74 68 20 29 2e 20 |iable le|ngth ). |
|000033c0| 3c 41 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |<A=20.. | |
|000033d0| 20 20 20 20 20 20 20 20 | 20 3d 0d 0a 68 72 65 66 | | =..href|
|000033e0| 3d 33 44 22 68 74 74 70 | 3a 2f 2f 77 77 77 2e 77 |=3D"http|://www.w|
|000033f0| 65 62 79 6f 67 2e 63 6f | 6d 2f 73 71 6c 79 6f 67 |ebyog.co|m/sqlyog|
|00003400| 2f 73 71 6c 79 6f 67 69 | 6d 61 67 65 73 2f 69 6d |/sqlyogi|mages/im|
|00003410| 61 67 65 33 33 2e 67 69 | 66 22 3e 63 6c 69 63 6b |age33.gi|f">click|
|00003420| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00003430| 20 20 20 20 20 20 20 68 | 65 72 65 20 74 6f 20 73 | h|ere to s|
|00003440| 65 65 20 61 20 73 63 72 | 65 65 6e 73 68 6f 74 20 |ee a scr|eenshot |
|00003450| 6f 66 20 65 78 70 6f 72 | 74 20 72 65 73 75 6c 74 |of expor|t result|
|00003460| 73 65 74 20 64 69 61 6c | 6f 67 3d 32 30 0d 0a 62 |set dial|og=20..b|
|00003470| 6f 78 3c 2f 41 3e 3c 2f | 50 3e 0d 0a 20 20 20 20 |ox</A></|P>.. |
|00003480| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 50 | | <P|
|00003490| 20 63 6c 61 73 73 3d 33 | 44 74 65 78 74 20 61 6c | class=3|Dtext al|
|000034a0| 69 67 6e 3d 33 44 6c 65 | 66 74 3e 3c 53 50 41 4e |ign=3Dle|ft><SPAN|
|000034b0| 20 63 6c 61 73 73 3d 33 | 44 71 75 65 73 74 69 6f | class=3|Dquestio|
|000034c0| 6e 3e 51 2e 20 3d 0d 0a | 43 61 6e 20 49 20 65 78 |n>Q. =..|Can I ex|
|000034d0| 70 6f 72 74 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |port=20.|. |
|000034e0| 20 20 20 20 20 20 20 20 | 20 20 20 64 61 74 61 20 | | data |
|000034f0| 69 6e 20 66 69 78 65 64 | 20 6c 65 6e 67 74 68 20 |in fixed| length |
|00003500| 66 6f 72 6d 61 74 20 75 | 73 69 6e 67 20 53 51 4c |format u|sing SQL|
|00003510| 79 6f 67 20 3f 3c 2f 53 | 50 41 4e 3e 3c 2f 50 3e |yog ?</S|PAN></P>|
|00003520| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00003530| 20 20 20 20 3c 50 20 63 | 6c 61 73 73 3d 33 44 74 | <P c|lass=3Dt|
|00003540| 65 78 74 20 61 6c 69 67 | 6e 3d 33 44 6c 65 66 74 |ext alig|n=3Dleft|
|00003550| 3e 41 2e 20 59 65 73 21 | 20 41 70 61 72 74 20 66 |>A. Yes!| Apart f|
|00003560| 72 6f 6d 20 74 68 65 20 | 3d 0d 0a 75 73 75 61 6c |rom the |=..usual|
|00003570| 20 76 61 72 69 61 62 6c | 65 3d 32 30 0d 0a 20 20 | variabl|e=20.. |
|00003580| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003590| 6c 65 6e 67 74 68 20 66 | 6f 72 6d 61 74 20 53 51 |length f|ormat SQ|
|000035a0| 4c 79 6f 67 20 63 61 6e | 20 65 78 70 6f 72 74 2f |Lyog can| export/|
|000035b0| 69 6d 70 6f 72 74 20 66 | 69 78 65 64 20 77 69 64 |import f|ixed wid|
|000035c0| 74 68 20 3d 0d 0a 66 6f | 72 6d 61 74 3d 32 30 0d |th =..fo|rmat=20.|
|000035d0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000035e0| 20 20 20 64 61 74 61 2e | 20 53 65 6c 65 63 74 20 | data.| Select |
|000035f0| 74 68 65 20 74 61 62 6c | 65 20 69 6e 20 74 68 65 |the tabl|e in the|
|00003600| 20 4f 62 6a 65 63 74 20 | 42 72 6f 77 73 65 72 20 | Object |Browser |
|00003610| 66 6f 72 20 77 68 69 63 | 68 20 3d 0d 0a 79 6f 75 |for whic|h =..you|
|00003620| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00003630| 20 20 20 20 20 20 20 77 | 61 6e 74 20 74 6f 20 65 | w|ant to e|
|00003640| 78 70 6f 72 74 20 74 68 | 65 20 64 61 74 61 20 61 |xport th|e data a|
|00003650| 6e 64 20 73 65 6c 65 63 | 74 20 54 61 62 6c 65 20 |nd selec|t Table |
|00003660| 2d 26 67 74 3b 20 45 78 | 70 6f 72 74 20 3d 0d 0a |-> Ex|port =..|
|00003670| 54 61 62 6c 65 3d 32 30 | 0d 0a 20 20 20 20 20 20 |Table=20|.. |
|00003680| 20 20 20 20 20 20 20 20 | 20 20 20 20 44 61 74 61 | | Data|
|00003690| 20 41 73 20 43 53 56 20 | 28 20 43 74 72 6c 2b 41 | As CSV |( Ctrl+A|
|000036a0| 6c 74 2b 43 20 29 2e 20 | 53 65 6c 65 63 74 20 46 |lt+C ). |Select F|
|000036b0| 69 78 65 64 20 4c 65 6e | 67 74 68 20 69 6e 20 74 |ixed Len|gth in t|
|000036c0| 68 65 20 3d 0d 0a 0d 0a | 20 20 20 20 20 20 20 20 |he =....| |
|000036d0| 20 20 20 20 20 20 20 20 | 20 20 65 73 63 61 70 69 | | escapi|
|000036e0| 6e 67 20 63 68 61 72 61 | 63 74 65 72 73 20 64 69 |ng chara|cters di|
|000036f0| 61 6c 6f 67 20 62 6f 78 | 20 28 79 6f 75 20 67 65 |alog box| (you ge|
|00003700| 74 20 74 68 69 73 20 62 | 79 20 3d 0d 0a 70 72 65 |t this b|y =..pre|
|00003710| 73 73 69 6e 67 20 74 68 | 65 3d 32 30 0d 0a 20 20 |ssing th|e=20.. |
|00003720| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003730| 43 68 61 6e 67 65 2e 2e | 2e 20 62 75 74 74 6f 6e |Change..|. button|
|00003740| 29 2e 20 3c 41 3d 32 30 | 0d 0a 20 20 20 20 20 20 |). <A=20|.. |
|00003750| 20 20 20 20 20 20 20 20 | 20 20 20 20 3d 0d 0a 68 | | =..h|
|00003760| 72 65 66 3d 33 44 22 68 | 74 74 70 3a 2f 2f 77 77 |ref=3D"h|ttp://ww|
|00003770| 77 2e 77 65 62 79 6f 67 | 2e 63 6f 6d 2f 73 71 6c |w.webyog|.com/sql|
|00003780| 79 6f 67 2f 73 71 6c 79 | 6f 67 69 6d 61 67 65 73 |yog/sqly|ogimages|
|00003790| 2f 69 6d 61 67 65 31 37 | 2e 67 69 66 22 3e 63 6c |/image17|.gif">cl|
|000037a0| 69 63 6b 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ick=20..| |
|000037b0| 20 20 20 20 20 20 20 20 | 20 20 68 65 72 65 20 74 | | here t|
|000037c0| 6f 20 73 65 65 20 61 20 | 73 63 72 65 65 6e 73 68 |o see a |screensh|
|000037d0| 6f 74 20 6f 66 20 65 78 | 70 6f 72 74 20 74 61 62 |ot of ex|port tab|
|000037e0| 6c 65 20 64 61 74 61 20 | 69 6e 20 3d 0d 0a 43 53 |le data |in =..CS|
|000037f0| 56 3c 2f 41 3e 3c 2f 50 | 3e 0d 0a 20 20 20 20 20 |V</A></P|>.. |
|00003800| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 50 20 | | <P |
|00003810| 63 6c 61 73 73 3d 33 44 | 74 65 78 74 20 61 6c 69 |class=3D|text ali|
|00003820| 67 6e 3d 33 44 6c 65 66 | 74 3e 3c 53 50 41 4e 20 |gn=3Dlef|t><SPAN |
|00003830| 63 6c 61 73 73 3d 33 44 | 71 75 65 73 74 69 6f 6e |class=3D|question|
|00003840| 3e 51 2e 20 3d 0d 0a 49 | 20 77 61 6e 74 20 74 6f |>Q. =..I| want to|
|00003850| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00003860| 20 20 20 20 20 20 20 63 | 72 65 61 74 65 20 61 20 | c|reate a |
|00003870| 64 6f 63 75 6d 65 6e 74 | 61 74 69 6f 6e 20 6f 66 |document|ation of|
|00003880| 20 6d 79 20 64 61 74 61 | 62 61 73 65 20 3f 20 44 | my data|base ? D|
|00003890| 6f 65 73 20 53 51 4c 79 | 6f 67 20 3d 0d 0a 70 72 |oes SQLy|og =..pr|
|000038a0| 6f 76 69 64 65 3d 32 30 | 0d 0a 20 20 20 20 20 20 |ovide=20|.. |
|000038b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 61 6e 79 20 | | any |
|000038c0| 74 6f 6f 6c 20 66 6f 72 | 20 63 72 65 61 74 69 6e |tool for| creatin|
|000038d0| 67 20 61 20 73 63 68 65 | 6d 61 20 64 6f 63 75 6d |g a sche|ma docum|
|000038e0| 65 6e 74 20 3f 3c 2f 53 | 50 41 4e 3e 3c 2f 50 3e |ent ?</S|PAN></P>|
|000038f0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00003900| 20 20 20 20 3c 50 20 63 | 6c 61 73 73 3d 33 44 74 | <P c|lass=3Dt|
|00003910| 65 78 74 20 61 6c 69 67 | 6e 3d 33 44 6c 65 66 74 |ext alig|n=3Dleft|
|00003920| 3e 41 2e 20 59 65 73 21 | 20 53 51 4c 79 6f 67 20 |>A. Yes!| SQLyog |
|00003930| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 3d 0d 0a 74 6f |allows y|ou =..to|
|00003940| 20 62 75 69 6c 64 20 61 | 3d 32 30 0d 0a 20 20 20 | build a|=20.. |
|00003950| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 70 | | p|
|00003960| 72 69 6e 74 65 72 20 66 | 72 69 65 6e 64 6c 79 20 |rinter f|riendly |
|00003970| 73 63 68 65 6d 61 20 64 | 6f 63 75 6d 65 6e 74 20 |schema d|ocument |
|00003980| 69 6e 20 48 54 4d 4c 2e | 20 59 6f 75 20 63 61 6e |in HTML.| You can|
|00003990| 20 3d 0d 0a 65 69 74 68 | 65 72 3d 32 30 0d 0a 20 | =..eith|er=20.. |
|000039a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000039b0| 20 73 65 6c 65 63 74 20 | 74 68 65 20 65 6e 74 69 | select |the enti|
|000039c0| 72 65 20 64 61 74 61 62 | 61 73 65 20 6f 72 20 73 |re datab|ase or s|
|000039d0| 70 65 63 69 66 69 63 20 | 74 61 62 6c 65 73 2e 20 |pecific |tables. |
|000039e0| 53 65 6c 65 63 74 20 3d | 0d 0a 74 68 65 3d 32 30 |Select =|..the=20|
|000039f0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00003a00| 20 20 20 20 64 61 74 61 | 62 61 73 65 20 2d 26 67 | data|base -&g|
|00003a10| 74 3b 20 72 69 67 68 74 | 20 63 6c 69 63 6b 20 2d |t; right| click -|
|00003a20| 26 67 74 3b 20 43 72 65 | 61 74 65 20 53 63 68 65 |> Cre|ate Sche|
|00003a30| 6d 61 20 46 6f 72 20 54 | 68 65 20 3d 0d 0a 0d 0a |ma For T|he =....|
|00003a40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003a50| 20 20 44 61 74 61 62 61 | 73 65 20 69 6e 20 48 54 | Databa|se in HT|
|00003a60| 4d 4c 20 28 43 74 72 6c | 2b 73 68 69 66 74 2b 53 |ML (Ctrl|+shift+S|
|00003a70| 29 2e 20 3c 41 3d 32 30 | 0d 0a 20 20 20 20 20 20 |). <A=20|.. |
|00003a80| 20 20 20 20 20 20 20 20 | 20 20 20 20 3d 0d 0a 68 | | =..h|
|00003a90| 72 65 66 3d 33 44 22 68 | 74 74 70 3a 2f 2f 77 77 |ref=3D"h|ttp://ww|
|00003aa0| 77 2e 77 65 62 79 6f 67 | 2e 63 6f 6d 2f 73 71 6c |w.webyog|.com/sql|
|00003ab0| 79 6f 67 2f 73 71 6c 79 | 6f 67 69 6d 61 67 65 73 |yog/sqly|ogimages|
|00003ac0| 2f 69 6d 61 67 65 31 35 | 2e 67 69 66 22 3e 63 6c |/image15|.gif">cl|
|00003ad0| 69 63 6b 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ick=20..| |
|00003ae0| 20 20 20 20 20 20 20 20 | 20 20 68 65 72 65 20 74 | | here t|
|00003af0| 6f 20 73 65 65 20 61 20 | 73 63 72 65 65 6e 73 68 |o see a |screensh|
|00003b00| 6f 74 20 6f 66 20 73 63 | 68 65 6d 61 20 63 72 65 |ot of sc|hema cre|
|00003b10| 61 74 65 64 20 62 79 20 | 3d 0d 0a 53 51 4c 79 6f |ated by |=..SQLyo|
|00003b20| 67 3c 2f 41 3e 3c 2f 50 | 3e 0d 0a 20 20 20 20 20 |g</A></P|>.. |
|00003b30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 50 20 | | <P |
|00003b40| 63 6c 61 73 73 3d 33 44 | 74 65 78 74 20 61 6c 69 |class=3D|text ali|
|00003b50| 67 6e 3d 33 44 6c 65 66 | 74 3e 3c 53 50 41 4e 20 |gn=3Dlef|t><SPAN |
|00003b60| 63 6c 61 73 73 3d 33 44 | 71 75 65 73 74 69 6f 6e |class=3D|question|
|00003b70| 3e 51 2e 20 3d 0d 0a 49 | 20 68 61 76 65 3d 32 30 |>Q. =..I| have=20|
|00003b80| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00003b90| 20 20 20 20 63 72 65 61 | 74 65 64 20 61 20 74 61 | crea|ted a ta|
|00003ba0| 62 6c 65 20 61 6e 64 20 | 77 6f 75 6c 64 20 6c 69 |ble and |would li|
|00003bb0| 6b 65 20 74 6f 20 69 6e | 73 65 72 74 20 73 61 6d |ke to in|sert sam|
|00003bc0| 70 6c 65 20 64 61 74 61 | 3d 32 30 0d 0a 20 20 20 |ple data|=20.. |
|00003bd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 71 | | q|
|00003be0| 75 69 63 6b 6c 79 2e 2e | 2e 44 6f 20 49 20 6e 65 |uickly..|.Do I ne|
|00003bf0| 65 64 20 74 6f 20 77 72 | 69 74 65 20 69 6e 73 65 |ed to wr|ite inse|
|00003c00| 72 74 20 73 74 61 74 65 | 6d 65 6e 74 73 20 3d 0d |rt state|ments =.|
|00003c10| 0a 3f 3c 2f 53 50 41 4e | 3e 3c 2f 50 3e 0d 0a 20 |.?</SPAN|></P>.. |
|00003c20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003c30| 20 3c 50 20 63 6c 61 73 | 73 3d 33 44 74 65 78 74 | <P clas|s=3Dtext|
|00003c40| 20 61 6c 69 67 6e 3d 33 | 44 6c 65 66 74 3e 41 2e | align=3|Dleft>A.|
|00003c50| 20 4e 6f 21 20 53 51 4c | 79 6f 67 20 70 72 6f 76 | No! SQL|yog prov|
|00003c60| 69 64 65 73 20 3d 0d 0a | 79 6f 75 20 77 69 74 68 |ides =..|you with|
|00003c70| 20 61 6e 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 | an=20..| |
|00003c80| 20 20 20 20 20 20 20 20 | 20 20 45 78 63 65 6c 20 | | Excel |
|00003c90| 6c 69 6b 65 20 47 72 69 | 64 20 74 6f 20 49 6e 73 |like Gri|d to Ins|
|00003ca0| 65 72 74 2f 55 70 64 61 | 74 65 20 64 61 74 61 20 |ert/Upda|te data |
|00003cb0| 74 68 72 6f 75 67 68 20 | 77 68 69 63 68 20 3d 0d |through |which =.|
|00003cc0| 0a 79 6f 75 20 63 61 6e | 3d 32 30 0d 0a 20 20 20 |.you can|=20.. |
|00003cd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 69 | | i|
|00003ce0| 6e 73 65 72 74 20 64 61 | 74 61 20 71 75 69 63 6b |nsert da|ta quick|
|00003cf0| 6c 79 2e 20 4d 6f 72 65 | 6f 76 65 72 2c 20 79 6f |ly. More|over, yo|
|00003d00| 75 20 63 61 6e 20 75 73 | 65 20 74 68 65 20 74 6f |u can us|e the to|
|00003d10| 6f 6c 20 74 6f 20 3d 0d | 0a 69 6e 73 65 72 74 3d |ol to =.|.insert=|
|00003d20| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00003d30| 20 20 20 20 20 20 62 6c | 6f 62 20 64 61 74 61 2e | bl|ob data.|
|00003d40| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00003d50| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|00003d60| 3d 33 44 74 65 78 74 20 | 61 6c 69 67 6e 3d 33 44 |=3Dtext |align=3D|
|00003d70| 6c 65 66 74 3e 3c 53 50 | 41 4e 20 3d 0d 0a 63 6c |left><SP|AN =..cl|
|00003d80| 61 73 73 3d 33 44 71 75 | 65 73 74 69 6f 6e 3e 3c |ass=3Dqu|estion><|
|00003d90| 2f 53 50 41 4e 3e 3c 53 | 50 41 4e 3d 32 30 0d 0a |/SPAN><S|PAN=20..|
|00003da0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003db0| 20 20 63 6c 61 73 73 3d | 33 44 71 75 65 73 74 69 | class=|3Dquesti|
|00003dc0| 6f 6e 3e 51 2e 20 49 20 | 68 61 76 65 20 67 6f 74 |on>Q. I |have got|
|00003dd0| 20 61 20 74 61 62 6c 65 | 20 74 68 61 74 20 68 61 | a table| that ha|
|00003de0| 73 20 62 6c 6f 62 20 3d | 0d 0a 66 69 65 6c 64 73 |s blob =|..fields|
|00003df0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00003e00| 20 20 20 20 20 20 20 63 | 6f 6e 74 61 69 6e 69 6e | c|ontainin|
|00003e10| 67 20 74 65 78 74 2f 69 | 6d 61 67 65 73 2e 2e 2e |g text/i|mages...|
|00003e20| 43 61 6e 20 49 20 76 69 | 65 77 20 2f 20 6d 6f 64 |Can I vi|ew / mod|
|00003e30| 69 66 79 20 42 4c 4f 42 | 20 3d 0d 0a 66 69 65 6c |ify BLOB| =..fiel|
|00003e40| 64 73 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |ds=20.. | |
|00003e50| 20 20 20 20 20 20 20 20 | 20 3f 3c 42 52 3e 3c 2f | | ?<BR></|
|00003e60| 53 50 41 4e 3e 3c 2f 50 | 3e 0d 0a 20 20 20 20 20 |SPAN></P|>.. |
|00003e70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 50 20 | | <P |
|00003e80| 63 6c 61 73 73 3d 33 44 | 74 65 78 74 20 61 6c 69 |class=3D|text ali|
|00003e90| 67 6e 3d 33 44 6c 65 66 | 74 3e 41 2e 20 59 65 73 |gn=3Dlef|t>A. Yes|
|00003ea0| 21 20 53 65 6c 65 63 74 | 20 74 68 65 20 74 61 62 |! Select| the tab|
|00003eb0| 6c 65 20 3d 0d 0a 69 6e | 20 74 68 65 3d 32 30 0d |le =..in| the=20.|
|00003ec0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00003ed0| 20 20 20 4f 62 6a 65 63 | 74 20 42 72 6f 77 73 65 | Objec|t Browse|
|00003ee0| 72 20 61 6e 64 20 73 65 | 6c 65 63 74 20 54 61 62 |r and se|lect Tab|
|00003ef0| 6c 65 20 2d 26 67 74 3b | 20 49 6e 73 65 72 74 20 |le ->| Insert |
|00003f00| 2f 20 55 70 64 61 74 65 | 20 3d 0d 0a 44 61 74 61 |/ Update| =..Data|
|00003f10| 20 28 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 | (=20.. | |
|00003f20| 20 20 20 20 20 20 20 20 | 20 43 74 72 6c 2b 45 6e | | Ctrl+En|
|00003f30| 74 65 72 20 29 2e 20 59 | 6f 75 20 63 61 6e 20 69 |ter ). Y|ou can i|
|00003f40| 6e 73 65 72 74 2f 65 64 | 69 74 2f 73 61 76 65 20 |nsert/ed|it/save |
|00003f50| 61 6e 79 20 74 79 70 65 | 20 6f 66 20 3d 0d 0a 42 |any type| of =..B|
|00003f60| 4c 4f 42 20 64 61 74 61 | 2e 3d 32 30 0d 0a 20 20 |LOB data|.=20.. |
|00003f70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003f80| 42 79 20 64 65 66 61 75 | 6c 74 20 53 51 4c 79 6f |By defau|lt SQLyo|
|00003f90| 67 20 77 69 6c 6c 20 6f | 6e 6c 79 20 73 68 6f 77 |g will o|nly show|
|00003fa0| 20 79 6f 75 20 74 68 65 | 20 74 6f 70 20 35 30 20 | you the| top 50 |
|00003fb0| 72 6f 77 73 20 3d 0d 0a | 6f 66 20 74 68 65 3d 32 |rows =..|of the=2|
|00003fc0| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00003fd0| 20 20 20 20 20 74 61 62 | 6c 65 20 62 75 74 20 79 | tab|le but y|
|00003fe0| 6f 75 20 63 61 6e 20 63 | 68 61 6e 67 65 20 74 68 |ou can c|hange th|
|00003ff0| 65 20 6c 69 6d 69 74 20 | 62 79 20 63 68 61 6e 67 |e limit |by chang|
|00004000| 69 6e 67 20 74 68 65 20 | 3d 0d 0a 6c 69 6d 69 74 |ing the |=..limit|
|00004010| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00004020| 20 20 20 20 20 20 20 76 | 61 6c 75 65 73 20 69 6e | v|alues in|
|00004030| 20 74 68 65 20 74 6f 70 | 2e 20 49 74 20 61 75 74 | the top|. It aut|
|00004040| 6f 6d 61 74 69 63 61 6c | 6c 79 20 64 65 74 65 63 |omatical|ly detec|
|00004050| 74 73 20 70 6f 70 75 6c | 61 72 20 3d 0d 0a 69 6d |ts popul|ar =..im|
|00004060| 61 67 65 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |age=20..| |
|00004070| 20 20 20 20 20 20 20 20 | 20 20 66 6f 72 6d 61 74 | | format|
|00004080| 73 20 6c 69 6b 65 20 4a | 50 47 2f 47 49 46 2f 50 |s like J|PG/GIF/P|
|00004090| 4e 47 20 61 6e 64 20 64 | 69 73 70 6c 61 79 73 20 |NG and d|isplays |
|000040a0| 74 68 65 6d 2e 20 4d 6f | 72 65 6f 76 65 72 20 3d |them. Mo|reover =|
|000040b0| 0d 0a 79 6f 75 20 63 61 | 6e 3d 32 30 0d 0a 20 20 |..you ca|n=20.. |
|000040c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000040d0| 73 61 76 65 20 42 4c 4f | 42 20 64 61 74 61 20 74 |save BLO|B data t|
|000040e0| 6f 20 61 20 66 69 6c 65 | 20 6f 72 20 69 6d 70 6f |o a file| or impo|
|000040f0| 72 74 20 63 6f 6e 74 65 | 6e 74 73 20 66 72 6f 6d |rt conte|nts from|
|00004100| 20 61 20 3d 0d 0a 66 69 | 6c 65 20 74 6f 20 61 3d | a =..fi|le to a=|
|00004110| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00004120| 20 20 20 20 20 20 42 4c | 4f 42 20 63 6f 6c 75 6d | BL|OB colum|
|00004130| 6e 2e 20 3c 41 3d 32 30 | 0d 0a 20 20 20 20 20 20 |n. <A=20|.. |
|00004140| 20 20 20 20 20 20 20 20 | 20 20 20 20 3d 0d 0a 68 | | =..h|
|00004150| 72 65 66 3d 33 44 22 68 | 74 74 70 3a 2f 2f 77 77 |ref=3D"h|ttp://ww|
|00004160| 77 2e 77 65 62 79 6f 67 | 2e 63 6f 6d 2f 73 71 6c |w.webyog|.com/sql|
|00004170| 79 6f 67 2f 73 71 6c 79 | 6f 67 69 6d 61 67 65 73 |yog/sqly|ogimages|
|00004180| 2f 69 6d 61 67 65 31 39 | 2e 67 69 66 22 3e 63 6c |/image19|.gif">cl|
|00004190| 69 63 6b 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ick=20..| |
|000041a0| 20 20 20 20 20 20 20 20 | 20 20 68 65 72 65 20 74 | | here t|
|000041b0| 6f 20 73 65 65 20 61 20 | 73 63 72 65 65 6e 73 68 |o see a |screensh|
|000041c0| 6f 74 20 6f 66 20 49 6e | 73 65 72 74 20 2f 20 55 |ot of In|sert / U|
|000041d0| 70 64 61 74 65 20 64 61 | 74 61 20 3d 0d 0a 64 69 |pdate da|ta =..di|
|000041e0| 61 6c 6f 67 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |alog=20.|. |
|000041f0| 20 20 20 20 20 20 20 20 | 20 20 20 62 6f 78 3c 2f | | box</|
|00004200| 41 3e 3c 2f 50 3e 0d 0a | 20 20 20 20 20 20 20 20 |A></P>..| |
|00004210| 20 20 20 20 20 20 20 20 | 20 20 3c 50 20 63 6c 61 | | <P cla|
|00004220| 73 73 3d 33 44 74 65 78 | 74 20 61 6c 69 67 6e 3d |ss=3Dtex|t align=|
|00004230| 33 44 6c 65 66 74 3e 3c | 53 50 41 4e 20 63 6c 61 |3Dleft><|SPAN cla|
|00004240| 73 73 3d 33 44 71 75 65 | 73 74 69 6f 6e 3e 51 2e |ss=3Dque|stion>Q.|
|00004250| 20 3d 0d 0a 49 20 68 61 | 76 65 20 61 3d 32 30 0d | =..I ha|ve a=20.|
|00004260| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00004270| 20 20 20 72 65 73 75 6c | 74 73 65 74 20 77 68 69 | resul|tset whi|
|00004280| 63 68 20 68 61 73 20 61 | 20 42 4c 4f 42 20 63 6f |ch has a| BLOB co|
|00004290| 6c 75 6d 6e 20 3f 20 48 | 6f 77 20 63 61 6e 20 49 |lumn ? H|ow can I|
|000042a0| 20 76 69 65 77 20 69 74 | 73 20 3d 0d 0a 64 61 74 | view it|s =..dat|
|000042b0| 61 20 2f 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |a /=20..| |
|000042c0| 20 20 20 20 20 20 20 20 | 20 20 73 61 76 65 20 69 | | save i|
|000042d0| 74 20 3f 3c 42 52 3e 3c | 2f 53 50 41 4e 3e 3c 2f |t ?<BR><|/SPAN></|
|000042e0| 50 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |P>.. | |
|000042f0| 20 20 20 20 20 20 3c 50 | 20 63 6c 61 73 73 3d 33 | <P| class=3|
|00004300| 44 74 65 78 74 20 61 6c | 69 67 6e 3d 33 44 6c 65 |Dtext al|ign=3Dle|
|00004310| 66 74 3e 41 2e 20 41 6c | 6c 20 74 68 65 20 42 4c |ft>A. Al|l the BL|
|00004320| 4f 42 20 63 6f 6c 75 6d | 6e 73 20 3d 0d 0a 77 69 |OB colum|ns =..wi|
|00004330| 6c 6c 20 62 65 20 73 68 | 6f 77 6e 3d 32 30 0d 0a |ll be sh|own=20..|
|00004340| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004350| 20 20 69 6e 20 74 68 65 | 20 52 65 73 75 6c 74 73 | in the| Results|
|00004360| 65 74 20 77 69 6e 64 6f | 77 20 77 69 74 68 20 5b |et windo|w with [|
|00004370| 42 4c 4f 42 5d 20 5b 73 | 69 7a 65 20 6f 66 20 64 |BLOB] [s|ize of d|
|00004380| 61 74 61 20 69 6e 20 3d | 0d 0a 62 79 74 65 73 5d |ata in =|..bytes]|
|00004390| 2e 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |.=20.. | |
|000043a0| 20 20 20 20 20 20 20 20 | 44 6f 75 62 6c 65 20 63 | |Double c|
|000043b0| 6c 69 63 6b 20 6f 6e 20 | 74 68 65 20 63 6f 6c 75 |lick on |the colu|
|000043c0| 6d 6e 20 61 6e 64 20 61 | 20 3c 49 3e 6d 6f 64 65 |mn and a| <I>mode|
|000043d0| 6c 65 73 73 3c 2f 49 3e | 20 42 6c 6f 62 20 3d 0d |less</I>| Blob =.|
|000043e0| 0a 56 61 6c 75 65 3d 32 | 30 0d 0a 20 20 20 20 20 |.Value=2|0.. |
|000043f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 64 69 61 | | dia|
|00004400| 6c 6f 67 20 62 6f 78 20 | 77 69 6c 6c 20 70 6f 70 |log box |will pop|
|00004410| 75 70 2e 20 59 6f 75 20 | 63 61 6e 20 73 61 76 65 |up. You |can save|
|00004420| 20 74 68 65 20 64 61 74 | 61 20 69 6e 20 61 20 66 | the dat|a in a f|
|00004430| 69 6c 65 20 3d 0d 0a 69 | 6e 20 79 6f 75 72 3d 32 |ile =..i|n your=2|
|00004440| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00004450| 20 20 20 20 20 6c 6f 63 | 61 6c 20 6d 61 63 68 69 | loc|al machi|
|00004460| 6e 65 20 62 79 20 73 65 | 6c 65 63 74 69 6e 67 20 |ne by se|lecting |
|00004470| 53 61 76 65 20 44 61 74 | 61 20 54 6f 20 41 20 46 |Save Dat|a To A F|
|00004480| 69 6c 65 20 6f 70 74 69 | 6f 6e 2e 20 3d 0d 0a 0d |ile opti|on. =...|
|00004490| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000044a0| 20 20 20 54 68 65 72 65 | 66 6f 72 65 2c 20 66 6f | There|fore, fo|
|000044b0| 72 20 65 78 61 6d 70 6c | 65 2c 20 79 6f 75 20 63 |r exampl|e, you c|
|000044c0| 61 6e 20 65 76 65 6e 20 | 72 65 74 72 69 65 76 65 |an even |retrieve|
|000044d0| 20 61 20 50 44 46 20 3d | 0d 0a 64 61 74 61 20 69 | a PDF =|..data i|
|000044e0| 6e 20 61 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |n a=20..| |
|000044f0| 20 20 20 20 20 20 20 20 | 20 20 63 6f 6c 75 6d 6e | | column|
|00004500| 20 61 6e 64 20 73 61 76 | 65 20 69 74 20 69 6e 20 | and sav|e it in |
|00004510| 79 6f 75 72 20 68 61 72 | 64 64 69 73 6b 2e 20 3c |your har|ddisk. <|
|00004520| 41 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |A=20.. | |
|00004530| 20 20 20 20 20 20 20 20 | 3d 0d 0a 68 72 65 66 3d | |=..href=|
|00004540| 33 44 22 68 74 74 70 3a | 2f 2f 77 77 77 2e 77 65 |3D"http:|//www.we|
|00004550| 62 79 6f 67 2e 63 6f 6d | 2f 73 71 6c 79 6f 67 2f |byog.com|/sqlyog/|
|00004560| 73 71 6c 79 6f 67 69 6d | 61 67 65 73 2f 69 6d 61 |sqlyogim|ages/ima|
|00004570| 67 65 32 34 2e 67 69 66 | 22 3e 63 6c 69 63 6b 3d |ge24.gif|">click=|
|00004580| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00004590| 20 20 20 20 20 20 68 65 | 72 65 20 74 6f 20 73 65 | he|re to se|
|000045a0| 65 20 61 20 73 63 72 65 | 65 6e 73 68 6f 74 20 6f |e a scre|enshot o|
|000045b0| 66 20 62 6c 6f 62 20 76 | 61 6c 75 65 20 64 69 61 |f blob v|alue dia|
|000045c0| 6c 6f 67 20 3d 0d 0a 62 | 6f 78 3c 2f 41 3e 3c 2f |log =..b|ox</A></|
|000045d0| 50 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |P>.. | |
|000045e0| 20 20 20 20 20 20 3c 50 | 20 63 6c 61 73 73 3d 33 | <P| class=3|
|000045f0| 44 71 75 65 73 74 69 6f | 6e 20 61 6c 69 67 6e 3d |Dquestio|n align=|
|00004600| 33 44 6c 65 66 74 3e 51 | 2e 20 49 20 68 61 76 65 |3Dleft>Q|. I have|
|00004610| 20 61 20 74 61 62 6c 65 | 20 3d 0d 0a 77 69 74 68 | a table| =..with|
|00004620| 20 6c 6f 74 20 6f 66 3d | 32 30 0d 0a 20 20 20 20 | lot of=|20.. |
|00004630| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 63 6f | | co|
|00004640| 6c 75 6d 6e 73 20 61 6e | 64 20 49 20 77 61 6e 74 |lumns an|d I want|
|00004650| 20 74 6f 20 67 65 6e 65 | 72 61 74 65 20 61 6e 20 | to gene|rate an |
|00004660| 49 6e 73 65 72 74 20 73 | 74 61 74 65 6d 65 6e 74 |Insert s|tatement|
|00004670| 20 66 6f 72 20 3d 0d 0a | 74 68 65 3d 32 30 0d 0a | for =..|the=20..|
|00004680| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004690| 20 20 74 61 62 6c 65 2e | 20 48 6f 77 20 63 61 6e | table.| How can|
|000046a0| 20 49 20 64 6f 20 69 74 | 20 3f 3c 2f 50 3e 0d 0a | I do it| ?</P>..|
|000046b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000046c0| 20 20 3c 50 20 63 6c 61 | 73 73 3d 33 44 74 65 78 | <P cla|ss=3Dtex|
|000046d0| 74 20 61 6c 69 67 6e 3d | 33 44 6c 65 66 74 3e 41 |t align=|3Dleft>A|
|000046e0| 2e 20 53 65 6c 65 63 74 | 20 74 68 65 20 74 61 62 |. Select| the tab|
|000046f0| 6c 65 20 69 6e 20 3d 0d | 0a 74 68 65 20 4f 62 6a |le in =.|.the Obj|
|00004700| 65 63 74 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ect=20..| |
|00004710| 20 20 20 20 20 20 20 20 | 20 20 42 72 6f 77 73 65 | | Browse|
|00004720| 72 20 61 6e 64 20 73 65 | 6c 65 63 74 20 54 61 62 |r and se|lect Tab|
|00004730| 6c 65 20 2d 26 67 74 3b | 20 49 6e 73 65 72 74 20 |le ->| Insert |
|00004740| 53 74 61 74 65 6d 65 6e | 74 20 46 6f 72 20 3d 0d |Statemen|t For =.|
|00004750| 0a 54 68 65 20 54 61 62 | 6c 65 2e 3d 32 30 0d 0a |.The Tab|le.=20..|
|00004760| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004770| 20 20 53 51 4c 79 6f 67 | 20 77 69 6c 6c 20 63 72 | SQLyog| will cr|
|00004780| 65 61 74 65 20 61 20 69 | 6e 73 65 72 74 20 73 74 |eate a i|nsert st|
|00004790| 61 74 65 6d 65 6e 74 20 | 66 6f 72 20 74 68 65 20 |atement |for the |
|000047a0| 74 61 62 6c 65 20 3d 0d | 0a 61 6e 64 20 79 6f 75 |table =.|.and you|
|000047b0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|000047c0| 20 20 20 20 20 20 20 6a | 75 73 74 20 6e 65 65 64 | j|ust need|
|000047d0| 20 74 6f 20 66 69 6c 6c | 20 69 6e 20 74 68 65 20 | to fill| in the |
|000047e0| 61 70 70 72 6f 70 72 69 | 61 74 65 20 76 61 6c 75 |appropri|ate valu|
|000047f0| 65 73 2e 3c 2f 50 3e 0d | 0a 20 20 20 20 20 20 20 |es.</P>.|. |
|00004800| 20 20 20 20 20 20 20 20 | 20 20 20 3c 50 20 63 6c | | <P cl|
|00004810| 61 73 73 3d 33 44 74 65 | 78 74 20 61 6c 69 67 6e |ass=3Dte|xt align|
|00004820| 3d 33 44 6c 65 66 74 3e | 3c 53 50 41 4e 20 63 6c |=3Dleft>|<SPAN cl|
|00004830| 61 73 73 3d 33 44 71 75 | 65 73 74 69 6f 6e 3e 51 |ass=3Dqu|estion>Q|
|00004840| 2e 20 3d 0d 0a 4a 75 73 | 74 20 6c 69 6b 65 3d 32 |. =..Jus|t like=2|
|00004850| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00004860| 20 20 20 20 20 6f 74 68 | 65 72 20 70 72 6f 67 72 | oth|er progr|
|00004870| 61 6d 6d 65 72 73 2c 20 | 49 20 6c 69 6b 65 20 74 |ammers, |I like t|
|00004880| 6f 20 64 6f 20 6d 6f 73 | 74 20 6f 66 20 6d 79 20 |o do mos|t of my |
|00004890| 77 6f 72 6b 20 75 73 69 | 6e 67 20 3d 0d 0a 6b 65 |work usi|ng =..ke|
|000048a0| 79 62 6f 61 72 64 3d 32 | 30 0d 0a 20 20 20 20 20 |yboard=2|0.. |
|000048b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3f 20 49 | | ? I|
|000048c0| 73 20 53 51 4c 79 6f 67 | 20 6b 65 79 62 6f 61 72 |s SQLyog| keyboar|
|000048d0| 64 20 66 72 69 65 6e 64 | 6c 79 2e 3c 2f 53 50 41 |d friend|ly.</SPA|
|000048e0| 4e 3e 3c 2f 50 3e 0d 0a | 20 20 20 20 20 20 20 20 |N></P>..| |
|000048f0| 20 20 20 20 20 20 20 20 | 20 20 3c 50 20 63 6c 61 | | <P cla|
|00004900| 73 73 3d 33 44 74 65 78 | 74 20 61 6c 69 67 6e 3d |ss=3Dtex|t align=|
|00004910| 33 44 6c 65 66 74 3e 41 | 2e 20 53 51 4c 79 6f 67 |3Dleft>A|. SQLyog|
|00004920| 20 68 61 73 20 62 65 65 | 6e 20 3d 0d 0a 64 65 73 | has bee|n =..des|
|00004930| 69 67 6e 65 64 20 66 72 | 6f 6d 3d 32 30 0d 0a 20 |igned fr|om=20.. |
|00004940| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004950| 20 67 72 6f 75 6e 64 2d | 75 70 20 74 6f 20 62 65 | ground-|up to be|
|00004960| 20 6b 65 79 62 6f 61 72 | 64 20 66 72 69 65 6e 64 | keyboar|d friend|
|00004970| 6c 79 2e 20 59 6f 75 20 | 63 61 6e 20 73 77 69 74 |ly. You |can swit|
|00004980| 63 68 20 3d 0d 0a 62 65 | 74 77 65 65 6e 20 74 68 |ch =..be|tween th|
|00004990| 65 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |e=20.. | |
|000049a0| 20 20 20 20 20 20 20 20 | 76 61 72 69 6f 75 73 20 | |various |
|000049b0| 70 61 6e 65 73 2c 20 6d | 75 6c 74 69 70 6c 65 20 |panes, m|ultiple |
|000049c0| 72 65 73 75 6c 74 73 65 | 74 73 20 77 69 74 68 6f |resultse|ts witho|
|000049d0| 75 74 20 65 76 65 72 20 | 3d 0d 0a 6e 65 65 64 69 |ut ever |=..needi|
|000049e0| 6e 67 20 74 68 65 3d 32 | 30 0d 0a 20 20 20 20 20 |ng the=2|0.. |
|000049f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 6d 6f 75 | | mou|
|00004a00| 73 65 2e 20 3c 41 3d 32 | 30 0d 0a 20 20 20 20 20 |se. <A=2|0.. |
|00004a10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3d 0d 0a | | =..|
|00004a20| 68 72 65 66 3d 33 44 22 | 68 74 74 70 3a 2f 2f 77 |href=3D"|http://w|
|00004a30| 77 77 2e 77 65 62 79 6f | 67 2e 63 6f 6d 2f 73 71 |ww.webyo|g.com/sq|
|00004a40| 6c 79 6f 67 2f 6b 65 79 | 73 68 6f 72 74 73 2e 68 |lyog/key|shorts.h|
|00004a50| 74 6d 6c 22 3e 43 68 65 | 63 6b 20 6f 75 74 3d 32 |tml">Che|ck out=2|
|00004a60| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00004a70| 20 20 20 20 20 74 68 65 | 20 76 61 72 69 6f 75 73 | the| various|
|00004a80| 20 6b 65 79 62 6f 61 72 | 64 20 73 68 6f 72 74 63 | keyboar|d shortc|
|00004a90| 75 74 73 20 70 72 6f 76 | 69 64 65 64 20 62 79 20 |uts prov|ided by |
|00004aa0| 3d 0d 0a 53 51 4c 79 6f | 67 3c 2f 41 3e 2e 3c 2f |=..SQLyo|g</A>.</|
|00004ab0| 50 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |P>.. | |
|00004ac0| 20 20 20 20 20 20 3c 50 | 20 63 6c 61 73 73 3d 33 | <P| class=3|
|00004ad0| 44 74 65 78 74 20 61 6c | 69 67 6e 3d 33 44 6c 65 |Dtext al|ign=3Dle|
|00004ae0| 66 74 3e 3c 53 50 41 4e | 20 63 6c 61 73 73 3d 33 |ft><SPAN| class=3|
|00004af0| 44 71 75 65 73 74 69 6f | 6e 3e 51 2e 20 3d 0d 0a |Dquestio|n>Q. =..|
|00004b00| 49 20 68 61 76 65 3d 32 | 30 0d 0a 20 20 20 20 20 |I have=2|0.. |
|00004b10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 72 65 74 | | ret|
|00004b20| 72 69 65 76 65 64 20 61 | 20 72 65 73 75 6c 74 73 |rieved a| results|
|00004b30| 65 74 20 69 6e 20 53 51 | 4c 79 6f 67 2e 20 4e 6f |et in SQ|Lyog. No|
|00004b40| 77 2c 20 49 20 77 61 6e | 74 20 74 6f 20 3d 0d 0a |w, I wan|t to =..|
|00004b50| 71 75 69 63 6b 6c 79 3d | 32 30 0d 0a 20 20 20 20 |quickly=|20.. |
|00004b60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 73 6f | | so|
|00004b70| 72 74 2f 66 69 6c 74 65 | 72 20 74 68 65 20 64 61 |rt/filte|r the da|
|00004b80| 74 61 20 77 69 74 68 6f | 75 74 20 63 68 61 6e 67 |ta witho|ut chang|
|00004b90| 69 6e 67 20 61 6e 64 20 | 72 65 2d 65 78 65 63 75 |ing and |re-execu|
|00004ba0| 74 69 6e 67 20 3d 0d 0a | 74 68 65 20 53 51 4c 3d |ting =..|the SQL=|
|00004bb0| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00004bc0| 20 20 20 20 20 20 71 75 | 65 72 79 2e 20 48 6f 77 | qu|ery. How|
|00004bd0| 20 63 61 6e 20 49 20 64 | 6f 20 74 68 61 74 20 3f | can I d|o that ?|
|00004be0| 3c 2f 53 50 41 4e 3e 3c | 2f 50 3e 0d 0a 20 20 20 |</SPAN><|/P>.. |
|00004bf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c | | <|
|00004c00| 50 20 63 6c 61 73 73 3d | 33 44 74 65 78 74 20 61 |P class=|3Dtext a|
|00004c10| 6c 69 67 6e 3d 33 44 6c | 65 66 74 3e 41 2e 20 49 |lign=3Dl|eft>A. I|
|00004c20| 66 20 79 6f 75 20 61 72 | 65 20 76 69 65 77 69 6e |f you ar|e viewin|
|00004c30| 67 20 74 68 65 20 3d 0d | 0a 72 65 73 75 6c 74 20 |g the =.|.result |
|00004c40| 69 6e 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |in=20.. | |
|00004c50| 20 20 20 20 20 20 20 20 | 20 47 72 69 64 20 6d 6f | | Grid mo|
|00004c60| 64 65 2c 20 79 6f 75 20 | 63 61 6e 20 63 6c 69 63 |de, you |can clic|
|00004c70| 6b 20 6f 6e 20 61 20 63 | 6f 6c 75 6d 6e 20 68 65 |k on a c|olumn he|
|00004c80| 61 64 65 72 20 74 6f 20 | 73 6f 72 74 20 3d 0d 0a |ader to |sort =..|
|00004c90| 74 68 65 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |the=20..| |
|00004ca0| 20 20 20 20 20 20 20 20 | 20 20 72 65 73 75 6c 74 | | result|
|00004cb0| 73 65 74 20 6f 6e 20 74 | 68 61 74 20 63 6f 6c 75 |set on t|hat colu|
|00004cc0| 6d 6e 2e 20 59 6f 75 20 | 63 61 6e 20 75 73 65 20 |mn. You |can use |
|00004cd0| 74 68 65 20 52 69 67 68 | 74 20 43 6c 69 63 6b 20 |the Righ|t Click |
|00004ce0| 3d 0d 0a 63 6f 6e 74 65 | 78 74 3d 32 30 0d 0a 20 |=..conte|xt=20.. |
|00004cf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004d00| 20 6d 65 6e 75 20 74 6f | 20 66 69 6c 74 65 72 20 | menu to| filter |
|00004d10| 64 61 74 61 2e 20 46 75 | 72 74 68 65 72 6d 6f 72 |data. Fu|rthermor|
|00004d20| 65 2c 20 79 6f 75 20 63 | 61 6e 20 63 6f 6d 62 69 |e, you c|an combi|
|00004d30| 6e 65 20 3d 0d 0a 73 6f | 72 74 69 6e 67 20 61 6e |ne =..so|rting an|
|00004d40| 64 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |d=20.. | |
|00004d50| 20 20 20 20 20 20 20 20 | 66 69 6c 74 65 72 69 6e | |filterin|
|00004d60| 67 2e 20 3c 41 3d 32 30 | 0d 0a 20 20 20 20 20 20 |g. <A=20|.. |
|00004d70| 20 20 20 20 20 20 20 20 | 20 20 20 20 3d 0d 0a 68 | | =..h|
|00004d80| 72 65 66 3d 33 44 22 68 | 74 74 70 3a 2f 2f 77 77 |ref=3D"h|ttp://ww|
|00004d90| 77 2e 77 65 62 79 6f 67 | 2e 63 6f 6d 2f 73 71 6c |w.webyog|.com/sql|
|00004da0| 79 6f 67 2f 73 71 6c 79 | 6f 67 69 6d 61 67 65 73 |yog/sqly|ogimages|
|00004db0| 2f 69 6d 61 67 65 33 38 | 2e 67 69 66 22 3e 63 6c |/image38|.gif">cl|
|00004dc0| 69 63 6b 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ick=20..| |
|00004dd0| 20 20 20 20 20 20 20 20 | 20 20 68 65 72 65 20 74 | | here t|
|00004de0| 6f 20 76 69 65 77 20 61 | 20 73 6f 72 74 65 64 20 |o view a| sorted |
|00004df0| 63 6f 6c 75 6d 6e 3c 2f | 41 3e 3c 2f 50 3e 0d 0a |column</|A></P>..|
|00004e00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e10| 20 20 3c 50 20 63 6c 61 | 73 73 3d 33 44 66 61 71 | <P cla|ss=3Dfaq|
|00004e20| 68 65 61 64 65 72 20 61 | 6c 69 67 6e 3d 33 44 63 |header a|lign=3Dc|
|00004e30| 65 6e 74 65 72 3e 3c 41 | 20 3d 0d 0a 6e 61 6d 65 |enter><A| =..name|
|00004e40| 3d 33 44 61 64 6d 69 6e | 69 73 74 72 61 74 6f 72 |=3Dadmin|istrator|
|00004e50| 3e 3c 2f 41 3e 46 6f 72 | 3d 32 30 0d 0a 20 20 20 |></A>For|=20.. |
|00004e60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 41 | | A|
|00004e70| 64 6d 69 6e 69 73 74 72 | 61 74 6f 72 73 3c 2f 50 |dministr|ators</P|
|00004e80| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00004e90| 20 20 20 20 20 3c 50 20 | 63 6c 61 73 73 3d 33 44 | <P |class=3D|
|00004ea0| 68 65 61 64 65 72 20 61 | 6c 69 67 6e 3d 33 44 6c |header a|lign=3Dl|
|00004eb0| 65 66 74 3e 3c 53 50 41 | 4e 20 3d 0d 0a 63 6c 61 |eft><SPA|N =..cla|
|00004ec0| 73 73 3d 33 44 71 75 65 | 73 74 69 6f 6e 3e 51 2e |ss=3Dque|stion>Q.|
|00004ed0| 20 43 61 6e 20 49 20 61 | 6c 74 65 72 3d 32 30 0d | Can I a|lter=20.|
|00004ee0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00004ef0| 20 20 20 65 78 69 73 74 | 69 6e 67 20 54 61 62 6c | exist|ing Tabl|
|00004f00| 65 20 73 74 72 75 63 74 | 75 72 65 73 20 3f 3c 2f |e struct|ures ?</|
|00004f10| 53 50 41 4e 3e 3c 2f 50 | 3e 0d 0a 20 20 20 20 20 |SPAN></P|>.. |
|00004f20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 50 20 | | <P |
|00004f30| 61 6c 69 67 6e 3d 33 44 | 6c 65 66 74 3e 41 2e 20 |align=3D|left>A. |
|00004f40| 59 65 73 21 20 59 6f 75 | 20 77 69 6c 6c 20 67 65 |Yes! You| will ge|
|00004f50| 74 20 61 20 45 78 63 65 | 6c 20 6c 69 6b 65 20 47 |t a Exce|l like G|
|00004f60| 72 69 64 20 3d 0d 0a 74 | 6f 20 61 6c 74 65 72 3d |rid =..t|o alter=|
|00004f70| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00004f80| 20 20 20 20 20 20 79 6f | 75 72 20 74 61 62 6c 65 | yo|ur table|
|00004f90| 20 73 74 72 75 63 74 75 | 72 65 2e 20 3c 41 3d 32 | structu|re. <A=2|
|00004fa0| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00004fb0| 20 20 20 20 20 3d 0d 0a | 68 72 65 66 3d 33 44 22 | =..|href=3D"|
|00004fc0| 68 74 74 70 3a 2f 2f 77 | 77 77 2e 77 65 62 79 6f |http://w|ww.webyo|
|00004fd0| 67 2e 63 6f 6d 2f 73 71 | 6c 79 6f 67 2f 73 71 6c |g.com/sq|lyog/sql|
|00004fe0| 79 6f 67 69 6d 61 67 65 | 73 2f 69 6d 61 67 65 31 |yogimage|s/image1|
|00004ff0| 36 2e 67 69 66 22 3e 63 | 6c 69 63 6b 3d 32 30 0d |6.gif">c|lick=20.|
|00005000| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00005010| 20 20 20 68 65 72 65 20 | 74 6f 20 73 65 65 20 61 | here |to see a|
|00005020| 20 73 63 72 65 65 73 68 | 6f 74 20 6f 66 20 61 6c | screesh|ot of al|
|00005030| 74 65 72 20 74 61 62 6c | 65 20 64 69 61 6c 6f 67 |ter tabl|e dialog|
|00005040| 3c 2f 41 3e 3c 2f 50 3e | 0d 0a 20 20 20 20 20 20 |</A></P>|.. |
|00005050| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 50 20 63 | | <P c|
|00005060| 6c 61 73 73 3d 33 44 71 | 75 65 73 74 69 6f 6e 20 |lass=3Dq|uestion |
|00005070| 61 6c 69 67 6e 3d 33 44 | 6c 65 66 74 3e 51 2e 20 |align=3D|left>Q. |
|00005080| 43 61 6e 20 49 20 6d 61 | 6e 61 67 65 20 3d 0d 0a |Can I ma|nage =..|
|00005090| 49 6e 64 65 78 65 73 20 | 75 73 69 6e 67 3d 32 30 |Indexes |using=20|
|000050a0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000050b0| 20 20 20 20 53 51 4c 79 | 6f 67 20 3f 3c 2f 50 3e | SQLy|og ?</P>|
|000050c0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000050d0| 20 20 20 20 3c 50 20 61 | 6c 69 67 6e 3d 33 44 6c | <P a|lign=3Dl|
|000050e0| 65 66 74 3e 41 2e 20 59 | 65 73 21 20 53 51 4c 79 |eft>A. Y|es! SQLy|
|000050f0| 6f 67 20 70 72 6f 76 69 | 64 65 73 20 79 6f 75 20 |og provi|des you |
|00005100| 77 69 74 68 20 61 6e 20 | 3d 0d 0a 65 61 73 79 20 |with an |=..easy |
|00005110| 49 6e 64 65 78 3d 32 30 | 0d 0a 20 20 20 20 20 20 |Index=20|.. |
|00005120| 20 20 20 20 20 20 20 20 | 20 20 20 20 4d 61 6e 61 | | Mana|
|00005130| 67 65 72 2e 20 59 6f 75 | 20 63 61 6e 20 6d 61 6e |ger. You| can man|
|00005140| 61 67 65 20 6d 75 6c 74 | 69 70 6c 65 20 69 6e 64 |age mult|iple ind|
|00005150| 65 78 65 73 2c 20 63 72 | 65 61 74 65 20 3d 0d 0a |exes, cr|eate =..|
|00005160| 69 6e 64 65 78 65 73 20 | 6f 6e 3d 32 30 0d 0a 20 |indexes |on=20.. |
|00005170| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005180| 20 6d 75 6c 74 69 70 6c | 65 20 63 6f 6c 75 6d 6e | multipl|e column|
|00005190| 73 2c 20 63 68 61 6e 67 | 65 20 74 68 65 20 6f 72 |s, chang|e the or|
|000051a0| 64 65 72 20 6f 66 20 63 | 6f 6c 75 6d 6e 73 20 69 |der of c|olumns i|
|000051b0| 6e 20 74 68 65 20 3d 0d | 0a 69 6e 64 65 78 2c 3d |n the =.|.index,=|
|000051c0| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|000051d0| 20 20 20 20 20 20 65 74 | 63 2e 20 3c 41 3d 32 30 | et|c. <A=20|
|000051e0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000051f0| 20 20 20 20 3d 0d 0a 68 | 72 65 66 3d 33 44 22 68 | =..h|ref=3D"h|
|00005200| 74 74 70 3a 2f 2f 77 77 | 77 2e 77 65 62 79 6f 67 |ttp://ww|w.webyog|
|00005210| 2e 63 6f 6d 2f 73 71 6c | 79 6f 67 2f 73 71 6c 79 |.com/sql|yog/sqly|
|00005220| 6f 67 69 6d 61 67 65 73 | 2f 69 6d 61 67 65 32 35 |ogimages|/image25|
|00005230| 2e 67 69 66 22 3e 63 6c | 69 63 6b 3d 32 30 0d 0a |.gif">cl|ick=20..|
|00005240| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005250| 20 20 68 65 72 65 20 74 | 6f 20 73 65 65 20 61 20 | here t|o see a |
|00005260| 73 63 72 65 65 73 68 6f | 74 20 6f 66 20 6d 61 6e |screesho|t of man|
|00005270| 61 67 65 20 69 6e 64 65 | 78 65 73 20 3d 0d 0a 64 |age inde|xes =..d|
|00005280| 69 61 6c 6f 67 3c 2f 41 | 3e 3c 2f 50 3e 0d 0a 20 |ialog</A|></P>.. |
|00005290| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000052a0| 20 3c 50 20 63 6c 61 73 | 73 3d 33 44 71 75 65 73 | <P clas|s=3Dques|
|000052b0| 74 69 6f 6e 20 61 6c 69 | 67 6e 3d 33 44 6c 65 66 |tion ali|gn=3Dlef|
|000052c0| 74 3e 51 2e 20 49 20 77 | 61 6e 74 20 74 6f 20 61 |t>Q. I w|ant to a|
|000052d0| 64 64 20 3d 0d 0a 75 73 | 65 72 73 20 2f 20 63 68 |dd =..us|ers / ch|
|000052e0| 61 6e 67 65 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |ange=20.|. |
|000052f0| 20 20 20 20 20 20 20 20 | 20 20 20 70 61 73 73 77 | | passw|
|00005300| 6f 72 64 73 20 65 74 63 | 2e 20 3f 20 48 6f 77 20 |ords etc|. ? How |
|00005310| 63 61 6e 20 49 20 64 6f | 20 74 68 61 74 20 3f 3c |can I do| that ?<|
|00005320| 2f 50 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |/P>.. | |
|00005330| 20 20 20 20 20 20 20 3c | 50 20 61 6c 69 67 6e 3d | <|P align=|
|00005340| 33 44 6c 65 66 74 3e 41 | 2e 20 55 73 65 20 54 6f |3Dleft>A|. Use To|
|00005350| 6f 6c 73 20 2d 26 67 74 | 3b 20 55 73 65 72 20 4d |ols ->|; User M|
|00005360| 61 6e 61 67 65 72 20 2d | 26 67 74 3b 20 3d 0d 0a |anager -|> =..|
|00005370| 41 64 64 20 55 73 65 72 | 73 3d 32 30 0d 0a 20 20 |Add User|s=20.. |
|00005380| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005390| 28 20 43 74 72 6c 2b 55 | 20 29 20 61 6e 64 20 54 |( Ctrl+U| ) and T|
|000053a0| 6f 6f 6c 73 20 2d 26 67 | 74 3b 20 55 73 65 72 20 |ools -&g|t; User |
|000053b0| 4d 61 6e 61 67 65 72 20 | 2d 26 67 74 3b 20 45 64 |Manager |-> Ed|
|000053c0| 69 74 20 3d 0d 0a 55 73 | 65 72 73 20 28 3d 32 30 |it =..Us|ers (=20|
|000053d0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000053e0| 20 20 20 20 43 74 72 6c | 2b 41 6c 74 2b 55 20 29 | Ctrl|+Alt+U )|
|000053f0| 20 74 6f 20 61 64 64 20 | 61 6e 64 20 65 64 69 74 | to add |and edit|
|00005400| 20 75 73 65 72 73 20 67 | 6c 6f 62 61 6c 20 70 72 | users g|lobal pr|
|00005410| 69 76 69 6c 65 67 65 73 | 2e 20 3d 0d 0a 3c 41 3d |ivileges|. =..<A=|
|00005420| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00005430| 20 20 20 20 20 20 3d 0d | 0a 68 72 65 66 3d 33 44 | =.|.href=3D|
|00005440| 22 68 74 74 70 3a 2f 2f | 77 77 77 2e 77 65 62 79 |"http://|www.weby|
|00005450| 6f 67 2e 63 6f 6d 2f 73 | 71 6c 79 6f 67 2f 73 71 |og.com/s|qlyog/sq|
|00005460| 6c 79 6f 67 69 6d 61 67 | 65 73 2f 69 6d 61 67 65 |lyogimag|es/image|
|00005470| 33 31 2e 67 69 66 22 3e | 63 6c 69 63 6b 3d 32 30 |31.gif">|click=20|
|00005480| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00005490| 20 20 20 20 68 65 72 65 | 20 74 6f 20 73 65 65 20 | here| to see |
|000054a0| 61 20 73 63 72 65 65 73 | 68 6f 74 20 6f 66 20 65 |a screes|hot of e|
|000054b0| 64 69 74 20 75 73 65 72 | 20 64 69 61 6c 6f 67 3c |dit user| dialog<|
|000054c0| 2f 41 3e 3c 2f 50 3e 0d | 0a 20 20 20 20 20 20 20 |/A></P>.|. |
|000054d0| 20 20 20 20 20 20 20 20 | 20 20 20 3c 50 20 63 6c | | <P cl|
|000054e0| 61 73 73 3d 33 44 71 75 | 65 73 74 69 6f 6e 20 61 |ass=3Dqu|estion a|
|000054f0| 6c 69 67 6e 3d 33 44 6c | 65 66 74 3e 51 2e 20 49 |lign=3Dl|eft>Q. I|
|00005500| 20 77 61 6e 74 20 74 6f | 20 67 69 76 65 20 61 20 | want to| give a |
|00005510| 3d 0d 0a 75 73 65 72 3d | 32 30 0d 0a 20 20 20 20 |=..user=|20.. |
|00005520| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 70 72 | | pr|
|00005530| 69 76 69 6c 65 67 65 73 | 20 6f 6e 6c 79 20 74 6f |ivileges| only to|
|00005540| 20 70 61 72 74 69 63 75 | 6c 61 72 20 63 6f 6c 75 | particu|lar colu|
|00005550| 6d 6e 73 20 69 6e 20 61 | 20 74 61 62 6c 65 20 3f |mns in a| table ?|
|00005560| 20 43 61 6e 20 3d 0d 0a | 49 20 64 6f 20 69 74 3d | Can =..|I do it=|
|00005570| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00005580| 20 20 20 20 20 20 69 6e | 20 53 51 4c 79 6f 67 2e | in| SQLyog.|
|00005590| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|000055a0| 20 20 20 20 20 20 20 20 | 3c 50 20 61 6c 69 67 6e | |<P align|
|000055b0| 3d 33 44 6c 65 66 74 3e | 41 2e 20 59 65 73 21 20 |=3Dleft>|A. Yes! |
|000055c0| 42 79 20 75 73 69 6e 67 | 20 53 51 4c 79 6f 67 27 |By using| SQLyog'|
|000055d0| 73 20 70 6f 77 65 72 66 | 75 6c 20 61 6e 64 20 3d |s powerf|ul and =|
|000055e0| 0d 0a 65 61 73 79 20 74 | 6f 3d 32 30 0d 0a 20 20 |..easy t|o=20.. |
|000055f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005600| 75 73 65 20 4d 61 6e 61 | 67 65 20 50 65 72 6d 69 |use Mana|ge Permi|
|00005610| 73 73 69 6f 6e 73 20 74 | 6f 6f 6c 2c 20 79 6f 75 |ssions t|ool, you|
|00005620| 20 63 61 6e 20 67 69 76 | 65 20 64 61 74 61 62 61 | can giv|e databa|
|00005630| 73 65 2c 20 3d 0d 0a 74 | 61 62 6c 65 3d 32 30 0d |se, =..t|able=20.|
|00005640| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00005650| 20 20 20 26 61 6d 70 3b | 20 63 6f 6c 75 6d 6e 20 | &| column |
|00005660| 6c 65 76 65 6c 20 70 72 | 69 76 69 6c 65 67 65 73 |level pr|ivileges|
|00005670| 20 74 6f 20 61 6e 79 20 | 75 73 65 72 2e 20 54 68 | to any |user. Th|
|00005680| 65 20 4d 61 6e 61 67 65 | 3d 32 30 0d 0a 20 20 20 |e Manage|=20.. |
|00005690| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 50 | | P|
|000056a0| 65 72 6d 69 73 73 69 6f | 6e 73 20 6f 70 74 69 6f |ermissio|ns optio|
|000056b0| 6e 20 63 61 6e 20 62 65 | 20 66 6f 75 6e 64 20 61 |n can be| found a|
|000056c0| 74 20 54 6f 6f 6c 73 20 | 2d 26 67 74 3b 20 55 73 |t Tools |-> Us|
|000056d0| 65 72 20 3d 0d 0a 4d 61 | 6e 61 67 65 72 3d 32 30 |er =..Ma|nager=20|
|000056e0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000056f0| 20 20 20 20 2d 26 67 74 | 3b 20 4d 61 6e 61 67 65 | ->|; Manage|
|00005700| 20 50 65 72 6d 69 73 73 | 69 6f 6e 73 20 28 43 74 | Permiss|ions (Ct|
|00005710| 72 6c 2b 53 68 69 66 74 | 2b 57 29 2e 20 3c 41 3d |rl+Shift|+W). <A=|
|00005720| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00005730| 20 20 20 20 20 20 3d 0d | 0a 68 72 65 66 3d 33 44 | =.|.href=3D|
|00005740| 22 68 74 74 70 3a 2f 2f | 77 77 77 2e 77 65 62 79 |"http://|www.weby|
|00005750| 6f 67 2e 63 6f 6d 2f 73 | 71 6c 79 6f 67 2f 73 71 |og.com/s|qlyog/sq|
|00005760| 6c 79 6f 67 69 6d 61 67 | 65 73 2f 69 6d 61 67 65 |lyogimag|es/image|
|00005770| 33 32 2e 67 69 66 22 3e | 63 6c 69 63 6b 3d 32 30 |32.gif">|click=20|
|00005780| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00005790| 20 20 20 20 68 65 72 65 | 20 74 6f 20 73 65 65 20 | here| to see |
|000057a0| 61 20 73 63 72 65 65 6e | 73 68 6f 74 20 6f 66 20 |a screen|shot of |
|000057b0| 6d 61 6e 61 67 65 20 70 | 65 72 6d 69 73 73 69 6f |manage p|ermissio|
|000057c0| 6e 73 3c 2f 41 3e 3c 2f | 50 3e 0d 0a 20 20 20 20 |ns</A></|P>.. |
|000057d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 50 | | <P|
|000057e0| 20 63 6c 61 73 73 3d 33 | 44 71 75 65 73 74 69 6f | class=3|Dquestio|
|000057f0| 6e 20 61 6c 69 67 6e 3d | 33 44 6c 65 66 74 3e 51 |n align=|3Dleft>Q|
|00005800| 2e 20 4d 79 20 4d 79 53 | 51 4c 20 53 65 72 76 65 |. My MyS|QL Serve|
|00005810| 72 20 69 73 20 3d 0d 0a | 68 6f 73 74 65 64 20 77 |r is =..|hosted w|
|00005820| 69 74 68 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ith=20..| |
|00005830| 20 20 20 20 20 20 20 20 | 20 20 61 6e 20 49 53 50 | | an ISP|
|00005840| 2e 20 48 6f 77 20 63 61 | 6e 20 53 51 4c 79 6f 67 |. How ca|n SQLyog|
|00005850| 20 68 65 6c 70 20 6d 65 | 20 69 6e 20 72 65 6d 6f | help me| in remo|
|00005860| 74 65 20 3d 0d 0a 61 64 | 6d 69 6e 69 73 74 72 61 |te =..ad|ministra|
|00005870| 74 69 6f 6e 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |tion=20.|. |
|00005880| 20 20 20 20 20 20 20 20 | 20 20 20 3f 3c 42 52 3e | | ?<BR>|
|00005890| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|000058a0| 20 20 20 20 20 20 20 20 | 3c 50 20 61 6c 69 67 6e | |<P align|
|000058b0| 3d 33 44 6c 65 66 74 3e | 41 2e 20 53 51 4c 79 6f |=3Dleft>|A. SQLyo|
|000058c0| 67 20 68 61 73 20 62 65 | 65 6e 20 73 70 65 63 69 |g has be|en speci|
|000058d0| 61 6c 6c 79 20 64 65 73 | 69 67 6e 65 64 20 3d 0d |ally des|igned =.|
|000058e0| 0a 74 6f 20 77 6f 72 6b | 20 6f 6e 3d 32 30 0d 0a |.to work| on=20..|
|000058f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005900| 20 20 72 65 6d 6f 74 65 | 20 63 6f 6e 6e 65 63 74 | remote| connect|
|00005910| 69 6f 6e 73 2e 20 49 74 | 20 69 73 20 76 65 72 79 |ions. It| is very|
|00005920| 20 65 66 66 69 63 69 65 | 6e 74 20 6f 6e 20 6e 65 | efficie|nt on ne|
|00005930| 74 77 6f 72 6b 20 3d 0d | 0a 62 61 6e 64 77 69 64 |twork =.|.bandwid|
|00005940| 74 68 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |th=20.. | |
|00005950| 20 20 20 20 20 20 20 20 | 20 67 69 76 69 6e 67 20 | | giving |
|00005960| 79 6f 75 20 74 68 65 20 | 62 65 73 74 20 70 6f 73 |you the |best pos|
|00005970| 73 69 62 6c 65 20 65 6e | 76 69 72 6f 6e 6d 65 6e |sible en|vironmen|
|00005980| 74 20 74 6f 20 77 6f 72 | 6b 20 77 69 74 68 20 3d |t to wor|k with =|
|00005990| 0d 0a 4d 79 53 51 4c 3d | 32 30 0d 0a 20 20 20 20 |..MySQL=|20.. |
|000059a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 73 65 | | se|
|000059b0| 72 76 65 72 20 6f 6e 20 | 72 65 6d 6f 74 65 20 63 |rver on |remote c|
|000059c0| 6f 6e 6e 65 63 74 69 6f | 6e 73 2e 20 3c 2f 50 3e |onnectio|ns. </P>|
|000059d0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000059e0| 20 20 20 20 3c 50 20 63 | 6c 61 73 73 3d 33 44 71 | <P c|lass=3Dq|
|000059f0| 75 65 73 74 69 6f 6e 20 | 61 6c 69 67 6e 3d 33 44 |uestion |align=3D|
|00005a00| 6c 65 66 74 3e 51 2e 20 | 49 20 68 61 76 65 20 61 |left>Q. |I have a|
|00005a10| 20 62 75 6e 63 68 20 6f | 66 3d 32 30 0d 0a 20 20 | bunch o|f=20.. |
|00005a20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005a30| 61 64 6d 69 6e 69 73 74 | 72 61 74 69 76 65 20 53 |administ|rative S|
|00005a40| 51 4c 20 73 63 72 69 70 | 74 73 20 77 68 69 63 68 |QL scrip|ts which|
|00005a50| 20 49 20 75 73 65 20 66 | 72 65 71 75 65 6e 74 6c | I use f|requentl|
|00005a60| 79 2e 20 49 20 3d 0d 0a | 64 6f 6e 27 74 3d 32 30 |y. I =..|don't=20|
|00005a70| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00005a80| 20 20 20 20 77 61 6e 74 | 20 74 6f 20 73 61 76 65 | want| to save|
|00005a90| 20 61 6e 64 20 6c 6f 61 | 64 20 66 69 6c 65 73 20 | and loa|d files |
|00005aa0| 65 76 65 72 79 20 74 69 | 6d 65 20 3f 20 48 6f 77 |every ti|me ? How|
|00005ab0| 20 63 61 6e 20 3d 0d 0a | 53 51 4c 79 6f 67 20 68 | can =..|SQLyog h|
|00005ac0| 65 6c 70 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |elp=20..| |
|00005ad0| 20 20 20 20 20 20 20 20 | 20 20 6d 65 20 69 6e 20 | | me in |
|00005ae0| 73 61 76 69 6e 67 20 74 | 69 6d 65 20 3f 3c 2f 50 |saving t|ime ?</P|
|00005af0| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00005b00| 20 20 20 20 20 3c 50 20 | 61 6c 69 67 6e 3d 33 44 | <P |align=3D|
|00005b10| 6c 65 66 74 3e 41 2e 20 | 53 51 4c 79 6f 67 20 61 |left>A. |SQLyog a|
|00005b20| 6c 6c 6f 77 73 20 79 6f | 75 20 6b 65 65 70 20 79 |llows yo|u keep y|
|00005b30| 6f 75 72 20 3d 0d 0a 66 | 72 65 71 75 65 6e 74 6c |our =..f|requentl|
|00005b40| 79 20 75 73 65 64 3d 32 | 30 0d 0a 20 20 20 20 20 |y used=2|0.. |
|00005b50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 53 51 4c | | SQL|
|00005b60| 20 73 63 72 69 70 74 73 | 20 69 6e 20 61 20 50 65 | scripts| in a Pe|
|00005b70| 72 73 6f 6e 61 6c 20 46 | 6f 6c 64 65 72 2e 20 54 |rsonal F|older. T|
|00005b80| 6f 20 73 61 76 65 20 61 | 20 53 51 4c 20 71 75 65 |o save a| SQL que|
|00005b90| 72 79 20 3d 0d 0a 70 72 | 65 73 73 3d 32 30 0d 0a |ry =..pr|ess=20..|
|00005ba0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005bb0| 20 20 43 74 72 6c 2b 53 | 68 69 66 74 2b 46 20 61 | Ctrl+S|hift+F a|
|00005bc0| 6e 64 20 70 72 6f 76 69 | 64 65 20 61 20 6e 61 6d |nd provi|de a nam|
|00005bd0| 65 2e 20 57 68 65 6e 20 | 79 6f 75 20 77 61 6e 74 |e. When |you want|
|00005be0| 20 69 74 20 3d 0d 0a 62 | 61 63 6b 2c 20 70 72 65 | it =..b|ack, pre|
|00005bf0| 73 73 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |ss=20.. | |
|00005c00| 20 20 20 20 20 20 20 20 | 20 43 74 72 6c 2b 53 68 | | Ctrl+Sh|
|00005c10| 69 66 74 2b 50 20 61 6e | 64 20 73 65 6c 65 63 74 |ift+P an|d select|
|00005c20| 20 74 68 65 20 71 75 65 | 72 79 20 6e 61 6d 65 20 | the que|ry name |
|00005c30| 66 72 6f 6d 20 74 68 65 | 20 70 6f 70 75 70 20 3d |from the| popup =|
|00005c40| 0d 0a 6d 65 6e 75 2e 3d | 32 30 0d 0a 20 20 20 20 |..menu.=|20.. |
|00005c50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 53 51 | | SQ|
|00005c60| 4c 79 6f 67 20 61 6c 6c | 6f 77 73 20 79 6f 75 20 |Lyog all|ows you |
|00005c70| 74 6f 20 68 61 76 65 20 | 39 39 20 53 51 4c 20 71 |to have |99 SQL q|
|00005c80| 75 65 72 69 65 73 20 69 | 6e 20 74 68 65 20 3d 0d |ueries i|n the =.|
|00005c90| 0a 70 65 72 73 6f 6e 61 | 6c 3d 32 30 0d 0a 20 20 |.persona|l=20.. |
|00005ca0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005cb0| 66 6f 6c 64 65 72 2e 20 | 3c 41 3d 32 30 0d 0a 20 |folder. |<A=20.. |
|00005cc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005cd0| 20 3d 0d 0a 68 72 65 66 | 3d 33 44 22 68 74 74 70 | =..href|=3D"http|
|00005ce0| 3a 2f 2f 77 77 77 2e 77 | 65 62 79 6f 67 2e 63 6f |://www.w|ebyog.co|
|00005cf0| 6d 2f 73 71 6c 79 6f 67 | 2f 73 71 6c 79 6f 67 69 |m/sqlyog|/sqlyogi|
|00005d00| 6d 61 67 65 73 2f 69 6d | 61 67 65 33 39 2e 67 69 |mages/im|age39.gi|
|00005d10| 66 22 3e 63 6c 69 63 6b | 3d 32 30 0d 0a 20 20 20 |f">click|=20.. |
|00005d20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 68 | | h|
|00005d30| 65 72 65 20 74 6f 20 76 | 69 65 77 20 70 65 72 73 |ere to v|iew pers|
|00005d40| 6f 6e 61 6c 20 66 6f 6c | 64 65 72 20 6d 65 6e 75 |onal fol|der menu|
|00005d50| 3c 2f 41 3e 3c 2f 50 3e | 0d 0a 20 20 20 20 20 20 |</A></P>|.. |
|00005d60| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 50 20 63 | | <P c|
|00005d70| 6c 61 73 73 3d 33 44 71 | 75 65 73 74 69 6f 6e 20 |lass=3Dq|uestion |
|00005d80| 61 6c 69 67 6e 3d 33 44 | 6c 65 66 74 3e 51 2e 20 |align=3D|left>Q. |
|00005d90| 48 6f 77 20 64 6f 20 49 | 20 3d 0d 0a 64 69 61 67 |How do I| =..diag|
|00005da0| 6e 6f 73 65 2f 6f 70 74 | 69 6d 69 7a 65 3d 32 30 |nose/opt|imize=20|
|00005db0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00005dc0| 20 20 20 20 74 61 62 6c | 65 73 20 3f 3c 2f 50 3e | tabl|es ?</P>|
|00005dd0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00005de0| 20 20 20 20 3c 50 20 61 | 6c 69 67 6e 3d 33 44 6c | <P a|lign=3Dl|
|00005df0| 65 66 74 3e 41 2e 20 55 | 73 65 20 54 6f 6f 6c 73 |eft>A. U|se Tools|
|00005e00| 20 2d 26 67 74 3b 20 54 | 61 62 6c 65 20 44 69 61 | -> T|able Dia|
|00005e10| 67 6e 6f 73 74 69 63 73 | 20 3d 0d 0a 61 6e 64 20 |gnostics| =..and |
|00005e20| 73 65 6c 65 63 74 3d 32 | 30 0d 0a 20 20 20 20 20 |select=2|0.. |
|00005e30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 74 68 65 | | the|
|00005e40| 20 64 61 74 61 62 61 73 | 65 20 61 6e 64 20 74 61 | databas|e and ta|
|00005e50| 62 6c 65 73 20 61 6e 64 | 20 63 6c 69 63 6b 20 6f |bles and| click o|
|00005e60| 6e 20 74 68 65 20 6f 70 | 65 72 61 74 69 6f 6e 20 |n the op|eration |
|00005e70| 79 6f 75 20 3d 0d 0a 77 | 61 6e 74 20 74 6f 3d 32 |you =..w|ant to=2|
|00005e80| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00005e90| 20 20 20 20 20 70 65 72 | 66 6f 72 6d 2e 20 53 51 | per|form. SQ|
|00005ea0| 4c 79 6f 67 20 70 72 6f | 76 69 64 65 73 20 61 6c |Lyog pro|vides al|
|00005eb0| 6c 20 74 79 70 65 73 20 | 6f 66 20 64 69 61 67 6e |l types |of diagn|
|00005ec0| 6f 73 74 69 63 73 20 3d | 0d 0a 70 72 6f 76 69 64 |ostics =|..provid|
|00005ed0| 65 64 20 62 79 3d 32 30 | 0d 0a 20 20 20 20 20 20 |ed by=20|.. |
|00005ee0| 20 20 20 20 20 20 20 20 | 20 20 20 20 4d 79 53 51 | | MySQ|
|00005ef0| 4c 20 77 69 74 68 20 61 | 20 73 69 6e 67 6c 65 20 |L with a| single |
|00005f00| 63 6c 69 63 6b 2e 20 3c | 41 3d 32 30 0d 0a 20 20 |click. <|A=20.. |
|00005f10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005f20| 3d 0d 0a 68 72 65 66 3d | 33 44 22 68 74 74 70 3a |=..href=|3D"http:|
|00005f30| 2f 2f 77 77 77 2e 77 65 | 62 79 6f 67 2e 63 6f 6d |//www.we|byog.com|
|00005f40| 2f 73 71 6c 79 6f 67 2f | 73 71 6c 79 6f 67 69 6d |/sqlyog/|sqlyogim|
|00005f50| 61 67 65 73 2f 69 6d 61 | 67 65 32 39 2e 67 69 66 |ages/ima|ge29.gif|
|00005f60| 22 3e 63 6c 69 63 6b 3d | 32 30 0d 0a 20 20 20 20 |">click=|20.. |
|00005f70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 68 65 | | he|
|00005f80| 72 65 20 74 6f 20 73 65 | 65 20 61 20 73 63 72 65 |re to se|e a scre|
|00005f90| 65 6e 73 68 6f 74 20 6f | 66 20 74 61 62 6c 65 20 |enshot o|f table |
|00005fa0| 64 69 61 67 6e 6f 73 74 | 69 63 73 20 64 69 61 6c |diagnost|ics dial|
|00005fb0| 6f 67 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |og=20.. | |
|00005fc0| 20 20 20 20 20 20 20 20 | 20 62 6f 78 3c 2f 41 3e | | box</A>|
|00005fd0| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00005fe0| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|00005ff0| 3d 33 44 74 65 78 74 20 | 61 6c 69 67 6e 3d 33 44 |=3Dtext |align=3D|
|00006000| 6c 65 66 74 3e 26 6e 62 | 73 70 3b 3c 2f 50 3e 0d |left>&nb|sp;</P>.|
|00006010| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00006020| 20 20 20 3c 44 49 56 20 | 69 64 3d 33 44 4c 61 79 | <DIV |id=3DLay|
|00006030| 65 72 31 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |er1=20..| |
|00006040| 20 20 20 20 20 20 20 20 | 20 20 73 74 79 6c 65 3d | | style=|
|00006050| 33 44 22 5a 2d 49 4e 44 | 45 58 3a 20 31 3b 20 4c |3D"Z-IND|EX: 1; L|
|00006060| 45 46 54 3a 20 34 37 30 | 70 78 3b 20 56 49 53 49 |EFT: 470|px; VISI|
|00006070| 42 49 4c 49 54 59 3a 20 | 68 69 64 64 65 6e 3b 20 |BILITY: |hidden; |
|00006080| 3d 0d 0a 57 49 44 54 48 | 3a 20 32 30 30 70 78 3b |=..WIDTH|: 200px;|
|00006090| 20 50 4f 53 49 54 49 4f | 4e 3a 20 61 62 73 6f 6c | POSITIO|N: absol|
|000060a0| 75 74 65 3b 20 54 4f 50 | 3a 20 31 30 34 33 70 78 |ute; TOP|: 1043px|
|000060b0| 3b 20 48 45 49 47 48 54 | 3a 20 31 31 35 70 78 22 |; HEIGHT|: 115px"|
|000060c0| 3e 77 65 62 79 6f 67 3d | 32 30 0d 0a 20 20 20 20 |>webyog=|20.. |
|000060d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 6d 79 | | my|
|000060e0| 73 71 6c 79 6f 67 20 73 | 71 6c 79 6f 67 20 6d 79 |sqlyog s|qlyog my|
|000060f0| 73 71 6c 20 66 72 6f 6e | 74 20 65 6e 64 20 6d 79 |sql fron|t end my|
|00006100| 73 71 6c 20 63 6c 69 65 | 6e 74 20 6d 79 73 71 6c |sql clie|nt mysql|
|00006110| 20 3d 0d 0a 71 75 65 72 | 79 3d 32 30 0d 0a 20 20 | =..quer|y=20.. |
|00006120| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006130| 61 6e 61 6c 79 7a 65 72 | 20 73 71 6c 20 6d 79 73 |analyzer| sql mys|
|00006140| 71 6c 20 47 55 49 20 73 | 74 72 75 63 74 75 72 65 |ql GUI s|tructure|
|00006150| 64 20 71 75 65 72 79 20 | 6c 61 6e 67 75 61 67 65 |d query |language|
|00006160| 20 6d 79 73 71 6c 20 3d | 0d 0a 77 69 6e 64 6f 77 | mysql =|..window|
|00006170| 73 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |s=20.. | |
|00006180| 20 20 20 20 20 20 20 20 | 74 6f 6f 6c 20 65 64 69 | |tool edi|
|00006190| 74 6f 72 20 66 72 6f 6e | 74 20 65 6e 64 20 66 72 |tor fron|t end fr|
|000061a0| 6f 6e 74 2d 65 6e 64 20 | 67 75 69 20 67 72 61 70 |ont-end |gui grap|
|000061b0| 68 69 63 61 6c 20 63 6c | 69 65 6e 74 20 3d 0d 0a |hical cl|ient =..|
|000061c0| 71 75 65 72 79 3d 32 30 | 0d 0a 20 20 20 20 20 20 |query=20|.. |
|000061d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 61 6e 61 6c | | anal|
|000061e0| 79 7a 65 72 20 64 65 76 | 65 6c 6f 70 6d 65 6e 74 |yzer dev|elopment|
|000061f0| 20 65 6e 76 69 72 6f 6e | 6d 65 6e 74 20 49 44 45 | environ|ment IDE|
|00006200| 20 77 69 6e 33 32 20 73 | 69 6d 70 6c 65 20 66 61 | win32 s|imple fa|
|00006210| 73 74 20 3d 0d 0a 65 61 | 73 79 3d 32 30 0d 0a 20 |st =..ea|sy=20.. |
|00006220| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006230| 20 62 65 67 69 6e 6e 65 | 72 20 64 75 6d 6d 79 3c | beginne|r dummy<|
|00006240| 2f 44 49 56 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 |/DIV>.. | |
|00006250| 20 20 20 20 20 20 20 20 | 20 3c 50 3e 3c 2f 50 3e | | <P></P>|
|00006260| 3c 2f 54 44 3e 3c 2f 54 | 52 3e 0d 0a 20 20 20 20 |</TD></T|R>.. |
|00006270| 20 20 20 20 20 20 20 20 | 20 20 3c 54 52 3e 0d 0a | | <TR>..|
|00006280| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006290| 3c 54 44 3e 26 6e 62 73 | 70 3b 3c 2f 54 44 3e 3c |<TD>&nbs|p;</TD><|
|000062a0| 2f 54 52 3e 3c 2f 54 42 | 4f 44 59 3e 3c 2f 54 41 |/TR></TB|ODY></TA|
|000062b0| 42 4c 45 3e 3c 2f 54 44 | 3e 0d 0a 20 20 20 20 20 |BLE></TD|>.. |
|000062c0| 20 20 20 20 20 3c 54 44 | 20 76 41 6c 69 67 6e 3d | <TD| vAlign=|
|000062d0| 33 44 74 6f 70 20 77 69 | 64 74 68 3d 33 44 22 32 |3Dtop wi|dth=3D"2|
|000062e0| 30 25 22 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |0%">.. | |
|000062f0| 20 20 3c 44 49 56 20 61 | 6c 69 67 6e 3d 33 44 63 | <DIV a|lign=3Dc|
|00006300| 65 6e 74 65 72 3e 3c 42 | 52 3e 3c 21 2d 2d 20 23 |enter><B|R><!-- #|
|00006310| 42 65 67 69 6e 4c 69 62 | 72 61 72 79 49 74 65 6d |BeginLib|raryItem|
|00006320| 20 3d 0d 0a 22 2f 4c 69 | 62 72 61 72 79 2f 6d 79 | =.."/Li|brary/my|
|00006330| 73 71 6c 79 6f 67 73 69 | 64 65 2e 6c 62 69 22 20 |sqlyogsi|de.lbi" |
|00006340| 2d 2d 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |-->.. | |
|00006350| 20 3c 54 41 42 4c 45 20 | 68 65 69 67 68 74 3d 33 | <TABLE |height=3|
|00006360| 44 38 35 20 63 65 6c 6c | 53 70 61 63 69 6e 67 3d |D85 cell|Spacing=|
|00006370| 33 44 30 20 63 65 6c 6c | 50 61 64 64 69 6e 67 3d |3D0 cell|Padding=|
|00006380| 33 44 35 20 3d 0d 0a 77 | 69 64 74 68 3d 33 44 22 |3D5 =..w|idth=3D"|
|00006390| 39 30 25 22 20 62 6f 72 | 64 65 72 3d 33 44 30 3e |90%" bor|der=3D0>|
|000063a0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000063b0| 3c 54 42 4f 44 59 3e 0d | 0a 20 20 20 20 20 20 20 |<TBODY>.|. |
|000063c0| 20 20 20 20 20 20 20 3c | 54 52 3e 0d 0a 20 20 20 | <|TR>.. |
|000063d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 54 44 | | <TD|
|000063e0| 20 62 67 43 6f 6c 6f 72 | 3d 33 44 23 33 33 33 33 | bgColor|=3D#3333|
|000063f0| 36 36 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |66>.. | |
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
