home *** CD-ROM | disk | FTP | other *** search
| MIME HTML Archive | 2004-05-10 | 84.2 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 |
| 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
|
|
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 4d 79 53 51 4c 20 41 |Subject:| MySQL A|
|00000040| 64 6d 69 6e 20 3a 20 53 | 51 4c 79 6f 67 20 2d 20 |dmin : S|QLyog - |
|00000050| 54 68 65 20 6d 6f 73 74 | 20 70 6f 70 75 6c 61 72 |The most| popular|
|00000060| 20 74 6f 6f 6c 20 66 6f | 72 20 4d 79 53 51 4c 0d | tool fo|r MySQL.|
|00000070| 0a 44 61 74 65 3a 20 57 | 65 64 2c 20 32 36 20 4e |.Date: W|ed, 26 N|
|00000080| 6f 76 20 32 30 30 33 20 | 32 30 3a 34 34 3a 32 31 |ov 2003 |20:44:21|
|00000090| 20 2b 30 35 33 30 0d 0a | 4d 49 4d 45 2d 56 65 72 | +0530..|MIME-Ver|
|000000a0| 73 69 6f 6e 3a 20 31 2e | 30 0d 0a 43 6f 6e 74 65 |sion: 1.|0..Conte|
|000000b0| 6e 74 2d 54 79 70 65 3a | 20 6d 75 6c 74 69 70 61 |nt-Type:| multipa|
|000000c0| 72 74 2f 72 65 6c 61 74 | 65 64 3b 0d 0a 09 62 6f |rt/relat|ed;...bo|
|000000d0| 75 6e 64 61 72 79 3d 22 | 2d 2d 2d 2d 3d 5f 4e 65 |undary="|----=_Ne|
|000000e0| 78 74 50 61 72 74 5f 30 | 30 30 5f 30 30 30 30 5f |xtPart_0|00_0000_|
|000000f0| 30 31 43 33 42 34 35 45 | 2e 31 31 45 41 43 35 37 |01C3B45E|.11EAC57|
|00000100| 30 22 3b 0d 0a 09 74 79 | 70 65 3d 22 74 65 78 74 |0";...ty|pe="text|
|00000110| 2f 68 74 6d 6c 22 0d 0a | 58 2d 4d 69 6d 65 4f 4c |/html"..|X-MimeOL|
|00000120| 45 3a 20 50 72 6f 64 75 | 63 65 64 20 42 79 20 4d |E: Produ|ced By M|
|00000130| 69 63 72 6f 73 6f 66 74 | 20 4d 69 6d 65 4f 4c 45 |icrosoft| MimeOLE|
|00000140| 20 56 36 2e 30 30 2e 32 | 38 30 30 2e 31 31 30 36 | V6.00.2|800.1106|
|00000150| 0d 0a 0d 0a 54 68 69 73 | 20 69 73 20 61 20 6d 75 |....This| is a mu|
|00000160| 6c 74 69 2d 70 61 72 74 | 20 6d 65 73 73 61 67 65 |lti-part| message|
|00000170| 20 69 6e 20 4d 49 4d 45 | 20 66 6f 72 6d 61 74 2e | in MIME| format.|
|00000180| 0d 0a 0d 0a 2d 2d 2d 2d | 2d 2d 3d 5f 4e 65 78 74 |....----|--=_Next|
|00000190| 50 61 72 74 5f 30 30 30 | 5f 30 30 30 30 5f 30 31 |Part_000|_0000_01|
|000001a0| 43 33 42 34 35 45 2e 31 | 31 45 41 43 35 37 30 0d |C3B45E.1|1EAC570.|
|000001b0| 0a 43 6f 6e 74 65 6e 74 | 2d 54 79 70 65 3a 20 74 |.Content|-Type: t|
|000001c0| 65 78 74 2f 68 74 6d 6c | 3b 0d 0a 09 63 68 61 72 |ext/html|;...char|
|000001d0| 73 65 74 3d 22 69 73 6f | 2d 38 38 35 39 2d 31 22 |set="iso|-8859-1"|
|000001e0| 0d 0a 43 6f 6e 74 65 6e | 74 2d 54 72 61 6e 73 66 |..Conten|t-Transf|
|000001f0| 65 72 2d 45 6e 63 6f 64 | 69 6e 67 3a 20 71 75 6f |er-Encod|ing: quo|
|00000200| 74 65 64 2d 70 72 69 6e | 74 61 62 6c 65 0d 0a 43 |ted-prin|table..C|
|00000210| 6f 6e 74 65 6e 74 2d 4c | 6f 63 61 74 69 6f 6e 3a |ontent-L|ocation:|
|00000220| 20 68 74 74 70 3a 2f 2f | 77 77 77 2e 77 65 62 79 | http://|www.weby|
|00000230| 6f 67 2e 63 6f 6d 2f 73 | 71 6c 79 6f 67 2f 66 61 |og.com/s|qlyog/fa|
|00000240| 71 2e 68 74 6d 6c 0d 0a | 0d 0a 3c 21 44 4f 43 54 |q.html..|..<!DOCT|
|00000250| 59 50 45 20 48 54 4d 4c | 20 50 55 42 4c 49 43 20 |YPE HTML| PUBLIC |
|00000260| 22 2d 2f 2f 57 33 43 2f | 2f 44 54 44 20 48 54 4d |"-//W3C/|/DTD HTM|
|00000270| 4c 20 34 2e 30 20 54 72 | 61 6e 73 69 74 69 6f 6e |L 4.0 Tr|ansition|
|00000280| 61 6c 2f 2f 45 4e 22 3e | 0d 0a 3c 48 54 4d 4c 3e |al//EN">|..<HTML>|
|00000290| 3c 48 45 41 44 3e 3c 54 | 49 54 4c 45 3e 4d 79 53 |<HEAD><T|ITLE>MyS|
|000002a0| 51 4c 20 41 64 6d 69 6e | 20 3a 20 53 51 4c 79 6f |QL Admin| : SQLyo|
|000002b0| 67 20 2d 20 54 68 65 20 | 6d 6f 73 74 20 70 6f 70 |g - The |most pop|
|000002c0| 75 6c 61 72 20 74 6f 6f | 6c 20 66 6f 72 20 3d 0d |ular too|l for =.|
|000002d0| 0a 4d 79 53 51 4c 3c 2f | 54 49 54 4c 45 3e 3c 4c |.MySQL</|TITLE><L|
|000002e0| 49 4e 4b 3d 32 30 0d 0a | 68 72 65 66 3d 33 44 22 |INK=20..|href=3D"|
|000002f0| 68 74 74 70 3a 2f 2f 77 | 77 77 2e 77 65 62 79 6f |http://w|ww.webyo|
|00000300| 67 2e 63 6f 6d 2f 6d 79 | 73 71 6c 79 6f 67 2f 77 |g.com/my|sqlyog/w|
|00000310| 65 62 73 74 79 6c 65 2e | 63 73 73 22 20 72 65 6c |ebstyle.|css" rel|
|00000320| 3d 33 44 73 74 79 6c 65 | 73 68 65 65 74 3e 0d 0a |=3Dstyle|sheet>..|
|00000330| 3c 4d 45 54 41 20 68 74 | 74 70 2d 65 71 75 69 76 |<META ht|tp-equiv|
|00000340| 3d 33 44 43 6f 6e 74 65 | 6e 74 2d 54 79 70 65 20 |=3DConte|nt-Type |
|00000350| 63 6f 6e 74 65 6e 74 3d | 33 44 22 74 65 78 74 2f |content=|3D"text/|
|00000360| 68 74 6d 6c 3b 20 3d 0d | 0a 63 68 61 72 73 65 74 |html; =.|.charset|
|00000370| 3d 33 44 69 73 6f 2d 38 | 38 35 39 2d 31 22 3e 0d |=3Diso-8|859-1">.|
|00000380| 0a 3c 4d 45 54 41 3d 32 | 30 0d 0a 63 6f 6e 74 65 |.<META=2|0..conte|
|00000390| 6e 74 3d 33 44 22 6d 79 | 73 71 6c 2c 20 6d 61 6e |nt=3D"my|sql, man|
|000003a0| 61 67 65 72 2c 20 73 71 | 6c 2c 20 64 61 74 61 62 |ager, sq|l, datab|
|000003b0| 61 73 65 2c 20 61 64 6d | 69 6e 69 73 74 72 61 74 |ase, adm|inistrat|
|000003c0| 69 6f 6e 2c 20 67 75 69 | 2c 20 71 75 65 72 79 2c |ion, gui|, query,|
|000003d0| 20 3d 0d 0a 74 61 62 6c | 65 2c 20 61 63 63 65 73 | =..tabl|e, acces|
|000003e0| 73 2c 20 6d 79 61 64 6d | 69 6e 2c 20 6d 79 73 71 |s, myadm|in, mysq|
|000003f0| 6c 66 72 6f 6e 74 2c 20 | 61 64 6d 69 6e 2c 20 74 |lfront, |admin, t|
|00000400| 6f 6f 6c 2c 20 6d 61 6e | 61 67 65 6d 65 6e 74 2c |ool, man|agement,|
|00000410| 20 3d 0d 0a 64 65 76 65 | 6c 6f 70 6d 65 6e 74 2c | =..deve|lopment,|
|00000420| 20 70 72 6f 67 72 61 6d | 6d 69 6e 67 2c 20 63 6c | program|ming, cl|
|00000430| 69 65 6e 74 2c 20 73 65 | 72 76 65 72 2c 20 73 71 |ient, se|rver, sq|
|00000440| 6c 79 6f 67 2c 20 77 65 | 62 79 6f 67 2c 20 70 68 |lyog, we|byog, ph|
|00000450| 70 20 6d 79 73 71 6c 2c | 20 3d 0d 0a 65 64 69 74 |p mysql,| =..edit|
|00000460| 6f 72 2c 20 65 6d 73 2c | 20 68 69 74 65 63 68 2c |or, ems,| hitech,|
|00000470| 20 70 68 70 6d 79 61 64 | 6d 69 6e 2c 20 6d 79 73 | phpmyad|min, mys|
|00000480| 71 6c 67 75 69 2c 20 73 | 6f 66 74 77 61 72 65 2c |qlgui, s|oftware,|
|00000490| 20 70 72 6f 67 72 61 6d | 6d 69 6e 67 2c 20 3d 0d | program|ming, =.|
|000004a0| 0a 64 65 76 65 6c 6f 70 | 6d 65 6e 74 2c 20 64 65 |.develop|ment, de|
|000004b0| 76 65 6c 6f 70 65 72 2c | 20 63 6c 69 65 6e 74 2c |veloper,| client,|
|000004c0| 20 73 65 72 76 65 72 2c | 20 6f 70 74 69 6d 69 7a | server,| optimiz|
|000004d0| 61 74 69 6f 6e 22 3d 32 | 30 0d 0a 6e 61 6d 65 3d |ation"=2|0..name=|
|000004e0| 33 44 6b 65 79 77 6f 72 | 64 73 3e 0d 0a 3c 4d 45 |3Dkeywor|ds>..<ME|
|000004f0| 54 41 3d 32 30 0d 0a 63 | 6f 6e 74 65 6e 74 3d 33 |TA=20..c|ontent=3|
|00000500| 44 22 4d 79 53 51 4c 20 | 41 64 6d 69 6e 69 73 74 |D"MySQL |Administ|
|00000510| 72 61 74 69 6f 6e 20 54 | 6f 6f 6c 2e 20 57 65 62 |ration T|ool. Web|
|00000520| 79 6f 67 20 2d 20 54 68 | 65 20 42 65 73 74 20 53 |yog - Th|e Best S|
|00000530| 6f 6c 75 74 69 6f 6e 73 | 20 66 6f 72 20 3d 0d 0a |olutions| for =..|
|00000540| 74 68 65 20 4d 79 53 51 | 4c 20 50 72 6f 66 65 73 |the MySQ|L Profes|
|00000550| 73 69 6f 6e 61 6c 73 2e | 22 3d 32 30 0d 0a 6e 61 |sionals.|"=20..na|
|00000560| 6d 65 3d 33 44 64 65 73 | 63 72 69 70 74 69 6f 6e |me=3Ddes|cription|
|00000570| 3e 0d 0a 3c 4d 45 54 41 | 20 63 6f 6e 74 65 6e 74 |>..<META| content|
|00000580| 3d 33 44 22 69 6e 64 65 | 78 2c 20 66 6f 6c 6c 6f |=3D"inde|x, follo|
|00000590| 77 22 20 6e 61 6d 65 3d | 33 44 72 6f 62 6f 74 73 |w" name=|3Drobots|
|000005a0| 3e 0d 0a 3c 4d 45 54 41 | 20 63 6f 6e 74 65 6e 74 |>..<META| content|
|000005b0| 3d 33 44 22 33 30 20 64 | 61 79 73 22 20 6e 61 6d |=3D"30 d|ays" nam|
|000005c0| 65 3d 33 44 72 65 76 69 | 73 69 74 2d 61 66 74 65 |e=3Drevi|sit-afte|
|000005d0| 72 3e 3c 4c 49 4e 4b 3d | 32 30 0d 0a 68 72 65 66 |r><LINK=|20..href|
|000005e0| 3d 33 44 22 68 74 74 70 | 3a 2f 2f 77 77 77 2e 77 |=3D"http|://www.w|
|000005f0| 65 62 79 6f 67 2e 63 6f | 6d 2f 77 65 62 73 74 79 |ebyog.co|m/websty|
|00000600| 6c 65 2e 63 73 73 22 20 | 74 79 70 65 3d 33 44 74 |le.css" |type=3Dt|
|00000610| 65 78 74 2f 63 73 73 20 | 3d 0d 0a 72 65 6c 3d 33 |ext/css |=..rel=3|
|00000620| 44 73 74 79 6c 65 73 68 | 65 65 74 3e 0d 0a 3c 4d |Dstylesh|eet>..<M|
|00000630| 45 54 41 20 63 6f 6e 74 | 65 6e 74 3d 33 44 22 4d |ETA cont|ent=3D"M|
|00000640| 53 48 54 4d 4c 20 36 2e | 30 30 2e 32 38 30 30 2e |SHTML 6.|00.2800.|
|00000650| 31 31 30 36 22 20 6e 61 | 6d 65 3d 33 44 47 45 4e |1106" na|me=3DGEN|
|00000660| 45 52 41 54 4f 52 3e 3c | 2f 48 45 41 44 3e 0d 0a |ERATOR><|/HEAD>..|
|00000670| 3c 42 4f 44 59 20 74 65 | 78 74 3d 33 44 23 30 30 |<BODY te|xt=3D#00|
|00000680| 30 30 30 30 20 62 67 43 | 6f 6c 6f 72 3d 33 44 23 |0000 bgC|olor=3D#|
|00000690| 66 66 66 66 66 66 20 6c | 65 66 74 4d 61 72 67 69 |ffffff l|eftMargi|
|000006a0| 6e 3d 33 44 30 20 74 6f | 70 4d 61 72 67 69 6e 3d |n=3D0 to|pMargin=|
|000006b0| 33 44 30 20 3d 0d 0a 6d | 61 72 67 69 6e 68 65 69 |3D0 =..m|arginhei|
|000006c0| 67 68 74 3d 33 44 22 30 | 22 3d 32 30 0d 0a 6d 61 |ght=3D"0|"=20..ma|
|000006d0| 72 67 69 6e 77 69 64 74 | 68 3d 33 44 22 30 22 3e |rginwidt|h=3D"0">|
|000006e0| 0d 0a 3c 54 41 42 4c 45 | 20 63 65 6c 6c 53 70 61 |..<TABLE| cellSpa|
|000006f0| 63 69 6e 67 3d 33 44 30 | 20 63 65 6c 6c 50 61 64 |cing=3D0| cellPad|
|00000700| 64 69 6e 67 3d 33 44 30 | 20 77 69 64 74 68 3d 33 |ding=3D0| width=3|
|00000710| 44 22 31 30 30 25 22 20 | 62 6f 72 64 65 72 3d 33 |D"100%" |border=3|
|00000720| 44 30 3e 0d 0a 20 20 3c | 54 42 4f 44 59 3e 0d 0a |D0>.. <|TBODY>..|
|00000730| 20 20 3c 54 52 3e 0d 0a | 20 20 20 20 3c 54 44 3e | <TR>..| <TD>|
|00000740| 0d 0a 20 20 20 20 20 20 | 3c 54 41 42 4c 45 20 63 |.. |<TABLE c|
|00000750| 65 6c 6c 53 70 61 63 69 | 6e 67 3d 33 44 30 20 63 |ellSpaci|ng=3D0 c|
|00000760| 65 6c 6c 50 61 64 64 69 | 6e 67 3d 33 44 30 20 77 |ellPaddi|ng=3D0 w|
|00000770| 69 64 74 68 3d 33 44 22 | 31 30 30 25 22 20 62 6f |idth=3D"|100%" bo|
|00000780| 72 64 65 72 3d 33 44 30 | 3e 0d 0a 20 20 20 20 20 |rder=3D0|>.. |
|00000790| 20 20 20 3c 54 42 4f 44 | 59 3e 0d 0a 20 20 20 20 | <TBOD|Y>.. |
|000007a0| 20 20 20 20 3c 54 52 3e | 0d 0a 20 20 20 20 20 20 | <TR>|.. |
|000007b0| 20 20 20 20 3c 54 44 20 | 76 41 6c 69 67 6e 3d 33 | <TD |vAlign=3|
|000007c0| 44 74 6f 70 20 63 6f 6c | 53 70 61 6e 3d 33 44 33 |Dtop col|Span=3D3|
|000007d0| 3e 3c 49 4d 47 20 68 65 | 69 67 68 74 3d 33 44 36 |><IMG he|ight=3D6|
|000007e0| 30 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |0=20.. | |
|000007f0| 20 20 73 72 63 3d 33 44 | 22 68 74 74 70 3a 2f 2f | src=3D|"http://|
|00000800| 77 77 77 2e 77 65 62 79 | 6f 67 2e 63 6f 6d 2f 69 |www.weby|og.com/i|
|00000810| 6d 61 67 65 73 2f 77 65 | 62 62 61 6e 2e 6a 70 67 |mages/we|bban.jpg|
|00000820| 22 20 3d 0d 0a 77 69 64 | 74 68 3d 33 44 36 30 30 |" =..wid|th=3D600|
|00000830| 3e 3c 2f 54 44 3e 3c 2f | 54 52 3e 0d 0a 20 20 20 |></TD></|TR>.. |
|00000840| 20 20 20 20 20 3c 54 52 | 3e 0d 0a 20 20 20 20 20 | <TR|>.. |
|00000850| 20 20 20 20 20 3c 54 44 | 20 76 41 6c 69 67 6e 3d | <TD| vAlign=|
|00000860| 33 44 74 6f 70 20 77 69 | 64 74 68 3d 33 44 22 32 |3Dtop wi|dth=3D"2|
|00000870| 30 25 22 20 62 67 43 6f | 6c 6f 72 3d 33 44 23 33 |0%" bgCo|lor=3D#3|
|00000880| 33 33 33 36 36 3e 0d 0a | 20 20 20 20 20 20 20 20 |33366>..| |
|00000890| 20 20 20 20 3c 54 41 42 | 4c 45 20 63 65 6c 6c 53 | <TAB|LE cellS|
|000008a0| 70 61 63 69 6e 67 3d 33 | 44 30 20 63 65 6c 6c 50 |pacing=3|D0 cellP|
|000008b0| 61 64 64 69 6e 67 3d 33 | 44 30 20 77 69 64 74 68 |adding=3|D0 width|
|000008c0| 3d 33 44 22 31 30 30 25 | 22 20 3d 0d 0a 62 67 43 |=3D"100%|" =..bgC|
|000008d0| 6f 6c 6f 72 3d 33 44 23 | 33 33 33 33 36 36 3d 32 |olor=3D#|333366=2|
|000008e0| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 62 |0.. | b|
|000008f0| 6f 72 64 65 72 3d 33 44 | 30 3e 0d 0a 20 20 20 20 |order=3D|0>.. |
|00000900| 20 20 20 20 20 20 20 20 | 20 20 3c 54 42 4f 44 59 | | <TBODY|
|00000910| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00000920| 20 3c 54 52 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 | <TR>.. | |
|00000930| 20 20 20 20 20 20 20 3c | 54 44 20 76 41 6c 69 67 | <|TD vAlig|
|00000940| 6e 3d 33 44 74 6f 70 20 | 63 6f 6c 53 70 61 6e 3d |n=3Dtop |colSpan=|
|00000950| 33 44 32 3e 26 6e 62 73 | 70 3b 3c 2f 54 44 3e 0d |3D2>&nbs|p;</TD>.|
|00000960| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00000970| 20 3c 54 44 20 77 69 64 | 74 68 3d 33 44 22 34 25 | <TD wid|th=3D"4%|
|00000980| 22 3e 26 6e 62 73 70 3b | 3c 2f 54 44 3e 3c 2f 54 |"> |</TD></T|
|00000990| 52 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |R>.. | |
|000009a0| 20 20 3c 54 52 3e 0d 0a | 20 20 20 20 20 20 20 20 | <TR>..| |
|000009b0| 20 20 20 20 20 20 20 20 | 3c 54 44 20 76 41 6c 69 | |<TD vAli|
|000009c0| 67 6e 3d 33 44 63 65 6e | 74 65 72 3e 0d 0a 20 20 |gn=3Dcen|ter>.. |
|000009d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000009e0| 3c 44 49 56 20 61 6c 69 | 67 6e 3d 33 44 72 69 67 |<DIV ali|gn=3Drig|
|000009f0| 68 74 3e 3c 46 4f 4e 54 | 3d 32 30 0d 0a 20 20 20 |ht><FONT|=20.. |
|00000a00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 66 | | f|
|00000a10| 61 63 65 3d 33 44 22 56 | 65 72 64 61 6e 61 2c 20 |ace=3D"V|erdana, |
|00000a20| 41 72 69 61 6c 2c 20 48 | 65 6c 76 65 74 69 63 61 |Arial, H|elvetica|
|00000a30| 2c 20 73 61 6e 73 2d 73 | 65 72 69 66 22 20 3d 0d |, sans-s|erif" =.|
|00000a40| 0a 63 6f 6c 6f 72 3d 33 | 44 23 66 66 66 66 66 66 |.color=3|D#ffffff|
|00000a50| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00000a60| 20 20 20 20 20 20 20 73 | 69 7a 65 3d 33 44 32 3e | s|ize=3D2>|
|00000a70| 3c 2f 46 4f 4e 54 3e 3c | 2f 44 49 56 3e 3c 2f 54 |</FONT><|/DIV></T|
|00000a80| 44 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |D>.. | |
|00000a90| 20 20 20 20 3c 54 44 20 | 76 41 6c 69 67 6e 3d 33 | <TD |vAlign=3|
|00000aa0| 44 63 65 6e 74 65 72 20 | 62 67 43 6f 6c 6f 72 3d |Dcenter |bgColor=|
|00000ab0| 33 44 23 33 33 33 33 36 | 36 3e 0d 0a 20 20 20 20 |3D#33336|6>.. |
|00000ac0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 44 | | <D|
|00000ad0| 49 56 20 61 6c 69 67 6e | 3d 33 44 72 69 67 68 74 |IV align|=3Dright|
|00000ae0| 3e 3c 46 4f 4e 54 3d 32 | 30 0d 0a 20 20 20 20 20 |><FONT=2|0.. |
|00000af0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 66 61 63 | | fac|
|00000b00| 65 3d 33 44 22 56 65 72 | 64 61 6e 61 2c 20 41 72 |e=3D"Ver|dana, Ar|
|00000b10| 69 61 6c 2c 20 48 65 6c | 76 65 74 69 63 61 2c 20 |ial, Hel|vetica, |
|00000b20| 73 61 6e 73 2d 73 65 72 | 69 66 22 20 3d 0d 0a 63 |sans-ser|if" =..c|
|00000b30| 6f 6c 6f 72 3d 33 44 23 | 66 66 66 66 66 66 3d 32 |olor=3D#|ffffff=2|
|00000b40| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00000b50| 20 20 20 20 20 73 69 7a | 65 3d 33 44 32 3e 3c 42 | siz|e=3D2><B|
|00000b60| 20 63 6c 61 73 73 3d 33 | 44 6d 65 6e 75 69 74 65 | class=3|Dmenuite|
|00000b70| 6d 3e 3c 41 20 63 6c 61 | 73 73 3d 33 44 6d 65 6e |m><A cla|ss=3Dmen|
|00000b80| 75 69 74 65 6d 3d 32 30 | 0d 0a 20 20 20 20 20 20 |uitem=20|.. |
|00000b90| 20 20 20 20 20 20 20 20 | 20 20 20 20 3d 0d 0a 68 | | =..h|
|00000ba0| 72 65 66 3d 33 44 22 68 | 74 74 70 3a 2f 2f 77 77 |ref=3D"h|ttp://ww|
|00000bb0| 77 2e 77 65 62 79 6f 67 | 2e 63 6f 6d 2f 69 6e 64 |w.webyog|.com/ind|
|00000bc0| 65 78 2e 68 74 6d 6c 22 | 3e 68 6f 6d 65 3c 2f 41 |ex.html"|>home</A|
|00000bd0| 3e 3c 2f 42 3e 3c 2f 46 | 4f 4e 54 3e 3c 2f 44 49 |></B></F|ONT></DI|
|00000be0| 56 3e 3c 2f 54 44 3e 0d | 0a 20 20 20 20 20 20 20 |V></TD>.|. |
|00000bf0| 20 20 20 20 20 20 20 20 | 20 3c 54 44 20 77 69 64 | | <TD wid|
|00000c00| 74 68 3d 33 44 22 34 25 | 22 20 62 67 43 6f 6c 6f |th=3D"4%|" bgColo|
|00000c10| 72 3d 33 44 23 33 33 33 | 33 36 36 3e 26 6e 62 73 |r=3D#333|366>&nbs|
|00000c20| 70 3b 3c 2f 54 44 3e 3c | 2f 54 52 3e 0d 0a 20 20 |p;</TD><|/TR>.. |
|00000c30| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 54 52 3e | | <TR>|
|00000c40| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00000c50| 20 20 3c 54 44 20 76 41 | 6c 69 67 6e 3d 33 44 74 | <TD vA|lign=3Dt|
|00000c60| 6f 70 20 77 69 64 74 68 | 3d 33 44 22 31 35 25 22 |op width|=3D"15%"|
|00000c70| 20 62 67 43 6f 6c 6f 72 | 3d 33 44 23 33 33 33 33 | bgColor|=3D#3333|
|00000c80| 36 36 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |66>.. | |
|00000c90| 20 20 20 20 20 20 20 3c | 44 49 56 20 61 6c 69 67 | <|DIV alig|
|00000ca0| 6e 3d 33 44 72 69 67 68 | 74 3e 3c 46 4f 4e 54 3d |n=3Drigh|t><FONT=|
|00000cb0| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00000cc0| 20 20 20 20 20 20 66 61 | 63 65 3d 33 44 22 56 65 | fa|ce=3D"Ve|
|00000cd0| 72 64 61 6e 61 2c 20 41 | 72 69 61 6c 2c 20 48 65 |rdana, A|rial, He|
|00000ce0| 6c 76 65 74 69 63 61 2c | 20 73 61 6e 73 2d 73 65 |lvetica,| sans-se|
|00000cf0| 72 69 66 22 20 3d 0d 0a | 63 6f 6c 6f 72 3d 33 44 |rif" =..|color=3D|
|00000d00| 23 66 66 66 66 66 66 3d | 32 30 0d 0a 20 20 20 20 |#ffffff=|20.. |
|00000d10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 73 69 | | si|
|00000d20| 7a 65 3d 33 44 32 3e 3c | 2f 46 4f 4e 54 3e 3c 2f |ze=3D2><|/FONT></|
|00000d30| 44 49 56 3e 3c 2f 54 44 | 3e 0d 0a 20 20 20 20 20 |DIV></TD|>.. |
|00000d40| 20 20 20 20 20 20 20 20 | 20 20 20 3c 54 44 20 76 | | <TD v|
|00000d50| 41 6c 69 67 6e 3d 33 44 | 63 65 6e 74 65 72 20 77 |Align=3D|center w|
|00000d60| 69 64 74 68 3d 33 44 22 | 38 31 25 22 20 62 67 43 |idth=3D"|81%" bgC|
|00000d70| 6f 6c 6f 72 3d 33 44 23 | 66 66 66 66 66 66 3e 0d |olor=3D#|ffffff>.|
|00000d80| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00000d90| 20 20 20 3c 44 49 56 20 | 63 6c 61 73 73 3d 33 44 | <DIV |class=3D|
|00000da0| 6d 65 6e 75 69 74 65 6d | 61 63 74 69 76 65 20 3d |menuitem|active =|
|00000db0| 0d 0a 61 6c 69 67 6e 3d | 33 44 72 69 67 68 74 3e |..align=|3Dright>|
|00000dc0| 73 71 6c 79 6f 67 3c 2f | 44 49 56 3e 3c 2f 54 44 |sqlyog</|DIV></TD|
|00000dd0| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00000de0| 20 20 20 3c 54 44 20 77 | 69 64 74 68 3d 33 44 22 | <TD w|idth=3D"|
|00000df0| 34 25 22 20 62 67 43 6f | 6c 6f 72 3d 33 44 23 66 |4%" bgCo|lor=3D#f|
|00000e00| 66 66 66 66 66 3e 26 6e | 62 73 70 3b 3c 2f 54 44 |fffff>&n|bsp;</TD|
|00000e10| 3e 3c 2f 54 52 3e 0d 0a | 20 20 20 20 20 20 20 20 |></TR>..| |
|00000e20| 20 20 20 20 20 20 3c 54 | 52 3e 0d 0a 20 20 20 20 | <T|R>.. |
|00000e30| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 54 44 20 | | <TD |
|00000e40| 76 41 6c 69 67 6e 3d 33 | 44 63 65 6e 74 65 72 3e |vAlign=3|Dcenter>|
|00000e50| 26 6e 62 73 70 3b 3c 2f | 54 44 3e 0d 0a 20 20 20 | </|TD>.. |
|00000e60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 54 44 | | <TD|
|00000e70| 20 76 41 6c 69 67 6e 3d | 33 44 63 65 6e 74 65 72 | vAlign=|3Dcenter|
|00000e80| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00000e90| 20 20 20 20 20 3c 44 49 | 56 20 63 6c 61 73 73 3d | <DI|V class=|
|00000ea0| 33 44 6d 65 6e 75 69 74 | 65 6d 20 61 6c 69 67 6e |3Dmenuit|em align|
|00000eb0| 3d 33 44 72 69 67 68 74 | 3e 3c 41 3d 32 30 0d 0a |=3Dright|><A=20..|
|00000ec0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000ed0| 20 20 3d 0d 0a 68 72 65 | 66 3d 33 44 22 68 74 74 | =..hre|f=3D"htt|
|00000ee0| 70 3a 2f 2f 77 77 77 2e | 77 65 62 79 6f 67 2e 63 |p://www.|webyog.c|
|00000ef0| 6f 6d 2f 73 71 6c 79 6f | 67 2f 62 75 79 73 71 6c |om/sqlyo|g/buysql|
|00000f00| 79 6f 67 2e 68 74 6d 6c | 22 3e 3c 46 4f 4e 54 3d |yog.html|"><FONT=|
|00000f10| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00000f20| 20 20 20 20 20 20 63 6f | 6c 6f 72 3d 33 44 23 66 | co|lor=3D#f|
|00000f30| 66 66 66 66 66 3e 70 75 | 72 63 68 61 73 65 3c 2f |fffff>pu|rchase</|
|00000f40| 46 4f 4e 54 3e 3c 2f 41 | 3e 3c 2f 44 49 56 3e 3c |FONT></A|></DIV><|
|00000f50| 2f 54 44 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |/TD>.. | |
|00000f60| 20 20 20 20 20 20 3c 54 | 44 20 77 69 64 74 68 3d | <T|D width=|
|00000f70| 33 44 22 34 25 22 3e 26 | 6e 62 73 70 3b 3c 2f 54 |3D"4%">&|nbsp;</T|
|00000f80| 44 3e 3c 2f 54 52 3e 0d | 0a 20 20 20 20 20 20 20 |D></TR>.|. |
|00000f90| 20 20 20 20 20 20 20 3c | 54 52 3e 0d 0a 20 20 20 | <|TR>.. |
|00000fa0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 54 44 | | <TD|
|00000fb0| 20 76 41 6c 69 67 6e 3d | 33 44 63 65 6e 74 65 72 | vAlign=|3Dcenter|
|00000fc0| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00000fd0| 20 20 20 20 20 3c 44 49 | 56 20 61 6c 69 67 6e 3d | <DI|V align=|
|00000fe0| 33 44 72 69 67 68 74 3e | 3c 46 4f 4e 54 3d 32 30 |3Dright>|<FONT=20|
|00000ff0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00001000| 20 20 20 20 66 61 63 65 | 3d 33 44 22 56 65 72 64 | face|=3D"Verd|
|00001010| 61 6e 61 2c 20 41 72 69 | 61 6c 2c 20 48 65 6c 76 |ana, Ari|al, Helv|
|00001020| 65 74 69 63 61 2c 20 73 | 61 6e 73 2d 73 65 72 69 |etica, s|ans-seri|
|00001030| 66 22 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |f"=20.. | |
|00001040| 20 20 20 20 20 20 20 20 | 20 73 69 7a 65 3d 33 44 | | size=3D|
|00001050| 32 3e 3c 42 3e 3c 2f 42 | 3e 3c 2f 46 4f 4e 54 3e |2><B></B|></FONT>|
|00001060| 3c 2f 44 49 56 3e 3c 2f | 54 44 3e 0d 0a 20 20 20 |</DIV></|TD>.. |
|00001070| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 54 44 | | <TD|
|00001080| 20 76 41 6c 69 67 6e 3d | 33 44 63 65 6e 74 65 72 | vAlign=|3Dcenter|
|00001090| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|000010a0| 20 20 20 20 20 3c 44 49 | 56 20 61 6c 69 67 6e 3d | <DI|V align=|
|000010b0| 33 44 72 69 67 68 74 3e | 3c 46 4f 4e 54 3d 32 30 |3Dright>|<FONT=20|
|000010c0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000010d0| 20 20 20 20 66 61 63 65 | 3d 33 44 22 56 65 72 64 | face|=3D"Verd|
|000010e0| 61 6e 61 2c 20 41 72 69 | 61 6c 2c 20 48 65 6c 76 |ana, Ari|al, Helv|
|000010f0| 65 74 69 63 61 2c 20 73 | 61 6e 73 2d 73 65 72 69 |etica, s|ans-seri|
|00001100| 66 22 20 3d 0d 0a 73 69 | 7a 65 3d 33 44 32 3e 3c |f" =..si|ze=3D2><|
|00001110| 42 3e 3c 46 4f 4e 54 3d | 32 30 0d 0a 20 20 20 20 |B><FONT=|20.. |
|00001120| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 63 6c | | cl|
|00001130| 61 73 73 3d 33 44 6d 65 | 6e 75 69 74 65 6d 20 63 |ass=3Dme|nuitem c|
|00001140| 6f 6c 6f 72 3d 33 44 23 | 66 66 66 66 66 66 3e 3c |olor=3D#|ffffff><|
|00001150| 41 20 63 6c 61 73 73 3d | 33 44 6d 65 6e 75 69 74 |A class=|3Dmenuit|
|00001160| 65 6d 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |em=20.. | |
|00001170| 20 20 20 20 20 20 20 20 | 20 68 72 65 66 3d 33 44 | | href=3D|
|00001180| 22 68 74 74 70 3a 2f 2f | 77 77 77 2e 77 65 62 79 |"http://|www.weby|
|00001190| 6f 67 2e 63 6f 6d 2f 63 | 6f 6e 74 61 63 74 75 73 |og.com/c|ontactus|
|000011a0| 2e 68 74 6d 6c 22 3e 63 | 6f 6e 74 61 63 74 20 3d |.html">c|ontact =|
|000011b0| 0d 0a 75 73 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |..us=20.|. |
|000011c0| 20 20 20 20 20 20 20 20 | 20 20 20 3c 2f 41 3e 3c | | </A><|
|000011d0| 2f 46 4f 4e 54 3e 3c 2f | 42 3e 3c 2f 46 4f 4e 54 |/FONT></|B></FONT|
|000011e0| 3e 3c 2f 44 49 56 3e 3c | 2f 54 44 3e 0d 0a 20 20 |></DIV><|/TD>.. |
|000011f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 54 | | <T|
|00001200| 44 20 77 69 64 74 68 3d | 33 44 22 34 25 22 3e 26 |D width=|3D"4%">&|
|00001210| 6e 62 73 70 3b 3c 2f 54 | 44 3e 3c 2f 54 52 3e 3c |nbsp;</T|D></TR><|
|00001220| 2f 54 42 4f 44 59 3e 3c | 2f 54 41 42 4c 45 3e 0d |/TBODY><|/TABLE>.|
|00001230| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 50 20 |. | <P |
|00001240| 61 6c 69 67 6e 3d 33 44 | 72 69 67 68 74 3e 3c 46 |align=3D|right><F|
|00001250| 4f 4e 54 20 66 61 63 65 | 3d 33 44 22 56 65 72 64 |ONT face|=3D"Verd|
|00001260| 61 6e 61 2c 20 41 72 69 | 61 6c 2c 20 48 65 6c 76 |ana, Ari|al, Helv|
|00001270| 65 74 69 63 61 2c 20 3d | 0d 0a 73 61 6e 73 2d 73 |etica, =|..sans-s|
|00001280| 65 72 69 66 22 3d 32 30 | 0d 0a 20 20 20 20 20 20 |erif"=20|.. |
|00001290| 20 20 20 20 20 20 63 6f | 6c 6f 72 3d 33 44 23 66 | co|lor=3D#f|
|000012a0| 66 66 66 66 66 20 73 69 | 7a 65 3d 33 44 31 3e 3c |fffff si|ze=3D1><|
|000012b0| 42 3e 3c 2f 42 3e 3c 2f | 46 4f 4e 54 3e 3c 2f 50 |B></B></|FONT></P|
|000012c0| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 3c |>.. | <|
|000012d0| 50 3e 26 6e 62 73 70 3b | 3c 2f 50 3e 0d 0a 20 20 |P> |</P>.. |
|000012e0| 20 20 20 20 20 20 20 20 | 20 20 3c 50 3e 26 6e 62 | | <P>&nb|
|000012f0| 73 70 3b 3c 2f 50 3e 3c | 2f 54 44 3e 0d 0a 20 20 |sp;</P><|/TD>.. |
|00001300| 20 20 20 20 20 20 20 20 | 3c 54 44 20 76 41 6c 69 | |<TD vAli|
|00001310| 67 6e 3d 33 44 74 6f 70 | 20 77 69 64 74 68 3d 33 |gn=3Dtop| width=3|
|00001320| 44 22 36 30 25 22 3e 0d | 0a 20 20 20 20 20 20 20 |D"60%">.|. |
|00001330| 20 20 20 20 20 3c 54 41 | 42 4c 45 20 63 65 6c 6c | <TA|BLE cell|
|00001340| 53 70 61 63 69 6e 67 3d | 33 44 30 20 63 65 6c 6c |Spacing=|3D0 cell|
|00001350| 50 61 64 64 69 6e 67 3d | 33 44 30 20 77 69 64 74 |Padding=|3D0 widt|
|00001360| 68 3d 33 44 22 39 35 25 | 22 20 3d 0d 0a 61 6c 69 |h=3D"95%|" =..ali|
|00001370| 67 6e 3d 33 44 63 65 6e | 74 65 72 3d 32 30 0d 0a |gn=3Dcen|ter=20..|
|00001380| 62 6f 72 64 65 72 3d 33 | 44 30 3e 0d 0a 20 20 20 |border=3|D0>.. |
|00001390| 20 20 20 20 20 20 20 20 | 20 20 20 3c 54 42 4f 44 | | <TBOD|
|000013a0| 59 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |Y>.. | |
|000013b0| 20 20 3c 54 52 3e 0d 0a | 20 20 20 20 20 20 20 20 | <TR>..| |
|000013c0| 20 20 20 20 20 20 20 20 | 3c 54 44 20 63 6c 61 73 | |<TD clas|
|000013d0| 73 3d 33 44 74 65 78 74 | 20 76 41 6c 69 67 6e 3d |s=3Dtext| vAlign=|
|000013e0| 33 44 74 6f 70 20 61 6c | 69 67 6e 3d 33 44 6c 65 |3Dtop al|ign=3Dle|
|000013f0| 66 74 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ft>.. | |
|00001400| 20 20 20 20 20 20 20 3c | 50 3e 3c 42 52 3e 3c 2f | <|P><BR></|
|00001410| 50 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |P>.. | |
|00001420| 20 20 20 20 20 20 3c 50 | 20 61 6c 69 67 6e 3d 33 | <P| align=3|
|00001430| 44 6c 65 66 74 3e 3c 49 | 4d 47 20 68 65 69 67 68 |Dleft><I|MG heigh|
|00001440| 74 3d 33 44 33 37 20 61 | 6c 74 3d 33 44 22 53 51 |t=3D37 a|lt=3D"SQ|
|00001450| 4c 79 6f 67 20 46 41 51 | 22 3d 32 30 0d 0a 20 20 |Lyog FAQ|"=20.. |
|00001460| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001470| 73 72 63 3d 33 44 22 68 | 74 74 70 3a 2f 2f 77 77 |src=3D"h|ttp://ww|
|00001480| 77 2e 77 65 62 79 6f 67 | 2e 63 6f 6d 2f 69 6d 61 |w.webyog|.com/ima|
|00001490| 67 65 73 2f 6d 79 73 71 | 6c 66 61 71 2e 67 69 66 |ges/mysq|lfaq.gif|
|000014a0| 22 20 3d 0d 0a 77 69 64 | 74 68 3d 33 44 34 30 35 |" =..wid|th=3D405|
|000014b0| 3e 3c 2f 50 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 |></P>.. | |
|000014c0| 20 20 20 20 20 20 20 20 | 20 3c 50 20 63 6c 61 73 | | <P clas|
|000014d0| 73 3d 33 44 66 61 71 68 | 65 61 64 65 72 20 61 6c |s=3Dfaqh|eader al|
|000014e0| 69 67 6e 3d 33 44 63 65 | 6e 74 65 72 3e 3c 41 20 |ign=3Dce|nter><A |
|000014f0| 3d 0d 0a 6e 61 6d 65 3d | 33 44 67 65 6e 65 72 61 |=..name=|3Dgenera|
|00001500| 6c 3e 3c 2f 41 3e 47 65 | 6e 65 72 61 6c 3d 32 30 |l></A>Ge|neral=20|
|00001510| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00001520| 20 20 20 20 51 75 65 73 | 74 69 6f 6e 73 3c 2f 50 | Ques|tions</P|
|00001530| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00001540| 20 20 20 20 20 3c 50 20 | 63 6c 61 73 73 3d 33 44 | <P |class=3D|
|00001550| 71 75 65 73 74 69 6f 6e | 3e 51 2e 20 57 68 61 74 |question|>Q. What|
|00001560| 20 69 73 20 53 51 4c 79 | 6f 67 20 3f 3c 2f 50 3e | is SQLy|og ?</P>|
|00001570| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00001580| 20 20 20 20 3c 50 20 63 | 6c 61 73 73 3d 33 44 61 | <P c|lass=3Da|
|00001590| 6e 73 77 65 72 3e 41 2e | 20 53 51 4c 79 6f 67 20 |nswer>A.| SQLyog |
|000015a0| 69 73 20 61 20 76 65 72 | 79 20 3c 42 3e 66 61 73 |is a ver|y <B>fas|
|000015b0| 74 3c 2f 42 3e 2c 3d 32 | 30 0d 0a 20 20 20 20 20 |t</B>,=2|0.. |
|000015c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 42 3e | | <B>|
|000015d0| 63 6f 6d 70 61 63 74 3c | 2f 42 3e 20 61 6e 64 20 |compact<|/B> and |
|000015e0| 3c 42 3e 73 69 6d 70 6c | 65 3c 2f 42 3e 20 74 6f |<B>simpl|e</B> to|
|000015f0| 20 75 73 65 20 47 55 49 | 20 74 6f 6f 6c 20 74 6f | use GUI| tool to|
|00001600| 20 3d 0d 0a 6d 61 6e 61 | 67 65 3d 32 30 0d 0a 20 | =..mana|ge=20.. |
|00001610| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001620| 20 79 6f 75 72 20 4d 79 | 53 51 4c 20 73 65 72 76 | your My|SQL serv|
|00001630| 65 72 2e 20 54 68 65 20 | 73 6f 66 74 77 61 72 65 |er. The |software|
|00001640| 20 69 73 20 70 72 69 6d | 61 72 69 6c 79 20 66 6f | is prim|arily fo|
|00001650| 72 20 74 68 65 20 3d 0d | 0a 75 73 65 72 73 20 77 |r the =.|.users w|
|00001660| 68 6f 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |ho=20.. | |
|00001670| 20 20 20 20 20 20 20 20 | 20 77 6f 72 6b 20 77 69 | | work wi|
|00001680| 74 68 20 4d 79 53 51 4c | 20 64 75 72 69 6e 67 20 |th MySQL| during |
|00001690| 74 68 65 20 64 65 76 65 | 6c 6f 70 6d 65 6e 74 20 |the deve|lopment |
|000016a0| 70 72 6f 63 65 73 73 2e | 20 3c 2f 50 3e 0d 0a 20 |process.| </P>.. |
|000016b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000016c0| 20 3c 50 20 63 6c 61 73 | 73 3d 33 44 61 6e 73 77 | <P clas|s=3Dansw|
|000016d0| 65 72 3e 3c 49 4d 47 20 | 68 65 69 67 68 74 3d 33 |er><IMG |height=3|
|000016e0| 44 37 30 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |D70=20..| |
|000016f0| 20 20 20 20 20 20 20 20 | 20 20 73 72 63 3d 33 44 | | src=3D|
|00001700| 22 68 74 74 70 3a 2f 2f | 77 77 77 2e 77 65 62 79 |"http://|www.weby|
|00001710| 6f 67 2e 63 6f 6d 2f 69 | 6d 61 67 65 73 2f 6f 63 |og.com/i|mages/oc|
|00001720| 63 61 6d 2e 67 69 66 22 | 20 3d 0d 0a 77 69 64 74 |cam.gif"| =..widt|
|00001730| 68 3d 33 44 35 31 3d 32 | 30 0d 0a 20 20 20 20 20 |h=3D51=2|0.. |
|00001740| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 61 6c 69 | | ali|
|00001750| 67 6e 3d 33 44 6c 65 66 | 74 3e 4c 69 6b 65 20 4d |gn=3Dlef|t>Like M|
|00001760| 79 53 51 4c 2c 20 53 51 | 4c 79 6f 67 20 61 6c 73 |ySQL, SQ|Lyog als|
|00001770| 6f 20 66 6f 6c 6c 6f 77 | 73 20 74 68 65 20 3d 0d |o follow|s the =.|
|00001780| 0a 70 72 69 6e 63 69 70 | 6c 65 20 6f 66 3d 32 30 |.princip|le of=20|
|00001790| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000017a0| 20 20 20 20 74 68 65 20 | 31 34 74 68 20 63 65 6e | the |14th cen|
|000017b0| 74 75 72 79 20 70 68 69 | 6c 6f 73 6f 70 68 65 72 |tury phi|losopher|
|000017c0| 20 6d 6f 6e 6b 20 4f 63 | 63 61 6d 2e 20 57 65 20 | monk Oc|cam. We |
|000017d0| 66 6f 6c 6c 6f 77 20 68 | 69 73 20 3d 0d 0a 72 75 |follow h|is =..ru|
|000017e0| 6c 65 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |le=20.. | |
|000017f0| 20 20 20 20 20 20 20 20 | 20 6b 6e 6f 77 6e 20 61 | | known a|
|00001800| 73 20 4f 63 63 61 6d 3d | 39 32 73 20 72 61 7a 6f |s Occam=|92s razo|
|00001810| 72 3a 20 3c 42 3e 4e 6f | 20 63 6f 6d 70 6c 65 78 |r: <B>No| complex|
|00001820| 69 74 79 20 62 65 79 6f | 6e 64 20 77 68 61 74 20 |ity beyo|nd what |
|00001830| 3d 0d 0a 69 73 3d 32 30 | 0d 0a 20 20 20 20 20 20 |=..is=20|.. |
|00001840| 20 20 20 20 20 20 20 20 | 20 20 20 20 6e 65 63 65 | | nece|
|00001850| 73 73 61 72 79 2e 3c 2f | 42 3e 3c 2f 50 3e 0d 0a |ssary.</|B></P>..|
|00001860| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001870| 20 20 3c 50 20 63 6c 61 | 73 73 3d 33 44 61 6e 73 | <P cla|ss=3Dans|
|00001880| 77 65 72 3e 26 6e 62 73 | 70 3b 3c 2f 50 3e 0d 0a |wer>&nbs|p;</P>..|
|00001890| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000018a0| 20 20 3c 50 20 63 6c 61 | 73 73 3d 33 44 61 6e 73 | <P cla|ss=3Dans|
|000018b0| 77 65 72 3e 3c 42 3e 51 | 2e 20 57 68 69 63 68 20 |wer><B>Q|. Which |
|000018c0| 69 73 20 74 68 65 20 6c | 61 74 65 73 74 20 76 65 |is the l|atest ve|
|000018d0| 72 73 69 6f 6e 20 6f 66 | 20 3d 0d 0a 53 51 4c 79 |rsion of| =..SQLy|
|000018e0| 6f 67 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |og=20.. | |
|000018f0| 20 20 20 20 20 20 20 20 | 20 3f 3c 2f 42 3e 3c 2f | | ?</B></|
|00001900| 50 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |P>.. | |
|00001910| 20 20 20 20 20 20 3c 50 | 20 63 6c 61 73 73 3d 33 | <P| class=3|
|00001920| 44 61 6e 73 77 65 72 3e | 41 2e 20 54 68 65 20 6c |Danswer>|A. The l|
|00001930| 61 74 65 73 74 20 76 65 | 72 73 69 6f 6e 20 6f 66 |atest ve|rsion of|
|00001940| 20 53 51 4c 79 6f 67 20 | 69 73 20 3d 0d 0a 33 2e | SQLyog |is =..3.|
|00001950| 36 34 2c 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |64,=20..| |
|00001960| 20 20 20 20 20 20 20 20 | 20 20 72 65 6c 65 61 73 | | releas|
|00001970| 65 64 20 69 6e 20 46 65 | 62 72 75 61 72 79 20 32 |ed in Fe|bruary 2|
|00001980| 30 30 34 2e 20 49 74 20 | 63 6f 6e 74 61 69 6e 73 |004. It |contains|
|00001990| 20 73 6f 20 6d 61 6e 79 | 20 6e 65 77 20 3d 0d 0a | so many| new =..|
|000019a0| 66 65 61 74 75 72 65 73 | 3d 32 30 0d 0a 20 20 20 |features|=20.. |
|000019b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 74 | | t|
|000019c0| 68 61 74 20 69 74 20 69 | 73 20 61 20 6d 75 73 74 |hat it i|s a must|
|000019d0| 20 75 70 67 72 61 64 65 | 20 66 6f 72 20 61 6c 6c | upgrade| for all|
|000019e0| 20 66 72 6f 6d 20 53 51 | 4c 79 6f 67 20 33 2e 78 | from SQ|Lyog 3.x|
|000019f0| 2e 3c 2f 50 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 |.</P>.. | |
|00001a00| 20 20 20 20 20 20 20 20 | 20 3c 50 20 63 6c 61 73 | | <P clas|
|00001a10| 73 3d 33 44 61 6e 73 77 | 65 72 3e 3c 53 50 41 4e |s=3Dansw|er><SPAN|
|00001a20| 20 63 6c 61 73 73 3d 33 | 44 71 75 65 73 74 69 6f | class=3|Dquestio|
|00001a30| 6e 3e 51 2e 20 57 68 65 | 72 65 20 63 61 6e 20 3d |n>Q. Whe|re can =|
|00001a40| 0d 0a 49 20 6f 62 74 61 | 69 6e 3d 32 30 0d 0a 20 |..I obta|in=20.. |
|00001a50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001a60| 20 53 51 4c 79 6f 67 20 | 3f 3c 2f 53 50 41 4e 3e | SQLyog |?</SPAN>|
|00001a70| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00001a80| 20 20 20 20 20 20 20 20 | 3c 48 33 20 63 6c 61 73 | |<H3 clas|
|00001a90| 73 3d 33 44 61 6e 73 77 | 65 72 3e 41 2e 20 59 6f |s=3Dansw|er>A. Yo|
|00001aa0| 75 20 63 61 6e 20 64 6f | 77 6e 6c 6f 61 64 20 61 |u can do|wnload a|
|00001ab0| 20 63 6f 70 79 20 6f 66 | 20 3d 0d 0a 53 51 4c 79 | copy of| =..SQLy|
|00001ac0| 6f 67 20 66 72 6f 6d 20 | 74 68 65 3d 32 30 0d 0a |og from |the=20..|
|00001ad0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001ae0| 20 20 3c 41 20 3d 0d 0a | 68 72 65 66 3d 33 44 22 | <A =..|href=3D"|
|00001af0| 68 74 74 70 3a 2f 2f 77 | 77 77 2e 77 65 62 79 6f |http://w|ww.webyo|
|00001b00| 67 2e 63 6f 6d 2f 73 71 | 6c 79 6f 67 2f 64 6f 77 |g.com/sq|lyog/dow|
|00001b10| 6e 6c 6f 61 64 2e 68 74 | 6d 6c 22 3e 53 51 4c 79 |nload.ht|ml">SQLy|
|00001b20| 6f 67 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |og=20.. | |
|00001b30| 20 20 20 20 20 20 20 20 | 20 44 6f 77 6e 6c 6f 61 | | Downloa|
|00001b40| 64 20 50 61 67 65 3c 2f | 41 3e 2e 20 4a 75 73 74 |d Page</|A>. Just|
|00001b50| 20 70 72 6f 76 69 64 65 | 20 75 73 20 77 69 74 68 | provide| us with|
|00001b60| 20 79 6f 75 72 20 6e 61 | 6d 65 20 61 6e 64 20 3d | your na|me and =|
|00001b70| 0d 0a 65 2d 6d 61 69 6c | 3d 32 30 0d 0a 20 20 20 |..e-mail|=20.. |
|00001b80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 61 | | a|
|00001b90| 64 64 72 65 73 73 20 73 | 6f 20 74 68 61 74 20 77 |ddress s|o that w|
|00001ba0| 65 20 63 61 6e 20 69 6e | 66 6f 72 6d 20 79 6f 75 |e can in|form you|
|00001bb0| 20 61 62 6f 75 74 20 66 | 75 74 75 72 65 20 3d 0d | about f|uture =.|
|00001bc0| 0a 72 65 6c 65 61 73 65 | 73 20 6f 66 3d 32 30 0d |.release|s of=20.|
|00001bd0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00001be0| 20 20 20 53 51 4c 79 6f | 67 2e 3c 2f 48 33 3e 0d | SQLyo|g.</H3>.|
|00001bf0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00001c00| 20 20 20 3c 50 20 63 6c | 61 73 73 3d 33 44 71 75 | <P cl|ass=3Dqu|
|00001c10| 65 73 74 69 6f 6e 3e 51 | 2e 20 57 68 65 72 65 20 |estion>Q|. Where |
|00001c20| 63 61 6e 20 49 20 66 69 | 6e 64 20 61 20 6d 61 69 |can I fi|nd a mai|
|00001c30| 6c 69 6e 67 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |ling=20.|. |
|00001c40| 20 20 20 20 20 20 20 20 | 20 20 20 6c 69 73 74 2f | | list/|
|00001c50| 64 69 73 63 75 73 73 69 | 6f 6e 20 62 6f 61 72 64 |discussi|on board|
|00001c60| 20 66 6f 72 20 53 51 4c | 79 6f 67 20 3f 3c 2f 50 | for SQL|yog ?</P|
|00001c70| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00001c80| 20 20 20 20 20 3c 50 20 | 63 6c 61 73 73 3d 33 44 | <P |class=3D|
|00001c90| 61 6e 73 77 65 72 3e 41 | 2e 20 57 65 20 68 61 76 |answer>A|. We hav|
|00001ca0| 65 20 61 20 64 69 73 63 | 75 73 73 69 6f 6e 20 62 |e a disc|ussion b|
|00001cb0| 6f 61 72 64 20 3c 41 3d | 32 30 0d 0a 20 20 20 20 |oard <A=|20.. |
|00001cc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3d 0d | | =.|
|00001cd0| 0a 68 72 65 66 3d 33 44 | 22 68 74 74 70 3a 2f 2f |.href=3D|"http://|
|00001ce0| 77 77 77 2e 77 65 62 79 | 6f 67 2e 63 6f 6d 2f 66 |www.weby|og.com/f|
|00001cf0| 6f 72 75 6d 73 2f 69 6e | 64 65 78 2e 70 68 70 22 |orums/in|dex.php"|
|00001d00| 3e 68 65 72 65 3c 2f 41 | 3e 2e 20 41 73 6b 3d 32 |>here</A|>. Ask=2|
|00001d10| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00001d20| 20 20 20 20 20 79 6f 75 | 72 20 71 75 65 73 74 69 | you|r questi|
|00001d30| 6f 6e 20 61 6e 64 20 6f | 6e 65 20 6f 66 20 6f 75 |on and o|ne of ou|
|00001d40| 72 20 73 75 70 70 6f 72 | 74 20 74 65 61 6d 20 6d |r suppor|t team m|
|00001d50| 65 6d 62 65 72 73 20 77 | 69 6c 6c 20 3d 0d 0a 72 |embers w|ill =..r|
|00001d60| 65 70 6c 79 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |eply=20.|. |
|00001d70| 20 20 20 20 20 20 20 20 | 20 20 20 62 61 63 6b 2e | | back.|
|00001d80| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00001d90| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|00001da0| 3d 33 44 71 75 65 73 74 | 69 6f 6e 3e 51 2e 20 49 |=3Dquest|ion>Q. I|
|00001db0| 20 74 68 69 6e 6b 20 49 | 20 66 6f 75 6e 64 20 61 | think I| found a|
|00001dc0| 20 62 75 67 2c 20 77 68 | 6f 6d 20 3d 0d 0a 73 68 | bug, wh|om =..sh|
|00001dd0| 6f 75 6c 64 20 49 20 74 | 65 6c 6c 3d 32 30 0d 0a |ould I t|ell=20..|
|00001de0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001df0| 20 20 3f 3c 2f 50 3e 0d | 0a 20 20 20 20 20 20 20 | ?</P>.|. |
|00001e00| 20 20 20 20 20 20 20 20 | 20 20 20 3c 50 20 63 6c | | <P cl|
|00001e10| 61 73 73 3d 33 44 61 6e | 73 77 65 72 3e 41 2e 20 |ass=3Dan|swer>A. |
|00001e20| 4d 61 6b 65 20 73 75 72 | 65 20 74 68 61 74 20 79 |Make sur|e that y|
|00001e30| 6f 75 20 61 72 65 20 75 | 73 69 6e 67 20 74 68 65 |ou are u|sing the|
|00001e40| 20 3d 0d 0a 6c 61 74 65 | 73 74 3d 32 30 0d 0a 20 | =..late|st=20.. |
|00001e50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001e60| 20 76 65 72 73 69 6f 6e | 20 6f 66 20 53 51 4c 79 | version| of SQLy|
|00001e70| 6f 67 20 62 79 20 63 68 | 65 63 6b 69 6e 67 20 69 |og by ch|ecking i|
|00001e80| 74 20 61 74 20 74 68 65 | 20 53 51 4c 79 6f 67 20 |t at the| SQLyog |
|00001e90| 3d 0d 0a 77 65 62 73 69 | 74 65 2e 20 49 66 20 79 |=..websi|te. If y|
|00001ea0| 6f 75 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |ou=20.. | |
|00001eb0| 20 20 20 20 20 20 20 20 | 20 61 72 65 20 73 75 72 | | are sur|
|00001ec0| 65 20 74 68 61 74 20 79 | 6f 75 20 68 61 76 65 20 |e that y|ou have |
|00001ed0| 74 68 65 20 6c 61 74 65 | 73 74 20 6f 6e 65 20 74 |the late|st one t|
|00001ee0| 68 65 6e 20 72 65 70 6f | 72 74 20 74 68 65 20 3d |hen repo|rt the =|
|00001ef0| 0d 0a 62 75 67 20 61 74 | 3d 32 30 0d 0a 20 20 20 |..bug at|=20.. |
|00001f00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c | | <|
|00001f10| 41 20 3d 0d 0a 68 72 65 | 66 3d 33 44 22 68 74 74 |A =..hre|f=3D"htt|
|00001f20| 70 3a 2f 2f 77 77 77 2e | 77 65 62 79 6f 67 2e 63 |p://www.|webyog.c|
|00001f30| 6f 6d 2f 66 6f 72 75 6d | 73 2f 69 6e 64 65 78 2e |om/forum|s/index.|
|00001f40| 70 68 70 22 3e 42 75 67 | 73 20 53 65 63 74 69 6f |php">Bug|s Sectio|
|00001f50| 6e 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |n=20.. | |
|00001f60| 20 20 20 20 20 20 20 20 | 61 74 20 53 51 4c 79 6f | |at SQLyo|
|00001f70| 67 20 66 6f 72 75 6d 20 | 3c 2f 41 3e 2e 20 57 65 |g forum |</A>. We|
|00001f80| 20 77 69 6c 6c 20 72 65 | 70 6c 79 20 79 6f 75 20 | will re|ply you |
|00001f90| 62 61 63 6b 20 61 62 6f | 75 74 20 74 68 65 20 3d |back abo|ut the =|
|00001fa0| 0d 0a 73 74 61 74 75 73 | 3d 32 30 0d 0a 20 20 20 |..status|=20.. |
|00001fb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 6f | | o|
|00001fc0| 66 20 74 68 65 20 62 75 | 67 2e 20 49 66 20 69 74 |f the bu|g. If it|
|00001fd0| 73 20 61 20 6b 6e 6f 77 | 6e 20 62 75 67 20 74 68 |s a know|n bug th|
|00001fe0| 65 6e 20 77 65 20 77 69 | 6c 6c 20 62 65 20 61 62 |en we wi|ll be ab|
|00001ff0| 6c 65 20 74 6f 20 3d 0d | 0a 72 65 70 6c 79 3d 32 |le to =.|.reply=2|
|00002000| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00002010| 20 20 20 20 20 62 61 63 | 6b 20 77 69 74 68 20 74 | bac|k with t|
|00002020| 68 65 20 73 6f 6c 75 74 | 69 6f 6e 20 6f 72 20 6d |he solut|ion or m|
|00002030| 61 79 62 65 20 79 6f 75 | 20 68 61 76 65 20 74 6f |aybe you| have to|
|00002040| 20 77 61 69 74 20 66 6f | 72 20 3d 0d 0a 74 68 65 | wait fo|r =..the|
|00002050| 20 6e 65 78 74 3d 32 30 | 0d 0a 20 20 20 20 20 20 | next=20|.. |
|00002060| 20 20 20 20 20 20 20 20 | 20 20 20 20 72 65 6c 65 | | rele|
|00002070| 61 73 65 2e 3c 2f 50 3e | 0d 0a 20 20 20 20 20 20 |ase.</P>|.. |
|00002080| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 50 20 63 | | <P c|
|00002090| 6c 61 73 73 3d 33 44 61 | 6e 73 77 65 72 3e 3c 53 |lass=3Da|nswer><S|
|000020a0| 50 41 4e 20 63 6c 61 73 | 73 3d 33 44 71 75 65 73 |PAN clas|s=3Dques|
|000020b0| 74 69 6f 6e 3e 51 2e 20 | 44 6f 20 49 20 6e 65 65 |tion>Q. |Do I nee|
|000020c0| 64 20 3d 0d 0a 74 6f 20 | 72 65 61 64 20 61 6e 79 |d =..to |read any|
|000020d0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|000020e0| 20 20 20 20 20 20 20 64 | 6f 63 75 6d 65 6e 74 61 | d|ocumenta|
|000020f0| 74 69 6f 6e 20 74 6f 20 | 70 75 74 20 53 51 4c 79 |tion to |put SQLy|
|00002100| 6f 67 20 69 6e 74 6f 20 | 75 73 65 20 3f 3c 2f 53 |og into |use ?</S|
|00002110| 50 41 4e 3e 3c 2f 50 3e | 0d 0a 20 20 20 20 20 20 |PAN></P>|.. |
|00002120| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 50 20 63 | | <P c|
|00002130| 6c 61 73 73 3d 33 44 61 | 6e 73 77 65 72 3e 41 2e |lass=3Da|nswer>A.|
|00002140| 20 41 62 73 6f 6c 75 74 | 65 6c 79 20 6e 6f 74 2e | Absolut|ely not.|
|00002150| 20 53 51 4c 79 6f 67 20 | 68 61 73 20 67 6f 74 20 | SQLyog |has got |
|00002160| 61 6e 20 3d 0d 0a 69 6e | 74 75 69 74 69 76 65 3d |an =..in|tuitive=|
|00002170| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00002180| 20 20 20 20 20 20 69 6e | 74 65 72 66 61 63 65 2c | in|terface,|
|00002190| 20 79 6f 75 20 77 69 6c | 6c 20 62 65 20 75 70 20 | you wil|l be up |
|000021a0| 61 6e 64 20 72 75 6e 6e | 69 6e 67 20 77 69 74 68 |and runn|ing with|
|000021b0| 69 6e 20 6d 6f 6d 65 6e | 74 73 2e 20 3d 0d 0a 53 |in momen|ts. =..S|
|000021c0| 70 65 63 69 61 6c 3d 32 | 30 0d 0a 20 20 20 20 20 |pecial=2|0.. |
|000021d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 63 61 72 | | car|
|000021e0| 65 20 68 61 73 20 62 65 | 65 6e 20 74 61 6b 65 6e |e has be|en taken|
|000021f0| 20 74 6f 20 70 72 6f 76 | 69 64 65 20 61 20 6e 6f | to prov|ide a no|
|00002200| 6e 2d 63 6c 75 74 74 65 | 72 65 64 20 61 6e 64 20 |n-clutte|red and |
|00002210| 3d 0d 0a 65 78 74 72 65 | 6d 65 6c 79 3d 32 30 0d |=..extre|mely=20.|
|00002220| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00002230| 20 20 20 73 69 6d 70 6c | 65 20 69 6e 74 65 72 66 | simpl|e interf|
|00002240| 61 63 65 2e 20 3c 2f 50 | 3e 0d 0a 20 20 20 20 20 |ace. </P|>.. |
|00002250| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 50 20 | | <P |
|00002260| 63 6c 61 73 73 3d 33 44 | 66 61 71 68 65 61 64 65 |class=3D|faqheade|
|00002270| 72 20 61 6c 69 67 6e 3d | 33 44 63 65 6e 74 65 72 |r align=|3Dcenter|
|00002280| 3e 3c 41 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |><A=20..| |
|00002290| 20 20 20 20 20 20 20 20 | 20 20 6e 61 6d 65 3d 33 | | name=3|
|000022a0| 44 74 65 63 68 6e 6f 6c | 6f 67 79 3e 3c 2f 41 3e |Dtechnol|ogy></A>|
|000022b0| 54 65 63 68 6e 6f 6c 6f | 67 79 3c 2f 50 3e 0d 0a |Technolo|gy</P>..|
|000022c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000022d0| 20 20 3c 50 3e 3c 53 50 | 41 4e 20 63 6c 61 73 73 | <P><SP|AN class|
|000022e0| 3d 33 44 71 75 65 73 74 | 69 6f 6e 3e 51 2e 20 49 |=3Dquest|ion>Q. I|
|000022f0| 20 61 6d 20 6e 65 77 20 | 74 6f 20 4d 79 53 51 4c | am new |to MySQL|
|00002300| 2f 53 51 4c 20 3f 20 3d | 0d 0a 43 61 6e 20 53 51 |/SQL ? =|..Can SQ|
|00002310| 4c 79 6f 67 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |Lyog=20.|. |
|00002320| 20 20 20 20 20 20 20 20 | 20 20 20 68 65 6c 70 20 | | help |
|00002330| 6d 65 20 69 6e 20 6c 65 | 61 72 6e 69 6e 67 20 4d |me in le|arning M|
|00002340| 79 53 51 4c 20 3f 3c 2f | 53 50 41 4e 3e 3c 2f 50 |ySQL ?</|SPAN></P|
|00002350| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00002360| 20 20 20 20 20 3c 50 20 | 63 6c 61 73 73 3d 33 44 | <P |class=3D|
|00002370| 61 6e 73 77 65 72 3e 41 | 2e 20 59 65 73 21 20 49 |answer>A|. Yes! I|
|00002380| 66 20 79 6f 75 20 61 72 | 65 20 6e 65 77 20 74 6f |f you ar|e new to|
|00002390| 20 4d 79 53 51 4c 20 6f | 72 20 3d 0d 0a 53 51 4c | MySQL o|r =..SQL|
|000023a0| 20 74 68 65 6e 3d 32 30 | 0d 0a 20 20 20 20 20 20 | then=20|.. |
|000023b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 51 4c 79 | | SQLy|
|000023c0| 6f 67 20 69 73 20 74 68 | 65 20 69 64 65 61 6c 20 |og is th|e ideal |
|000023d0| 74 6f 6f 6c 20 74 6f 20 | 67 65 74 20 79 6f 75 20 |tool to |get you |
|000023e0| 73 74 61 72 74 65 64 2e | 20 41 70 61 72 74 20 3d |started.| Apart =|
|000023f0| 0d 0a 66 72 6f 6d 3d 32 | 30 0d 0a 20 20 20 20 20 |..from=2|0.. |
|00002400| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 70 72 6f | | pro|
|00002410| 76 69 64 69 6e 67 20 74 | 65 6d 70 6c 61 74 65 73 |viding t|emplates|
|00002420| 20 6f 66 20 61 6c 6c 20 | 53 51 4c 20 73 74 61 74 | of all |SQL stat|
|00002430| 65 6d 65 6e 74 73 20 73 | 75 70 70 6f 72 74 65 64 |ements s|upported|
|00002440| 20 62 79 20 3d 0d 0a 4d | 79 53 51 4c 2c 3d 32 30 | by =..M|ySQL,=20|
|00002450| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00002460| 20 20 20 20 71 75 65 72 | 69 65 73 20 67 65 6e 65 | quer|ies gene|
|00002470| 72 61 74 65 64 20 62 79 | 20 53 51 4c 79 6f 67 20 |rated by| SQLyog |
|00002480| 74 6f 20 70 65 72 66 6f | 72 6d 20 76 61 72 69 6f |to perfo|rm vario|
|00002490| 75 73 20 74 61 73 6b 73 | 20 3d 0d 0a 61 72 65 20 |us tasks| =..are |
|000024a0| 61 6c 73 6f 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |also=20.|. |
|000024b0| 20 20 20 20 20 20 20 20 | 20 20 20 6c 6f 67 67 65 | | logge|
|000024c0| 64 2e 20 3c 41 3d 32 30 | 0d 0a 20 20 20 20 20 20 |d. <A=20|.. |
|000024d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 3d 0d 0a 68 | | =..h|
|000024e0| 72 65 66 3d 33 44 22 68 | 74 74 70 3a 2f 2f 77 77 |ref=3D"h|ttp://ww|
|000024f0| 77 2e 77 65 62 79 6f 67 | 2e 63 6f 6d 2f 73 71 6c |w.webyog|.com/sql|
|00002500| 79 6f 67 2f 73 71 6c 79 | 6f 67 68 65 6c 70 2f 69 |yog/sqly|oghelp/i|
|00002510| 6d 61 67 65 38 2e 67 69 | 66 22 3e 43 6c 69 63 6b |mage8.gi|f">Click|
|00002520| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00002530| 20 20 20 20 20 20 20 68 | 65 72 65 20 74 6f 20 73 | h|ere to s|
|00002540| 65 65 20 61 20 73 63 72 | 65 65 6e 73 68 6f 74 20 |ee a scr|eenshot |
|00002550| 6f 66 20 71 75 65 72 79 | 20 70 72 6f 66 69 6c 65 |of query| profile|
|00002560| 72 3c 2f 41 3e 3c 2f 50 | 3e 0d 0a 20 20 20 20 20 |r</A></P|>.. |
|00002570| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 50 20 | | <P |
|00002580| 63 6c 61 73 73 3d 33 44 | 71 75 65 73 74 69 6f 6e |class=3D|question|
|00002590| 3e 3c 2f 50 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 |></P>.. | |
|000025a0| 20 20 20 20 20 20 20 20 | 20 3c 50 3e 3c 53 50 41 | | <P><SPA|
|000025b0| 4e 20 63 6c 61 73 73 3d | 33 44 71 75 65 73 74 69 |N class=|3Dquesti|
|000025c0| 6f 6e 3e 51 2e 20 4f 6e | 20 77 68 61 74 20 70 6c |on>Q. On| what pl|
|000025d0| 61 74 66 6f 72 6d 20 53 | 51 4c 79 6f 67 20 3d 0d |atform S|QLyog =.|
|000025e0| 0a 68 61 73 20 62 65 65 | 6e 3d 32 30 0d 0a 20 20 |.has bee|n=20.. |
|000025f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002600| 64 65 76 65 6c 6f 70 65 | 64 20 3f 3c 2f 53 50 41 |develope|d ?</SPA|
|00002610| 4e 3e 3c 2f 50 3e 0d 0a | 20 20 20 20 20 20 20 20 |N></P>..| |
|00002620| 20 20 20 20 20 20 20 20 | 20 20 3c 50 20 63 6c 61 | | <P cla|
|00002630| 73 73 3d 33 44 61 6e 73 | 77 65 72 3e 41 2e 20 53 |ss=3Dans|wer>A. S|
|00002640| 51 4c 79 6f 67 20 68 61 | 73 20 62 65 65 6e 20 77 |QLyog ha|s been w|
|00002650| 72 69 74 74 65 6e 20 75 | 73 69 6e 67 20 3d 0d 0a |ritten u|sing =..|
|00002660| 43 2f 43 2b 2b 2f 57 69 | 6e 33 32 3d 32 30 0d 0a |C/C++/Wi|n32=20..|
|00002670| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002680| 20 20 41 50 49 73 2e 20 | 49 74 20 61 63 63 65 73 | APIs. |It acces|
|00002690| 73 65 73 20 4d 79 53 51 | 4c 20 75 73 69 6e 67 20 |ses MySQ|L using |
|000026a0| 74 68 65 20 6e 61 74 69 | 76 65 20 4d 79 53 51 4c |the nati|ve MySQL|
|000026b0| 20 43 20 41 50 49 20 3d | 0d 0a 61 6e 64 20 64 6f | C API =|..and do|
|000026c0| 65 73 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |es=20.. | |
|000026d0| 20 20 20 20 20 20 20 20 | 20 6e 6f 74 20 75 73 65 | | not use|
|000026e0| 20 61 6e 79 20 77 72 61 | 70 70 65 72 20 63 6c 61 | any wra|pper cla|
|000026f0| 73 73 65 73 2e 20 54 68 | 69 73 20 6d 61 6b 65 73 |sses. Th|is makes|
|00002700| 20 53 51 4c 79 6f 67 20 | 3d 0d 0a 70 72 6f 62 61 | SQLyog |=..proba|
|00002710| 62 6c 79 20 74 68 65 3d | 32 30 0d 0a 20 20 20 20 |bly the=|20.. |
|00002720| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 66 61 | | fa|
|00002730| 73 74 65 73 74 20 66 72 | 6f 6e 74 20 65 6e 64 20 |stest fr|ont end |
|00002740| 74 6f 20 4d 79 53 51 4c | 20 69 6e 20 74 68 65 20 |to MySQL| in the |
|00002750| 6d 61 72 6b 65 74 2e 20 | 4d 6f 72 65 6f 76 65 72 |market. |Moreover|
|00002760| 20 74 68 65 20 3d 0d 0a | 73 69 7a 65 20 6f 66 3d | the =..|size of=|
|00002770| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00002780| 20 20 20 20 20 20 53 51 | 4c 79 6f 67 20 62 69 6e | SQ|Lyog bin|
|00002790| 61 72 79 20 69 73 20 6f | 6e 65 20 6f 66 20 74 68 |ary is o|ne of th|
|000027a0| 65 20 73 6d 61 6c 6c 65 | 73 74 2e 20 3c 2f 50 3e |e smalle|st. </P>|
|000027b0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000027c0| 20 20 20 20 3c 50 20 63 | 6c 61 73 73 3d 33 44 71 | <P c|lass=3Dq|
|000027d0| 75 65 73 74 69 6f 6e 3e | 51 2e 20 44 6f 20 79 6f |uestion>|Q. Do yo|
|000027e0| 75 20 68 61 76 65 20 61 | 6e 79 20 70 6c 61 6e 73 |u have a|ny plans|
|000027f0| 20 74 6f 20 3d 0d 0a 72 | 65 6c 65 61 73 65 20 61 | to =..r|elease a|
|00002800| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00002810| 20 20 20 20 20 20 20 4c | 69 6e 75 78 2f 55 6e 69 | L|inux/Uni|
|00002820| 78 2f 4d 61 63 20 76 65 | 72 73 69 6f 6e 20 6f 66 |x/Mac ve|rsion of|
|00002830| 20 53 51 4c 79 6f 67 20 | 3f 3c 2f 50 3e 0d 0a 20 | SQLyog |?</P>.. |
|00002840| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002850| 20 3c 50 20 63 6c 61 73 | 73 3d 33 44 61 6e 73 77 | <P clas|s=3Dansw|
|00002860| 65 72 3e 41 2e 20 59 65 | 73 2e 20 57 65 20 6d 61 |er>A. Ye|s. We ma|
|00002870| 79 20 6d 61 6b 65 20 53 | 51 4c 79 6f 67 20 63 72 |y make S|QLyog cr|
|00002880| 6f 73 73 20 3d 0d 0a 70 | 6c 61 74 66 6f 72 6d 20 |oss =..p|latform |
|00002890| 69 6e 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |in=20.. | |
|000028a0| 20 20 20 20 20 20 20 20 | 20 6f 75 72 20 6e 65 78 | | our nex|
|000028b0| 74 20 6d 61 6a 6f 72 20 | 72 65 6c 65 61 73 65 2e |t major |release.|
|000028c0| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|000028d0| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|000028e0| 3d 33 44 66 61 71 68 65 | 61 64 65 72 20 61 6c 69 |=3Dfaqhe|ader ali|
|000028f0| 67 6e 3d 33 44 63 65 6e | 74 65 72 3e 3c 41 20 3d |gn=3Dcen|ter><A =|
|00002900| 0d 0a 6e 61 6d 65 3d 33 | 44 64 65 76 65 6c 6f 70 |..name=3|Ddevelop|
|00002910| 65 72 3e 3c 2f 41 3e 46 | 6f 72 3d 32 30 0d 0a 20 |er></A>F|or=20.. |
|00002920| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002930| 20 44 65 76 65 6c 6f 70 | 65 72 73 3c 2f 50 3e 0d | Develop|ers</P>.|
|00002940| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00002950| 20 20 20 3c 50 20 63 6c | 61 73 73 3d 33 44 74 65 | <P cl|ass=3Dte|
|00002960| 78 74 20 61 6c 69 67 6e | 3d 33 44 6c 65 66 74 3e |xt align|=3Dleft>|
|00002970| 3c 53 50 41 4e 20 63 6c | 61 73 73 3d 33 44 71 75 |<SPAN cl|ass=3Dqu|
|00002980| 65 73 74 69 6f 6e 3e 51 | 2e 20 3d 0d 0a 3c 2f 53 |estion>Q|. =..</S|
|00002990| 50 41 4e 3e 3c 53 50 41 | 4e 3d 32 30 0d 0a 20 20 |PAN><SPA|N=20.. |
|000029a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000029b0| 63 6c 61 73 73 3d 33 44 | 71 75 65 73 74 69 6f 6e |class=3D|question|
|000029c0| 3e 49 20 68 61 76 65 20 | 73 74 61 72 74 65 64 20 |>I have |started |
|000029d0| 77 6f 72 6b 69 6e 67 20 | 77 69 74 68 20 4d 79 53 |working |with MyS|
|000029e0| 51 4c 20 34 2e 31 20 3d | 0d 0a 77 68 69 63 68 20 |QL 4.1 =|..which |
|000029f0| 68 61 73 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |has=20..| |
|00002a00| 20 20 20 20 20 20 20 20 | 20 20 6c 6f 74 20 6f 66 | | lot of|
|00002a10| 20 6e 65 77 20 66 65 61 | 74 75 72 65 73 2e 20 43 | new fea|tures. C|
|00002a20| 61 6e 20 49 20 75 73 65 | 20 53 51 4c 79 6f 67 20 |an I use| SQLyog |
|00002a30| 74 6f 20 77 6f 72 6b 20 | 77 69 74 68 20 3d 0d 0a |to work |with =..|
|00002a40| 4d 79 53 51 4c 3d 32 30 | 0d 0a 20 20 20 20 20 20 |MySQL=20|.. |
|00002a50| 20 20 20 20 20 20 20 20 | 20 20 20 20 34 2e 31 3f | | 4.1?|
|00002a60| 3c 2f 53 50 41 4e 3e 3c | 2f 50 3e 0d 0a 20 20 20 |</SPAN><|/P>.. |
|00002a70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c | | <|
|00002a80| 50 20 63 6c 61 73 73 3d | 33 44 74 65 78 74 20 61 |P class=|3Dtext a|
|00002a90| 6c 69 67 6e 3d 33 44 6c | 65 66 74 3e 41 2e 20 59 |lign=3Dl|eft>A. Y|
|00002aa0| 65 73 21 20 53 74 61 72 | 74 69 6e 67 20 77 69 74 |es! Star|ting wit|
|00002ab0| 68 20 3d 0d 0a 53 51 4c | 79 6f 67 20 33 2e 35 2c |h =..SQL|yog 3.5,|
|00002ac0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00002ad0| 20 20 20 20 20 20 20 53 | 51 4c 79 6f 67 20 69 73 | S|QLyog is|
|00002ae0| 20 63 6f 6d 70 6c 65 74 | 65 6c 79 20 4d 79 53 51 | complet|ely MySQ|
|00002af0| 4c 20 34 2e 31 20 63 6f | 6d 70 61 74 69 62 6c 65 |L 4.1 co|mpatible|
|00002b00| 2e 20 46 6f 72 20 74 68 | 61 74 20 3d 0d 0a 6d 61 |. For th|at =..ma|
|00002b10| 74 74 65 72 2c 3d 32 30 | 0d 0a 20 20 20 20 20 20 |tter,=20|.. |
|00002b20| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 51 4c 79 | | SQLy|
|00002b30| 6f 67 20 33 2e 35 20 68 | 61 73 20 62 65 65 6e 20 |og 3.5 h|as been |
|00002b40| 6d 61 64 65 20 62 61 63 | 6b 77 61 72 64 20 63 6f |made bac|kward co|
|00002b50| 6d 70 61 74 69 62 6c 65 | 2e 20 49 66 20 79 6f 75 |mpatible|. If you|
|00002b60| 20 3d 0d 0a 68 61 76 65 | 20 61 3d 32 30 0d 0a 20 | =..have| a=20.. |
|00002b70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002b80| 20 6c 65 67 61 63 79 20 | 4d 79 53 51 4c 20 64 61 | legacy |MySQL da|
|00002b90| 74 61 62 61 73 65 20 79 | 6f 75 20 63 61 6e 20 61 |tabase y|ou can a|
|00002ba0| 64 6d 69 6e 69 73 74 65 | 72 20 74 68 65 6d 20 75 |dministe|r them u|
|00002bb0| 73 69 6e 67 3d 32 30 0d | 0a 53 51 4c 79 6f 67 2e |sing=20.|.SQLyog.|
|00002bc0| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00002bd0| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|00002be0| 3d 33 44 74 65 78 74 20 | 61 6c 69 67 6e 3d 33 44 |=3Dtext |align=3D|
|00002bf0| 6c 65 66 74 3e 3c 53 50 | 41 4e 20 63 6c 61 73 73 |left><SP|AN class|
|00002c00| 3d 33 44 71 75 65 73 74 | 69 6f 6e 3e 51 2e 20 3d |=3Dquest|ion>Q. =|
|00002c10| 0d 0a 3c 2f 53 50 41 4e | 3e 3c 53 50 41 4e 3d 32 |..</SPAN|><SPAN=2|
|00002c20| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00002c30| 20 20 20 20 20 63 6c 61 | 73 73 3d 33 44 71 75 65 | cla|ss=3Dque|
|00002c40| 73 74 69 6f 6e 3e 49 20 | 77 61 6e 74 20 74 6f 20 |stion>I |want to |
|00002c50| 75 70 64 61 74 65 20 61 | 20 73 65 74 20 6f 66 20 |update a| set of |
|00002c60| 64 61 74 61 20 77 68 69 | 63 68 20 3d 0d 0a 77 61 |data whi|ch =..wa|
|00002c70| 73 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |s=20.. | |
|00002c80| 20 20 20 20 20 20 20 20 | 72 65 74 75 72 6e 65 64 | |returned|
|00002c90| 20 66 72 6f 6d 20 61 20 | 51 75 65 72 79 2e 20 43 | from a |Query. C|
|00002ca0| 61 6e 20 49 20 64 6f 20 | 69 74 20 69 6e 20 53 51 |an I do |it in SQ|
|00002cb0| 4c 79 6f 67 20 3d 0d 0a | 3f 3c 2f 53 50 41 4e 3e |Lyog =..|?</SPAN>|
|00002cc0| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00002cd0| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|00002ce0| 3d 33 44 74 65 78 74 20 | 61 6c 69 67 6e 3d 33 44 |=3Dtext |align=3D|
|00002cf0| 6c 65 66 74 3e 41 2e 20 | 59 65 73 21 20 49 6e 73 |left>A. |Yes! Ins|
|00002d00| 74 65 61 64 20 6f 66 20 | 3d 0d 0a 65 78 65 63 75 |tead of |=..execu|
|00002d10| 74 69 6e 67 20 74 68 65 | 3d 32 30 0d 0a 20 20 20 |ting the|=20.. |
|00002d20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 71 | | q|
|00002d30| 75 65 72 79 20 62 79 20 | 70 72 65 73 73 69 6e 67 |uery by |pressing|
|00002d40| 20 46 35 2c 20 65 78 65 | 63 75 74 65 20 74 68 65 | F5, exe|cute the|
|00002d50| 20 71 75 65 72 79 20 75 | 73 69 6e 67 20 46 38 2e | query u|sing F8.|
|00002d60| 20 41 20 3d 0d 0a 47 72 | 69 64 20 77 69 6c 6c 3d | A =..Gr|id will=|
|00002d70| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00002d80| 20 20 20 20 20 20 63 6f | 6d 65 20 75 70 20 77 69 | co|me up wi|
|00002d90| 74 68 20 74 68 65 20 72 | 65 73 75 6c 74 20 77 68 |th the r|esult wh|
|00002da0| 69 63 68 20 79 6f 75 20 | 63 61 6e 20 75 70 64 61 |ich you |can upda|
|00002db0| 74 65 2e 20 54 68 69 73 | 20 3d 0d 0a 61 6c 6c 6f |te. This| =..allo|
|00002dc0| 77 73 20 79 6f 75 3d 32 | 30 0d 0a 20 20 20 20 20 |ws you=2|0.. |
|00002dd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 74 6f 20 | | to |
|00002de0| 65 64 69 74 20 61 20 52 | 65 73 75 6c 74 73 65 74 |edit a R|esultset|
|00002df0| 20 68 61 76 69 6e 67 20 | 61 20 63 6f 6d 70 6c 65 | having |a comple|
|00002e00| 78 20 3c 42 3e 57 48 45 | 52 45 3c 2f 42 3e 20 3d |x <B>WHE|RE</B> =|
|00002e10| 0d 0a 63 6c 61 75 73 65 | 20 6f 72 3d 32 30 0d 0a |..clause| or=20..|
|00002e20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e30| 20 20 3c 42 3e 4a 4f 49 | 4e 53 3c 2f 42 3e 2e 20 | <B>JOI|NS</B>. |
|00002e40| 53 51 4c 79 6f 67 20 77 | 69 6c 6c 20 67 65 6e 65 |SQLyog w|ill gene|
|00002e50| 72 61 74 65 20 74 68 65 | 20 63 6f 72 72 65 73 70 |rate the| corresp|
|00002e60| 6f 6e 64 69 6e 67 3d 32 | 30 0d 0a 20 20 20 20 20 |onding=2|0.. |
|00002e70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 49 6e 73 | | Ins|
|00002e80| 65 72 74 2f 55 70 64 61 | 74 65 20 73 63 72 69 70 |ert/Upda|te scrip|
|00002e90| 74 20 74 6f 20 63 6f 6d | 6d 69 74 20 74 68 65 20 |t to com|mit the |
|00002ea0| 63 68 61 6e 67 65 73 2e | 20 3c 2f 50 3e 0d 0a 20 |changes.| </P>.. |
|00002eb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002ec0| 20 3c 50 20 63 6c 61 73 | 73 3d 33 44 74 65 78 74 | <P clas|s=3Dtext|
|00002ed0| 20 61 6c 69 67 6e 3d 33 | 44 6c 65 66 74 3e 3c 53 | align=3|Dleft><S|
|00002ee0| 50 41 4e 20 3d 0d 0a 63 | 6c 61 73 73 3d 33 44 71 |PAN =..c|lass=3Dq|
|00002ef0| 75 65 73 74 69 6f 6e 3e | 3c 2f 53 50 41 4e 3e 3c |uestion>|</SPAN><|
|00002f00| 53 50 41 4e 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |SPAN=20.|. |
|00002f10| 20 20 20 20 20 20 20 20 | 20 20 20 63 6c 61 73 73 | | class|
|00002f20| 3d 33 44 71 75 65 73 74 | 69 6f 6e 3e 51 2e 20 3c |=3Dquest|ion>Q. <|
|00002f30| 2f 53 50 41 4e 3e 3c 53 | 50 41 4e 20 63 6c 61 73 |/SPAN><S|PAN clas|
|00002f40| 73 3d 33 44 71 75 65 73 | 74 69 6f 6e 3e 49 20 3d |s=3Dques|tion>I =|
|00002f50| 0d 0a 66 72 65 71 75 65 | 6e 74 6c 79 3d 32 30 0d |..freque|ntly=20.|
|00002f60| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00002f70| 20 20 20 6e 65 65 64 20 | 74 6f 20 72 65 6f 72 64 | need |to reord|
|00002f80| 65 72 20 63 6f 6c 75 6d | 6e 73 20 61 6e 64 20 74 |er colum|ns and t|
|00002f90| 68 65 72 65 20 69 73 20 | 6e 6f 20 73 69 6e 67 6c |here is |no singl|
|00002fa0| 65 2d 71 75 65 72 79 20 | 3d 0d 0a 69 6e 20 4d 79 |e-query |=..in My|
|00002fb0| 53 51 4c 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |SQL=20..| |
|00002fc0| 20 20 20 20 20 20 20 20 | 20 20 74 6f 20 64 6f 20 | | to do |
|00002fd0| 74 68 61 74 2e 20 43 61 | 6e 20 53 51 4c 79 6f 67 |that. Ca|n SQLyog|
|00002fe0| 20 68 65 6c 70 20 6d 65 | 20 3f 3c 2f 53 50 41 4e | help me| ?</SPAN|
|00002ff0| 3e 3c 2f 50 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 |></P>.. | |
|00003000| 20 20 20 20 20 20 20 20 | 20 3c 50 20 63 6c 61 73 | | <P clas|
|00003010| 73 3d 33 44 74 65 78 74 | 20 61 6c 69 67 6e 3d 33 |s=3Dtext| align=3|
|00003020| 44 6c 65 66 74 3e 41 2e | 20 44 65 66 69 6e 69 74 |Dleft>A.| Definit|
|00003030| 65 6c 79 2e 20 53 65 6c | 65 63 74 20 74 68 65 20 |ely. Sel|ect the |
|00003040| 3d 0d 0a 74 61 62 6c 65 | 20 66 6f 72 3d 32 30 0d |=..table| for=20.|
|00003050| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00003060| 20 20 20 77 68 69 63 68 | 20 79 6f 75 20 77 61 6e | which| you wan|
|00003070| 74 20 74 6f 20 72 65 6f | 72 64 65 72 20 63 6f 6c |t to reo|rder col|
|00003080| 75 6d 6e 73 20 61 6e 64 | 20 70 72 65 73 73 20 43 |umns and| press C|
|00003090| 74 72 6c 2b 41 6c 74 2b | 52 20 3d 0d 0a 6f 72 3d |trl+Alt+|R =..or=|
|000030a0| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|000030b0| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 52 65 6f | se|lect Reo|
|000030c0| 72 64 65 72 20 43 6f 6c | 75 6d 6e 73 20 66 72 6f |rder Col|umns fro|
|000030d0| 6d 20 74 68 65 20 70 6f | 70 75 70 20 6d 65 6e 75 |m the po|pup menu|
|000030e0| 2e 20 52 65 6f 72 64 65 | 72 20 3d 0d 0a 74 68 65 |. Reorde|r =..the|
|000030f0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00003100| 20 20 20 20 20 20 20 63 | 6f 6c 75 6d 6e 73 20 75 | c|olumns u|
|00003110| 73 69 6e 67 20 4d 6f 76 | 65 20 55 70 2f 4d 6f 76 |sing Mov|e Up/Mov|
|00003120| 65 20 44 6f 77 6e 20 62 | 75 74 74 6f 6e 73 20 61 |e Down b|uttons a|
|00003130| 6e 64 20 70 72 65 73 73 | 20 3d 0d 0a 52 65 6f 72 |nd press| =..Reor|
|00003140| 64 65 72 2e 20 3c 41 3d | 32 30 0d 0a 20 20 20 20 |der. <A=|20.. |
|00003150| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3d 0d | | =.|
|00003160| 0a 68 72 65 66 3d 33 44 | 22 68 74 74 70 3a 2f 2f |.href=3D|"http://|
|00003170| 77 77 77 2e 77 65 62 79 | 6f 67 2e 63 6f 6d 2f 73 |www.weby|og.com/s|
|00003180| 71 6c 79 6f 67 2f 73 71 | 6c 79 6f 67 68 65 6c 70 |qlyog/sq|lyoghelp|
|00003190| 2f 69 6d 61 67 65 31 38 | 2e 67 69 66 22 3e 43 6c |/image18|.gif">Cl|
|000031a0| 69 63 6b 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ick=20..| |
|000031b0| 20 20 20 20 20 20 20 20 | 20 20 68 65 72 65 20 74 | | here t|
|000031c0| 6f 20 73 65 65 20 61 20 | 73 63 72 65 65 6e 73 68 |o see a |screensh|
|000031d0| 6f 74 20 6f 66 20 63 6f | 6c 75 6d 6e 20 72 65 6f |ot of co|lumn reo|
|000031e0| 72 64 65 72 20 3d 0d 0a | 64 69 61 6c 6f 67 3c 2f |rder =..|dialog</|
|000031f0| 41 3e 3c 2f 50 3e 0d 0a | 20 20 20 20 20 20 20 20 |A></P>..| |
|00003200| 20 20 20 20 20 20 20 20 | 20 20 3c 50 20 63 6c 61 | | <P cla|
|00003210| 73 73 3d 33 44 74 65 78 | 74 20 61 6c 69 67 6e 3d |ss=3Dtex|t align=|
|00003220| 33 44 6c 65 66 74 3e 3c | 53 50 41 4e 20 63 6c 61 |3Dleft><|SPAN cla|
|00003230| 73 73 3d 33 44 71 75 65 | 73 74 69 6f 6e 3e 51 2e |ss=3Dque|stion>Q.|
|00003240| 20 3d 0d 0a 3c 2f 53 50 | 41 4e 3e 3c 53 50 41 4e | =..</SP|AN><SPAN|
|00003250| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00003260| 20 20 20 20 20 20 20 63 | 6c 61 73 73 3d 33 44 71 | c|lass=3Dq|
|00003270| 75 65 73 74 69 6f 6e 3e | 41 66 74 65 72 20 63 72 |uestion>|After cr|
|00003280| 65 61 74 69 6e 67 20 74 | 68 65 20 64 61 74 61 62 |eating t|he datab|
|00003290| 61 73 65 20 61 6e 64 20 | 3d 0d 0a 74 61 62 6c 65 |ase and |=..table|
|000032a0| 73 20 69 6e 20 6d 79 3d | 32 30 0d 0a 20 20 20 20 |s in my=|20.. |
|000032b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 74 65 | | te|
|000032c0| 73 74 20 73 65 72 76 65 | 72 2c 20 49 20 6e 65 65 |st serve|r, I nee|
|000032d0| 64 20 74 6f 20 6d 6f 76 | 65 20 74 68 65 20 77 68 |d to mov|e the wh|
|000032e0| 6f 6c 65 20 64 61 74 61 | 62 61 73 65 20 77 69 74 |ole data|base wit|
|000032f0| 68 20 3d 0d 0a 69 74 73 | 20 64 61 74 61 3d 32 30 |h =..its| data=20|
|00003300| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00003310| 20 20 20 20 74 6f 20 74 | 68 65 20 70 72 6f 64 75 | to t|he produ|
|00003320| 63 74 69 6f 6e 20 73 65 | 72 76 65 72 2e 20 48 6f |ction se|rver. Ho|
|00003330| 77 20 63 61 6e 20 49 20 | 64 6f 20 74 68 61 74 20 |w can I |do that |
|00003340| 3d 0d 0a 3f 3c 2f 53 50 | 41 4e 3e 3c 2f 50 3e 0d |=..?</SP|AN></P>.|
|00003350| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00003360| 20 20 20 3c 50 20 63 6c | 61 73 73 3d 33 44 74 65 | <P cl|ass=3Dte|
|00003370| 78 74 20 61 6c 69 67 6e | 3d 33 44 6c 65 66 74 3e |xt align|=3Dleft>|
|00003380| 41 2e 20 53 51 4c 79 6f | 67 20 61 6c 6c 6f 77 73 |A. SQLyo|g allows|
|00003390| 20 79 6f 75 20 74 6f 20 | 3d 0d 0a 63 6f 70 79 20 | you to |=..copy |
|000033a0| 64 61 74 61 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |data=20.|. |
|000033b0| 20 20 20 20 20 20 20 20 | 20 20 20 62 65 74 77 65 | | betwe|
|000033c0| 65 6e 20 74 77 6f 20 64 | 61 74 61 62 61 73 65 73 |en two d|atabases|
|000033d0| 20 6c 6f 63 61 74 65 64 | 20 69 6e 20 64 69 66 66 | located| in diff|
|000033e0| 65 72 65 6e 74 20 68 6f | 73 74 73 2e 20 3d 0d 0a |erent ho|sts. =..|
|000033f0| 43 68 6f 6f 73 65 20 74 | 68 65 3d 32 30 0d 0a 20 |Choose t|he=20.. |
|00003400| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003410| 20 64 61 74 61 62 61 73 | 65 20 74 68 61 74 20 79 | databas|e that y|
|00003420| 6f 75 20 77 61 6e 74 20 | 74 6f 20 43 6f 70 79 20 |ou want |to Copy |
|00003430| 69 6e 20 74 68 65 20 4f | 62 6a 65 63 74 20 42 72 |in the O|bject Br|
|00003440| 6f 77 73 65 72 20 3d 0d | 0a 61 6e 64 3d 32 30 0d |owser =.|.and=20.|
|00003450| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00003460| 20 20 20 73 65 6c 65 63 | 74 20 43 6f 70 79 20 44 | selec|t Copy D|
|00003470| 61 74 61 62 61 73 65 20 | 66 72 6f 6d 20 74 68 65 |atabase |from the|
|00003480| 20 70 6f 70 75 70 20 6d | 65 6e 75 2e 20 53 51 4c | popup m|enu. SQL|
|00003490| 79 6f 67 20 77 69 6c 6c | 20 3d 0d 0a 67 69 76 65 |yog will| =..give|
|000034a0| 20 79 6f 75 3d 32 30 0d | 0a 20 20 20 20 20 20 20 | you=20.|. |
|000034b0| 20 20 20 20 20 20 20 20 | 20 20 20 61 20 6c 69 73 | | a lis|
|000034c0| 74 20 6f 66 20 61 6c 6c | 20 74 68 65 20 68 6f 73 |t of all| the hos|
|000034d0| 74 73 20 61 6e 64 20 64 | 61 74 61 62 61 73 65 73 |ts and d|atabases|
|000034e0| 20 74 68 61 74 20 79 6f | 75 20 61 72 65 20 3d 0d | that yo|u are =.|
|000034f0| 0a 63 6f 6e 6e 65 63 74 | 65 64 3d 32 30 0d 0a 20 |.connect|ed=20.. |
|00003500| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003510| 20 74 6f 20 69 6e 20 74 | 68 65 20 63 75 72 72 65 | to in t|he curre|
|00003520| 6e 74 20 73 65 73 73 69 | 6f 6e 2e 20 53 65 6c 65 |nt sessi|on. Sele|
|00003530| 63 74 20 74 68 65 20 74 | 61 72 67 65 74 20 64 61 |ct the t|arget da|
|00003540| 74 61 62 61 73 65 20 3d | 0d 0a 61 6e 64 3d 32 30 |tabase =|..and=20|
|00003550| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00003560| 20 20 20 20 73 6f 75 72 | 63 65 20 74 61 62 6c 65 | sour|ce table|
|00003570| 73 2e 20 3c 41 3d 32 30 | 0d 0a 20 20 20 20 20 20 |s. <A=20|.. |
|00003580| 20 20 20 20 20 20 20 20 | 20 20 20 20 3d 0d 0a 68 | | =..h|
|00003590| 72 65 66 3d 33 44 22 68 | 74 74 70 3a 2f 2f 77 77 |ref=3D"h|ttp://ww|
|000035a0| 77 2e 77 65 62 79 6f 67 | 2e 63 6f 6d 2f 73 71 6c |w.webyog|.com/sql|
|000035b0| 79 6f 67 2f 73 71 6c 79 | 6f 67 68 65 6c 70 2f 69 |yog/sqly|oghelp/i|
|000035c0| 6d 61 67 65 31 33 2e 67 | 69 66 22 3e 43 6c 69 63 |mage13.g|if">Clic|
|000035d0| 6b 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |k=20.. | |
|000035e0| 20 20 20 20 20 20 20 20 | 68 65 72 65 20 74 6f 20 | |here to |
|000035f0| 73 65 65 20 61 20 73 63 | 72 65 65 6e 73 68 6f 74 |see a sc|reenshot|
|00003600| 20 6f 66 20 63 6f 70 79 | 20 64 61 74 61 62 61 73 | of copy| databas|
|00003610| 65 20 3d 0d 0a 64 69 61 | 6c 6f 67 3c 2f 41 3e 3c |e =..dia|log</A><|
|00003620| 2f 50 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |/P>.. | |
|00003630| 20 20 20 20 20 20 20 3c | 50 20 63 6c 61 73 73 3d | <|P class=|
|00003640| 33 44 74 65 78 74 20 61 | 6c 69 67 6e 3d 33 44 6c |3Dtext a|lign=3Dl|
|00003650| 65 66 74 3e 3c 53 50 41 | 4e 20 63 6c 61 73 73 3d |eft><SPA|N class=|
|00003660| 33 44 71 75 65 73 74 69 | 6f 6e 3e 51 2e 20 3d 0d |3Dquesti|on>Q. =.|
|00003670| 0a 3c 2f 53 50 41 4e 3e | 3c 53 50 41 4e 3d 32 30 |.</SPAN>|<SPAN=20|
|00003680| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00003690| 20 20 20 20 63 6c 61 73 | 73 3d 33 44 71 75 65 73 | clas|s=3Dques|
|000036a0| 74 69 6f 6e 3e 49 20 77 | 61 6e 74 20 74 6f 20 62 |tion>I w|ant to b|
|000036b0| 72 69 6e 67 20 74 61 62 | 6c 65 20 73 74 72 75 63 |ring tab|le struc|
|000036c0| 74 75 72 65 73 20 6f 66 | 20 3d 0d 0a 74 77 6f 3d |tures of| =..two=|
|000036d0| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|000036e0| 20 20 20 20 20 20 64 61 | 74 61 62 61 73 65 20 6c | da|tabase l|
|000036f0| 6f 63 61 74 65 64 20 69 | 6e 20 64 69 66 66 65 72 |ocated i|n differ|
|00003700| 65 6e 74 20 68 6f 73 74 | 73 20 69 6e 20 53 79 6e |ent host|s in Syn|
|00003710| 63 20 77 69 74 68 20 65 | 61 63 68 20 3d 0d 0a 6f |c with e|ach =..o|
|00003720| 74 68 65 72 2e 3d 32 30 | 0d 0a 20 20 20 20 20 20 |ther.=20|.. |
|00003730| 20 20 20 20 20 20 20 20 | 20 20 20 20 48 6f 77 20 | | How |
|00003740| 63 61 6e 20 49 20 64 6f | 20 69 74 20 69 6e 20 53 |can I do| it in S|
|00003750| 51 4c 79 6f 67 20 3f 3c | 2f 53 50 41 4e 3e 3c 2f |QLyog ?<|/SPAN></|
|00003760| 50 3e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |P>.. | |
|00003770| 20 20 20 20 20 20 3c 50 | 20 63 6c 61 73 73 3d 33 | <P| class=3|
|00003780| 44 74 65 78 74 20 61 6c | 69 67 6e 3d 33 44 6c 65 |Dtext al|ign=3Dle|
|00003790| 66 74 3e 41 2e 20 53 51 | 4c 79 6f 67 20 67 69 76 |ft>A. SQ|Lyog giv|
|000037a0| 65 73 20 79 6f 75 20 74 | 68 65 20 3d 0d 0a 6d 6f |es you t|he =..mo|
|000037b0| 73 74 20 65 61 73 79 20 | 61 6e 64 3d 32 30 0d 0a |st easy |and=20..|
|000037c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000037d0| 20 20 65 6c 65 67 61 6e | 74 20 74 6f 20 62 72 69 | elegan|t to bri|
|000037e0| 6e 67 20 74 77 6f 20 64 | 61 74 61 62 61 73 65 73 |ng two d|atabases|
|000037f0| 20 69 6e 74 6f 20 63 6f | 6d 70 6c 65 74 65 20 73 | into co|mplete s|
|00003800| 79 6e 63 20 69 2e 65 2e | 20 3d 0d 0a 0d 0a 20 20 |ync i.e.| =.... |
|00003810| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003820| 63 72 65 61 74 69 6e 67 | 20 6e 65 77 20 74 61 62 |creating| new tab|
|00003830| 6c 65 73 2c 20 64 72 6f | 70 70 69 6e 67 20 74 61 |les, dro|pping ta|
|00003840| 62 6c 65 73 2c 20 61 6c | 74 65 72 69 6e 67 20 74 |bles, al|tering t|
|00003850| 61 62 6c 65 20 3d 0d 0a | 73 74 72 75 63 74 75 72 |able =..|structur|
|00003860| 65 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |e=20.. | |
|00003870| 20 20 20 20 20 20 20 20 | 65 74 63 2e 20 77 69 74 | |etc. wit|
|00003880| 68 20 61 20 73 69 6e 67 | 6c 65 20 6d 6f 75 73 65 |h a sing|le mouse|
|00003890| 20 63 6c 69 63 6b 2e 20 | 50 72 65 73 73 20 43 74 | click. |Press Ct|
|000038a0| 72 6c 2b 51 20 6f 72 20 | 73 65 6c 65 63 74 20 3d |rl+Q or |select =|
|000038b0| 0d 0a 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |.... | |
|000038c0| 20 20 20 20 20 20 54 6f | 6f 6c 73 2d 26 67 74 3b | To|ols->|
|000038d0| 53 74 72 75 63 74 75 72 | 65 20 53 79 6e 63 68 72 |Structur|e Synchr|
|000038e0| 6f 6e 69 7a 61 74 69 6f | 6e 20 54 6f 6f 6c 20 74 |onizatio|n Tool t|
|000038f0| 6f 20 73 74 61 72 74 20 | 74 68 65 3d 32 30 0d 0a |o start |the=20..|
|00003900| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003910| 20 20 53 74 72 75 63 74 | 75 72 65 20 53 79 6e 63 | Struct|ure Sync|
|00003920| 68 72 6f 6e 69 7a 61 74 | 69 6f 6e 20 54 6f 6f 6c |hronizat|ion Tool|
|00003930| 2e 20 53 65 6c 65 63 74 | 20 74 68 65 20 74 77 6f |. Select| the two|
|00003940| 20 3d 0d 0a 64 61 74 61 | 62 61 73 65 20 77 68 69 | =..data|base whi|
|00003950| 63 68 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |ch=20.. | |
|00003960| 20 20 20 20 20 20 20 20 | 20 79 6f 75 20 77 61 6e | | you wan|
|00003970| 74 20 74 6f 20 62 72 69 | 6e 67 20 69 6e 20 53 79 |t to bri|ng in Sy|
|00003980| 6e 63 20 61 6e 64 20 73 | 65 6c 65 63 74 20 6f 6e |nc and s|elect on|
|00003990| 65 20 6f 66 20 74 68 65 | 20 3d 0d 0a 63 6f 6d 6d |e of the| =..comm|
|000039a0| 61 6e 64 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |and=20..| |
|000039b0| 20 20 20 20 20 20 20 20 | 20 20 62 75 74 74 6f 6e | | button|
|000039c0| 73 20 69 6e 20 74 68 65 | 20 62 6f 74 74 6f 6d 2e |s in the| bottom.|
|000039d0| 20 3c 41 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 | <A=20..| |
|000039e0| 20 20 20 20 20 20 20 20 | 20 20 3d 0d 0a 68 72 65 | | =..hre|
|000039f0| 66 3d 33 44 22 68 74 74 | 70 3a 2f 2f 77 77 77 2e |f=3D"htt|p://www.|
|00003a00| 77 65 62 79 6f 67 2e 63 | 6f 6d 2f 73 71 6c 79 6f |webyog.c|om/sqlyo|
|00003a10| 67 2f 73 71 6c 79 6f 67 | 68 65 6c 70 2f 69 6d 61 |g/sqlyog|help/ima|
|00003a20| 67 65 39 2e 67 69 66 22 | 3e 43 6c 69 63 6b 3d 32 |ge9.gif"|>Click=2|
|00003a30| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00003a40| 20 20 20 20 20 68 65 72 | 65 20 74 6f 20 73 65 65 | her|e to see|
|00003a50| 20 61 20 73 63 72 65 65 | 6e 73 68 6f 74 20 6f 66 | a scree|nshot of|
|00003a60| 20 64 61 74 61 62 61 73 | 65 20 73 79 6e 63 20 74 | databas|e sync t|
|00003a70| 6f 6f 6c 20 3d 0d 0a 64 | 69 61 6c 6f 67 3c 2f 41 |ool =..d|ialog</A|
|00003a80| 3e 3c 2f 50 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 |></P>.. | |
|00003a90| 20 20 20 20 20 20 20 20 | 20 3c 50 20 63 6c 61 73 | | <P clas|
|00003aa0| 73 3d 33 44 74 65 78 74 | 20 61 6c 69 67 6e 3d 33 |s=3Dtext| align=3|
|00003ab0| 44 6c 65 66 74 3e 3c 53 | 50 41 4e 20 3d 0d 0a 63 |Dleft><S|PAN =..c|
|00003ac0| 6c 61 73 73 3d 33 44 73 | 6d 61 6c 6c 6e 65 77 3e |lass=3Ds|mallnew>|
|00003ad0| 4e 65 77 21 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |New!=20.|. |
|00003ae0| 20 20 20 20 20 20 20 20 | 20 20 20 3c 2f 53 50 41 | | </SPA|
|00003af0| 4e 3e 3c 53 50 41 4e 20 | 63 6c 61 73 73 3d 33 44 |N><SPAN |class=3D|
|00003b00| 71 75 65 73 74 69 6f 6e | 3e 51 2e 20 3c 2f 53 50 |question|>Q. </SP|
|00003b10| 41 4e 3e 3c 53 50 41 4e | 20 3d 0d 0a 63 6c 61 73 |AN><SPAN| =..clas|
|00003b20| 73 3d 33 44 71 75 65 73 | 74 69 6f 6e 3e 49 3d 32 |s=3Dques|tion>I=2|
|00003b30| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00003b40| 20 20 20 20 20 77 61 6e | 74 20 74 6f 20 62 72 69 | wan|t to bri|
|00003b50| 6e 67 20 64 61 74 61 20 | 6f 66 20 74 77 6f 20 64 |ng data |of two d|
|00003b60| 61 74 61 62 61 73 65 20 | 6c 6f 63 61 74 65 64 20 |atabase |located |
|00003b70| 69 6e 20 3d 0d 0a 64 69 | 66 66 65 72 65 6e 74 20 |in =..di|fferent |
|00003b80| 68 6f 73 74 73 3d 32 30 | 0d 0a 20 20 20 20 20 20 |hosts=20|.. |
|00003b90| 20 20 20 20 20 20 20 20 | 20 20 20 20 69 6e 20 53 | | in S|
|00003ba0| 79 6e 63 20 77 69 74 68 | 20 65 61 63 68 20 6f 74 |ync with| each ot|
|00003bb0| 68 65 72 2e 20 48 6f 77 | 20 63 61 6e 20 49 20 64 |her. How| can I d|
|00003bc0| 6f 20 69 74 20 69 6e 20 | 53 51 4c 79 6f 67 3d 32 |o it in |SQLyog=2|
|00003bd0| 30 0d 0a 3f 3c 2f 53 50 | 41 4e 3e 3c 2f 50 3e 0d |0..?</SP|AN></P>.|
|00003be0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00003bf0| 20 20 20 3c 50 20 63 6c | 61 73 73 3d 33 44 74 65 | <P cl|ass=3Dte|
|00003c00| 78 74 20 61 6c 69 67 6e | 3d 33 44 6c 65 66 74 3e |xt align|=3Dleft>|
|00003c10| 41 2e 20 3c 53 50 41 4e | 20 3d 0d 0a 63 6c 61 73 |A. <SPAN| =..clas|
|00003c20| 73 3d 33 44 6e 6f 72 6d | 61 6c 3e 53 51 4c 79 6f |s=3Dnorm|al>SQLyo|
|00003c30| 67 20 4a 6f 62 3d 32 30 | 0d 0a 20 20 20 20 20 20 |g Job=20|.. |
|00003c40| 20 20 20 20 20 20 20 20 | 20 20 20 20 41 67 65 6e | | Agen|
|00003c50| 74 20 28 20 53 4a 41 20 | 29 20 69 73 20 61 20 68 |t ( SJA |) is a h|
|00003c60| 69 67 68 2d 70 65 72 66 | 6f 72 6d 61 6e 63 65 2c |igh-perf|ormance,|
|00003c70| 20 6d 75 6c 74 69 74 68 | 72 65 61 64 65 64 2c 20 | multith|readed, |
|00003c80| 3d 0d 0a 6d 75 6c 74 69 | 3d 32 30 0d 0a 20 20 20 |=..multi|=20.. |
|00003c90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 70 | | p|
|00003ca0| 6c 61 74 66 6f 72 6d 20 | 61 70 70 6c 69 63 61 74 |latform |applicat|
|00003cb0| 69 6f 6e 20 74 6f 20 61 | 75 74 6f 6d 61 74 65 20 |ion to a|utomate |
|00003cc0| 61 6e 64 20 73 63 68 65 | 64 75 6c 65 20 3d 0d 0a |and sche|dule =..|
|00003cd0| 53 79 6e 63 68 72 6f 6e | 69 7a 61 74 69 6f 6e 3d |Synchron|ization=|
|00003ce0| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00003cf0| 20 20 20 20 20 20 6f 66 | 20 44 61 74 61 20 62 65 | of| Data be|
|00003d00| 74 77 65 65 6e 20 74 77 | 6f 20 4d 79 53 51 4c 20 |tween tw|o MySQL |
|00003d10| 68 6f 73 74 73 2e 20 3c | 2f 53 50 41 4e 3e 3c 53 |hosts. <|/SPAN><S|
|00003d20| 50 41 4e 20 3d 0d 0a 63 | 6c 61 73 73 3d 33 44 6e |PAN =..c|lass=3Dn|
|00003d30| 6f 72 6d 61 6c 3e 4f 6e | 3d 32 30 0d 0a 20 20 20 |ormal>On|=20.. |
|00003d40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 57 | | W|
|00003d50| 69 6e 64 6f 77 73 2c 20 | 69 74 20 69 73 20 69 6e |indows, |it is in|
|00003d60| 63 6c 75 64 65 64 20 77 | 69 74 68 20 53 51 4c 79 |cluded w|ith SQLy|
|00003d70| 6f 67 20 33 2e 36 33 20 | 2d 20 74 68 65 20 6c 61 |og 3.63 |- the la|
|00003d80| 74 65 73 74 20 3d 0d 0a | 76 65 72 73 69 6f 6e 3d |test =..|version=|
|00003d90| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00003da0| 20 20 20 20 20 20 6f 66 | 20 74 68 65 20 61 77 61 | of| the awa|
|00003db0| 72 64 20 77 69 6e 6e 69 | 6e 67 20 4d 79 53 51 4c |rd winni|ng MySQL|
|00003dc0| 20 43 6c 69 65 6e 74 2e | 20 54 68 65 20 4c 69 6e | Client.| The Lin|
|00003dd0| 75 78 20 76 65 72 73 69 | 6f 6e 20 3d 0d 0a 6f 66 |ux versi|on =..of|
|00003de0| 20 53 4a 41 20 69 73 3d | 32 30 0d 0a 20 20 20 20 | SJA is=|20.. |
|00003df0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 46 52 | | FR|
|00003e00| 45 45 20 61 6e 64 20 63 | 61 6e 20 62 65 20 64 6f |EE and c|an be do|
|00003e10| 77 6e 6c 6f 61 64 65 64 | 20 66 72 6f 6d 20 3c 41 |wnloaded| from <A|
|00003e20| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00003e30| 20 20 20 20 20 20 20 3d | 0d 0a 68 72 65 66 3d 33 | =|..href=3|
|00003e40| 44 22 68 74 74 70 3a 2f | 2f 77 77 77 2e 77 65 62 |D"http:/|/www.web|
|00003e50| 79 6f 67 2e 63 6f 6d 2f | 73 71 6c 79 6f 67 2f 64 |yog.com/|sqlyog/d|
|00003e60| 6f 77 6e 73 6a 61 2e 68 | 74 6d 6c 22 3e 68 74 74 |ownsja.h|tml">htt|
|00003e70| 70 3a 2f 2f 77 77 77 2e | 77 65 62 79 6f 67 2e 63 |p://www.|webyog.c|
|00003e80| 6f 6d 2f 3d 0d 0a 73 71 | 6c 79 6f 67 2f 64 6f 77 |om/=..sq|lyog/dow|
|00003e90| 6e 73 6a 61 2e 68 74 6d | 6c 3c 2f 41 3e 2e 3d 32 |nsja.htm|l</A>.=2|
|00003ea0| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00003eb0| 20 20 20 20 20 49 6e 20 | 53 51 4c 79 6f 67 2c 20 | In |SQLyog, |
|00003ec0| 69 74 20 63 61 6e 20 62 | 65 20 61 63 63 65 73 73 |it can b|e access|
|00003ed0| 65 64 20 74 68 72 6f 75 | 67 68 20 3d 0d 0a 54 6f |ed throu|gh =..To|
|00003ee0| 6f 6c 73 2d 26 67 74 3b | 44 61 74 61 62 61 73 65 |ols->|Database|
|00003ef0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00003f00| 20 20 20 20 20 20 20 53 | 79 6e 63 68 72 6f 6e 69 | S|ynchroni|
|00003f10| 7a 61 74 69 6f 6e 20 57 | 69 7a 61 72 64 2e 3c 2f |zation W|izard.</|
|00003f20| 53 50 41 4e 3e 3c 2f 50 | 3e 0d 0a 20 20 20 20 20 |SPAN></P|>.. |
|00003f30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 50 20 | | <P |
|00003f40| 63 6c 61 73 73 3d 33 44 | 6e 6f 72 6d 61 6c 3e 53 |class=3D|normal>S|
|00003f50| 4a 41 20 64 6f 65 73 20 | 6e 6f 74 20 72 65 71 75 |JA does |not requ|
|00003f60| 69 72 65 20 61 6e 79 20 | 3d 0d 0a 69 6e 73 74 61 |ire any |=..insta|
|00003f70| 6c 6c 61 74 69 6f 6e 20 | 61 74 20 68 6f 73 74 73 |llation |at hosts|
|00003f80| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00003f90| 20 20 20 20 20 20 20 72 | 75 6e 6e 69 6e 67 20 74 | r|unning t|
|00003fa0| 68 65 20 4d 79 53 51 4c | 20 73 65 72 76 65 72 2e |he MySQL| server.|
|00003fb0| 20 59 6f 75 20 63 61 6e | 20 75 73 65 20 61 6e 79 | You can| use any|
|00003fc0| 20 68 6f 73 74 20 74 6f | 20 72 75 6e 20 3d 0d 0a | host to| run =..|
|00003fd0| 74 68 65 20 53 4a 41 2e | 3d 32 30 0d 0a 20 20 20 |the SJA.|=20.. |
|00003fe0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 46 | | F|
|00003ff0| 6f 72 20 65 78 61 6d 70 | 6c 65 20 3d 39 36 20 79 |or examp|le =96 y|
|00004000| 6f 75 20 63 61 6e 20 75 | 73 65 20 53 4a 41 20 74 |ou can u|se SJA t|
|00004010| 6f 20 6b 65 65 70 20 79 | 6f 75 72 20 3d 0d 0a 70 |o keep y|our =..p|
|00004020| 72 6f 64 75 63 74 69 6f | 6e 3d 32 30 0d 0a 20 20 |roductio|n=20.. |
|00004030| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004040| 64 61 74 61 62 61 73 65 | 73 20 28 20 70 72 6f 62 |database|s ( prob|
|00004050| 61 62 6c 79 20 68 6f 73 | 74 65 64 20 77 69 74 68 |ably hos|ted with|
|00004060| 20 61 6e 20 49 53 50 20 | 29 20 69 6e 20 63 6f 6d | an ISP |) in com|
|00004070| 70 6c 65 74 65 20 3d 0d | 0a 73 79 6e 63 3d 32 30 |plete =.|.sync=20|
|00004080| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00004090| 20 20 20 20 77 69 74 68 | 20 79 6f 75 72 20 74 65 | with| your te|
|000040a0| 73 74 20 64 61 74 61 62 | 61 73 65 20 6c 6f 63 61 |st datab|ase loca|
|000040b0| 74 65 64 20 69 6e 20 79 | 6f 75 72 20 50 43 20 6f |ted in y|our PC o|
|000040c0| 72 20 4c 41 4e 2e 20 3d | 0d 0a 3c 2f 50 3e 0d 0a |r LAN. =|..</P>..|
|000040d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000040e0| 20 20 3c 50 20 63 6c 61 | 73 73 3d 33 44 6e 6f 72 | <P cla|ss=3Dnor|
|000040f0| 6d 61 6c 3e 53 4a 41 20 | 75 73 65 73 20 61 6e 20 |mal>SJA |uses an |
|00004100| 65 66 66 69 63 69 65 6e | 74 20 61 6c 67 6f 72 69 |efficien|t algori|
|00004110| 74 68 6d 20 74 6f 20 3d | 0d 0a 67 65 6e 65 72 61 |thm to =|..genera|
|00004120| 74 65 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |te=20.. | |
|00004130| 20 20 20 20 20 20 20 20 | 20 63 68 65 63 6b 73 75 | | checksu|
|00004140| 6d 73 20 74 6f 20 66 69 | 6e 64 20 6f 75 74 20 74 |ms to fi|nd out t|
|00004150| 68 65 20 63 68 61 6e 67 | 65 73 2e 20 54 68 65 72 |he chang|es. Ther|
|00004160| 65 66 6f 72 65 2c 20 6f | 6e 6c 79 20 3d 0d 0a 74 |efore, o|nly =..t|
|00004170| 68 6f 73 65 20 72 6f 77 | 73 3d 32 30 0d 0a 20 20 |hose row|s=20.. |
|00004180| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004190| 74 68 61 74 20 68 61 76 | 65 20 62 65 65 6e 20 69 |that hav|e been i|
|000041a0| 6e 73 65 72 74 65 64 2c | 20 75 70 64 61 74 65 64 |nserted,| updated|
|000041b0| 20 6f 72 20 64 65 6c 65 | 74 65 64 20 73 69 6e 63 | or dele|ted sinc|
|000041c0| 65 20 74 68 65 20 3d 0d | 0a 6c 61 73 74 3d 32 30 |e the =.|.last=20|
|000041d0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|000041e0| 20 20 20 20 73 79 6e 63 | 20 61 72 65 20 74 72 61 | sync| are tra|
|000041f0| 6e 73 66 65 72 72 65 64 | 20 62 65 74 77 65 65 6e |nsferred| between|
|00004200| 20 74 68 65 20 68 6f 73 | 74 73 2e 20 3c 2f 50 3e | the hos|ts. </P>|
|00004210| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00004220| 20 20 20 20 3c 50 20 63 | 6c 61 73 73 3d 33 44 6e | <P c|lass=3Dn|
|00004230| 6f 72 6d 61 6c 3e 41 64 | 64 69 74 69 6f 6e 61 6c |ormal>Ad|ditional|
|00004240| 6c 79 2c 20 79 6f 75 20 | 63 61 6e 20 63 6f 6e 66 |ly, you |can conf|
|00004250| 69 67 75 72 65 20 53 4a | 41 20 3d 0d 0a 74 6f 20 |igure SJ|A =..to |
|00004260| 64 65 74 65 63 74 3d 32 | 30 0d 0a 20 20 20 20 20 |detect=2|0.. |
|00004270| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 63 68 61 | | cha|
|00004280| 6e 67 65 73 20 6f 6e 6c | 79 20 66 6f 72 20 73 70 |nges onl|y for sp|
|00004290| 65 63 69 66 69 63 20 72 | 6f 77 73 20 61 6e 64 20 |ecific r|ows and |
|000042a0| 63 6f 6c 75 6d 6e 73 2e | 20 46 6f 72 20 3d 0d 0a |columns.| For =..|
|000042b0| 65 78 61 6d 70 6c 65 20 | 3d 39 36 20 79 6f 75 3d |example |=96 you=|
|000042c0| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|000042d0| 20 20 20 20 20 20 63 61 | 6e 20 65 78 63 6c 75 64 | ca|n exclud|
|000042e0| 65 20 62 6c 6f 62 20 63 | 6f 6c 75 6d 6e 73 20 6f |e blob c|olumns o|
|000042f0| 72 20 69 6e 63 6c 75 64 | 65 20 6f 6e 6c 79 20 74 |r includ|e only t|
|00004300| 68 6f 73 65 20 72 6f 77 | 73 20 3d 0d 0a 74 68 61 |hose row|s =..tha|
|00004310| 74 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |t=20.. | |
|00004320| 20 20 20 20 20 20 20 20 | 66 75 6c 66 69 6c 6c 20 | |fulfill |
|00004330| 61 20 57 48 45 52 45 20 | 63 6c 61 75 73 65 2e 20 |a WHERE |clause. |
|00004340| 54 68 69 73 20 6d 61 6b | 65 73 20 69 73 20 61 6e |This mak|es is an|
|00004350| 20 69 64 65 61 6c 20 74 | 6f 6f 6c 20 74 6f 20 3d | ideal t|ool to =|
|00004360| 0d 0a 73 79 6e 63 3d 32 | 30 0d 0a 20 20 20 20 20 |..sync=2|0.. |
|00004370| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 64 61 74 | | dat|
|00004380| 61 20 65 76 65 6e 20 69 | 66 20 74 68 65 72 65 20 |a even i|f there |
|00004390| 69 73 20 6c 69 6d 69 74 | 65 64 20 62 61 6e 64 77 |is limit|ed bandw|
|000043a0| 69 64 74 68 2e 3c 2f 50 | 3e 0d 0a 20 20 20 20 20 |idth.</P|>.. |
|000043b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 3c 50 20 | | <P |
|000043c0| 63 6c 61 73 73 3d 33 44 | 6e 6f 72 6d 61 6c 3e 53 |class=3D|normal>S|
|000043d0| 4a 41 20 69 73 20 61 20 | 63 6f 6d 6d 61 6e 64 20 |JA is a |command |
|000043e0| 6c 69 6e 65 20 74 6f 6f | 6c 20 74 68 61 74 20 3d |line too|l that =|
|000043f0| 0d 0a 61 63 63 65 70 74 | 73 20 61 20 4a 6f 62 3d |..accept|s a Job=|
|00004400| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00004410| 20 20 20 20 20 20 44 65 | 66 69 6e 69 74 69 6f 6e | De|finition|
|00004420| 20 66 69 6c 65 20 65 6e | 63 6f 64 65 64 20 69 6e | file en|coded in|
|00004430| 20 58 4d 4c 20 61 73 20 | 6f 6e 65 20 6f 66 20 74 | XML as |one of t|
|00004440| 68 65 20 3d 0d 0a 70 61 | 72 61 6d 65 74 65 72 73 |he =..pa|rameters|
|00004450| 2e 20 59 6f 75 3d 32 30 | 0d 0a 20 20 20 20 20 20 |. You=20|.. |
|00004460| 20 20 20 20 20 20 20 20 | 20 20 20 20 63 61 6e 20 | | can |
|00004470| 65 69 74 68 65 72 20 63 | 72 65 61 74 65 20 74 68 |either c|reate th|
|00004480| 65 20 4a 6f 62 20 44 65 | 66 69 6e 69 74 69 6f 6e |e Job De|finition|
|00004490| 20 66 69 6c 65 20 6d 61 | 6e 75 61 6c 6c 79 20 6f | file ma|nually o|
|000044a0| 72 20 3d 0d 0a 75 73 65 | 20 6f 6e 65 3d 32 30 0d |r =..use| one=20.|
|000044b0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000044c0| 20 20 20 6f 66 20 74 68 | 65 20 77 69 7a 61 72 64 | of th|e wizard|
|000044d0| 73 20 69 6e 63 6c 75 64 | 65 64 20 77 69 74 68 20 |s includ|ed with |
|000044e0| 53 51 4c 79 6f 67 2e 20 | 49 66 20 79 6f 75 20 75 |SQLyog. |If you u|
|000044f0| 73 65 20 53 51 4c 79 6f | 67 20 3d 0d 0a 74 6f 3d |se SQLyo|g =..to=|
|00004500| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00004510| 20 20 20 20 20 20 63 72 | 65 61 74 65 20 79 6f 75 | cr|eate you|
|00004520| 72 20 6a 6f 62 20 66 69 | 6c 65 73 2c 20 79 6f 75 |r job fi|les, you|
|00004530| 20 64 6f 6e 3d 39 32 74 | 20 6e 65 65 64 20 74 6f | don=92t| need to|
|00004540| 20 68 61 76 65 20 61 6e | 79 20 3d 0d 0a 6b 6e 6f | have an|y =..kno|
|00004550| 77 6c 65 64 67 65 3d 32 | 30 0d 0a 20 20 20 20 20 |wledge=2|0.. |
|00004560| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 61 62 6f | | abo|
|00004570| 75 74 20 58 4d 4c 20 6f | 72 20 74 68 65 20 4a 6f |ut XML o|r the Jo|
|00004580| 62 20 44 65 66 69 6e 69 | 74 69 6f 6e 20 73 63 68 |b Defini|tion sch|
|00004590| 65 6d 61 2e 3c 2f 50 3e | 0d 0a 20 20 20 20 20 20 |ema.</P>|.. |
|000045a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 3c 50 3e 3c | | <P><|
|000045b0| 53 50 41 4e 20 63 6c 61 | 73 73 3d 33 44 6e 6f 72 |SPAN cla|ss=3Dnor|
|000045c0| 6d 61 6c 3e 4f 6e 20 57 | 69 6e 64 6f 77 73 20 70 |mal>On W|indows p|
|000045d0| 6c 61 74 66 6f 72 6d 73 | 2c 20 53 51 4c 79 6f 67 |latforms|, SQLyog|
|000045e0| 20 3d 0d 0a 75 73 65 73 | 20 74 68 65 3d 32 30 0d | =..uses| the=20.|
|000045f0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00004600| 20 20 20 54 61 73 6b 20 | 53 63 68 65 64 75 6c 65 | Task |Schedule|
|00004610| 72 20 73 65 72 76 69 63 | 65 73 20 74 6f 20 73 63 |r servic|es to sc|
|00004620| 68 65 64 75 6c 65 20 79 | 6f 75 72 20 6a 6f 62 73 |hedule y|our jobs|
|00004630| 2e 20 4f 6e 20 3d 0d 0a | 6f 74 68 65 72 3d 32 30 |. On =..|other=20|
|00004640| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00004650| 20 20 20 20 70 6c 61 74 | 66 6f 72 6d 73 20 79 6f | plat|forms yo|
|00004660| 75 20 63 61 6e 20 75 73 | 65 20 74 68 65 20 72 65 |u can us|e the re|
|00004670| 73 70 65 63 74 69 76 65 | 20 4f 53 20 73 63 68 65 |spective| OS sche|
|00004680| 64 75 6c 69 6e 67 20 3d | 0d 0a 73 65 72 76 69 63 |duling =|..servic|
|00004690| 65 73 2c 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |es,=20..| |
|000046a0| 20 20 20 20 20 20 20 20 | 20 20 65 2e 67 20 3d 39 | | e.g =9|
|000046b0| 36 20 6f 6e 20 4c 69 6e | 75 78 2c 20 79 6f 75 20 |6 on Lin|ux, you |
|000046c0| 63 61 6e 20 75 73 65 20 | 63 72 6f 6e 20 74 6f 20 |can use |cron to |
|000046d0| 73 63 68 65 64 75 6c 65 | 3d 32 30 0d 0a 20 20 20 |schedule|=20.. |
|000046e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 6a | | j|
|000046f0| 6f 62 73 3c 2f 53 50 41 | 4e 3e 2e 3c 42 52 3e 3c |obs</SPA|N>.<BR><|
|00004700| 53 50 41 4e 20 63 6c 61 | 73 73 3d 33 44 71 75 65 |SPAN cla|ss=3Dque|
|00004710| 73 74 69 6f 6e 3e 3c 2f | 53 50 41 4e 3e 3c 2f 50 |stion></|SPAN></P|
|00004720| 3e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |>.. | |
|00004730| 20 20 20 20 20 3c 50 3e | 3c 53 50 41 4e 20 63 6c | <P>|<SPAN cl|
|00004740| 61 73 73 3d 33 44 71 75 | 65 73 74 69 6f 6e 3e 51 |ass=3Dqu|estion>Q|
|00004750| 2e 20 3c 2f 53 50 41 4e | 3e 3c 53 50 41 4e 20 3d |. </SPAN|><SPAN =|
|00004760| 0d 0a 63 6c 61 73 73 3d | 33 44 71 75 65 73 74 69 |..class=|3Dquesti|
|00004770| 6f 6e 3e 49 20 68 61 76 | 65 3d 32 30 0d 0a 20 20 |on>I hav|e=20.. |
|00004780| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004790| 61 20 76 65 72 79 20 62 | 69 67 20 72 65 73 75 6c |a very b|ig resul|
|000047a0| 74 20 61 6e 64 20 49 20 | 77 6f 75 6c 64 20 6c 69 |t and I |would li|
|000047b0| 6b 65 20 74 6f 20 75 73 | 65 20 74 68 65 20 63 6f |ke to us|e the co|
|000047c0| 6d 70 6c 65 74 65 20 3d | 0d 0a 73 63 72 65 65 6e |mplete =|..screen|
|000047d0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|000047e0| 20 20 20 20 20 20 20 61 | 72 65 61 20 66 6f 72 20 | a|rea for |
|000047f0| 76 69 65 77 69 6e 67 20 | 74 68 65 20 72 65 73 75 |viewing |the resu|
|00004800| 6c 74 2e 20 48 6f 77 20 | 63 61 6e 20 49 20 64 6f |lt. How |can I do|
|00004810| 20 74 68 61 74 20 3d 0d | 0a 3f 3c 2f 53 50 41 4e | that =.|.?</SPAN|
|00004820| 3e 3c 2f 50 3e 0d 0a 20 | 20 20 20 20 20 20 20 20 |></P>.. | |
|00004830| 20 20 20 20 20 20 20 20 | 20 3c 50 20 63 6c 61 73 | | <P clas|
|00004840| 73 3d 33 44 74 65 78 74 | 20 61 6c 69 67 6e 3d 33 |s=3Dtext| align=3|
|00004850| 44 6c 65 66 74 3e 41 2e | 20 53 51 4c 79 6f 67 20 |Dleft>A.| SQLyog |
|00004860| 61 6c 6c 6f 77 73 20 79 | 6f 75 20 74 6f 20 3d 0d |allows y|ou to =.|
|00004870| 0a 73 68 6f 77 2f 68 69 | 64 65 3d 32 30 0d 0a 20 |.show/hi|de=20.. |
|00004880| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004890| 20 4f 62 6a 65 63 74 20 | 42 72 6f 77 73 65 72 2c | Object |Browser,|
|000048a0| 20 52 65 73 75 6c 74 20 | 50 61 6e 65 20 61 73 20 | Result |Pane as |
|000048b0| 77 65 6c 6c 20 61 73 20 | 74 68 65 20 51 75 65 72 |well as |the Quer|
|000048c0| 79 20 3d 0d 0a 57 69 6e | 64 6f 77 2e 3d 32 30 0d |y =..Win|dow.=20.|
|000048d0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000048e0| 20 20 20 54 68 65 72 65 | 66 6f 72 65 20 62 79 20 | There|fore by |
|000048f0| 68 69 64 69 6e 67 20 51 | 75 65 72 79 20 57 69 6e |hiding Q|uery Win|
|00004900| 64 6f 77 20 61 6e 64 20 | 4f 62 6a 65 63 74 20 42 |dow and |Object B|
|00004910| 72 6f 77 73 65 72 20 3d | 0d 0a 79 6f 75 20 63 61 |rowser =|..you ca|
|00004920| 6e 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |n=20.. | |
|00004930| 20 20 20 20 20 20 20 20 | 75 73 65 20 74 68 65 20 | |use the |
|00004940| 63 6f 6d 70 6c 65 74 65 | 20 73 70 61 63 65 20 66 |complete| space f|
|00004950| 6f 72 20 76 69 65 77 69 | 6e 67 20 79 6f 75 72 20 |or viewi|ng your |
|00004960| 72 65 73 75 6c 74 73 65 | 74 2e 20 59 6f 75 20 3d |resultse|t. You =|
|00004970| 0d 0a 63 61 6e 3d 32 30 | 0d 0a 20 20 20 20 20 20 |..can=20|.. |
|00004980| 20 20 20 20 20 20 20 20 | 20 20 20 20 73 68 6f 77 | | show|
|00004990| 2f 68 69 64 65 20 4f 62 | 6a 65 63 74 20 42 72 6f |/hide Ob|ject Bro|
|000049a0| 77 73 65 72 20 62 79 20 | 70 72 65 73 73 69 6e 67 |wser by |pressing|
|000049b0| 20 43 74 72 6c 2b 31 20 | 61 6e 64 20 3d 0d 0a 73 | Ctrl+1 |and =..s|
|000049c0| 68 6f 77 2f 68 69 64 65 | 3d 32 30 0d 0a 20 20 20 |how/hide|=20.. |
|000049d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 51 | | Q|
|000049e0| 75 65 72 79 20 57 69 6e | 64 6f 77 20 62 79 20 70 |uery Win|dow by p|
|000049f0| 72 65 73 73 69 6e 67 20 | 43 74 72 6c 2b 33 2e 3c |ressing |Ctrl+3.<|
|00004a00| 2f 50 3e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |/P>.. | |
|00004a10| 20 20 20 20 20 20 20 3c | 50 20 63 6c 61 73 73 3d | <|P class=|
|00004a20| 33 44 74 65 78 74 20 61 | 6c 69 67 6e 3d 33 44 6c |3Dtext a|lign=3Dl|
|00004a30| 65 66 74 3e 3c 53 50 41 | 4e 20 63 6c 61 73 73 3d |eft><SPA|N class=|
|00004a40| 33 44 71 75 65 73 74 69 | 6f 6e 3e 51 2e 20 3d 0d |3Dquesti|on>Q. =.|
|00004a50| 0a 49 20 77 6f 75 6c 64 | 20 6c 69 6b 65 3d 32 30 |.I would| like=20|
|00004a60| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00004a70| 20 20 20 20 74 6f 20 67 | 65 74 20 6d 79 20 72 65 | to g|et my re|
|00004a80| 73 75 6c 74 73 20 69 6e | 20 74 65 78 74 20 66 6f |sults in| text fo|
|00004a90| 72 6d 20 73 6f 20 74 68 | 61 74 20 49 20 63 61 6e |rm so th|at I can|
|00004aa0| 20 73 65 61 72 63 68 20 | 3d 0d 0a 66 6f 72 20 61 | search |=..for a|
|00004ab0| 3d 32 30 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |=20.. | |
|00004ac0| 20 20 20 20 20 20 20 73 | 74 72 69 6e 67 20 6f 72 | s|tring or|
|00004ad0| 20 63 6f 70 79 20 70 6f | 72 74 69 6f 6e 73 20 6f | copy po|rtions o|
|00004ae0| 66 20 72 65 73 75 6c 74 | 73 65 74 20 61 73 20 74 |f result|set as t|
|00004af0| 65 78 74 20 74 6f 20 74 | 68 65 20 3d 0d 0a 63 6c |ext to t|he =..cl|
|00004b00| 69 70 62 6f 61 72 64 2e | 3d 32 30 0d 0a 20 20 20 |ipboard.|=20.. |
|00004b10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 49 | | I|
|00004b20| 73 20 69 74 20 70 6f 73 | 73 69 62 6c 65 20 3f 3c |s it pos|sible ?<|
|00004b30| 2f 53 50 41 4e 3e 3c 2f | 50 3e 0d 0a 20 20 20 20 |/SPAN></|P>.. |
|00004b40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3c 50 | | <P|
|00004b50| 20 63 6c 61 73 73 3d 33 | 44 74 65 78 74 20 61 6c | class=3|Dtext al|
|00004b60| 69 67 6e 3d 33 44 6c 65 | 66 74 3e 41 2e 20 53 51 |ign=3Dle|ft>A. SQ|
|00004b70| 4c 79 6f 67 20 61 6c 6c | 6f 77 73 20 79 6f 75 20 |Lyog all|ows you |
|00004b80| 74 6f 20 3d 0d 0a 76 69 | 65 77 20 79 6f 75 72 3d |to =..vi|ew your=|
|00004b90| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00004ba0| 20 20 20 20 20 20 72 65 | 73 75 6c 74 73 65 74 20 | re|sultset |
|00004bb0| 69 6e 20 47 72 69 64 20 | 61 73 20 77 65 6c 6c 20 |in Grid |as well |
|00004bc0| 61 73 20 54 65 78 74 20 | 4d 6f 64 65 2e 20 59 6f |as Text |Mode. Yo|
|00004bd0| 75 20 63 61 6e 20 74 6f | 67 67 6c 65 20 3d 0d 0a |u can to|ggle =..|
|00004be0| 62 65 74 77 65 65 6e 3d | 32 30 0d 0a 20 20 20 20 |between=|20.. |
|00004bf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 74 68 | | th|
|00004c00| 65 20 6d 6f 64 65 73 20 | 62 79 20 70 72 65 73 73 |e modes |by press|
|00004c10| 69 6e 67 20 43 74 72 6c | 2b 4c 2e 20 49 6e 20 74 |ing Ctrl|+L. In t|
|00004c20| 68 65 20 54 65 78 74 20 | 6d 6f 64 65 20 73 65 74 |he Text |mode set|
|00004c30| 20 3d 0d 0a 79 6f 75 72 | 20 63 75 72 73 6f 72 3d | =..your| cursor=|
|00004c40| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00004c50| 20 20 20 20 20 20 69 6e | 20 74 68 65 20 72 65 73 | in| the res|
|00004c60| 75 6c 74 20 70 61 6e 65 | 20 61 6e 64 20 70 72 65 |ult pane| and pre|
|00004c70| 73 73 20 43 74 72 6c 2b | 46 20 74 6f 20 73 65 61 |ss Ctrl+|F to sea|
|00004c80| 72 63 68 20 66 6f 72 20 | 61 20 3d 0d 0a 73 74 72 |rch for |a =..str|
|00004c90| 69 6e 67 2e 20 3c 41 3d | 32 30 0d 0a 20 20 20 20 |ing. <A=|20.. |
|00004ca0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3d 0d | | =.|
|00004cb0| 0a 68 72 65 66 3d 33 44 | 22 68 74 74 70 3a 2f 2f |.href=3D|"http://|
|00004cc0| 77 77 77 2e 77 65 62 79 | 6f 67 2e 63 6f 6d 2f 73 |www.weby|og.com/s|
|00004cd0| 71 6c 79 6f 67 2f 73 71 | 6c 79 6f 67 68 65 6c 70 |qlyog/sq|lyoghelp|
|00004ce0| 2f 69 6d 61 67 65 34 2e | 67 69 66 22 3e 63 6c 69 |/image4.|gif">cli|
|00004cf0| 63 6b 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |ck=20.. | |
|00004d00| 20 20 20 20 20 20 20 20 | 20 68 65 72 65 20 74 6f | | here to|
|00004d10| 20 73 65 65 20 61 20 73 | 63 72 65 65 6e 73 68 6f | see a s|creensho|
|00004d20| 74 20 6f 66 20 72 65 73 | 75 6c 74 20 69 6e 20 74 |t of res|ult in t|
|00004d30| 65 78 74 3c 2f 41 3e 3c | 2f 50 3e 0d 0a 20 20 20 |ext</A><|/P>.. |
|00004d40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c | | <|
|00004d50| 50 20 63 6c 61 73 73 3d | 33 44 74 65 78 74 20 61 |P class=|3Dtext a|
|00004d60| 6c 69 67 6e 3d 33 44 6c | 65 66 74 3e 3c 53 50 41 |lign=3Dl|eft><SPA|
|00004d70| 4e 20 63 6c 61 73 73 3d | 33 44 71 75 65 73 74 69 |N class=|3Dquesti|
|00004d80| 6f 6e 3e 51 2e 20 3d 0d | 0a 49 20 68 61 76 65 20 |on>Q. =.|.I have |
|00004d90| 61 20 76 65 72 79 3d 32 | 30 0d 0a 20 20 20 20 20 |a very=2|0.. |
|00004da0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 62 69 67 | | big|
|00004db0| 20 71 75 65 72 79 20 61 | 6e 64 20 49 20 77 6f 75 | query a|nd I wou|
|00004dc0| 6c 64 20 6c 69 6b 65 20 | 74 6f 20 75 73 65 20 74 |ld like |to use t|
|00004dd0| 68 65 20 63 6f 6d 70 6c | 65 74 65 20 73 63 72 65 |he compl|ete scre|
|00004de0| 65 6e 20 3d 0d 0a 61 72 | 65 61 20 66 6f 72 3d 32 |en =..ar|ea for=2|
|00004df0| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00004e00| 20 20 20 20 20 65 64 69 | 74 69 6e 67 2e 20 48 6f | edi|ting. Ho|
|00004e10| 77 20 63 61 6e 20 49 20 | 64 6f 20 74 68 61 74 20 |w can I |do that |
|00004e20| 3f 3c 2f 53 50 41 4e 3e | 3c 2f 50 3e 0d 0a 20 20 |?</SPAN>|</P>.. |
|00004e30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e40| 3c 50 20 63 6c 61 73 73 | 3d 33 44 74 65 78 74 20 |<P class|=3Dtext |
|00004e50| 61 6c 69 67 6e 3d 33 44 | 6c 65 66 74 3e 41 2e 20 |align=3D|left>A. |
|00004e60| 53 51 4c 79 6f 67 20 61 | 6c 6c 6f 77 73 20 79 6f |SQLyog a|llows yo|
|00004e70| 75 20 74 6f 20 3d 0d 0a | 73 68 6f 77 2f 68 69 64 |u to =..|show/hid|
|00004e80| 65 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |e=20.. | |
|00004e90| 20 20 20 20 20 20 20 20 | 4f 62 6a 65 63 74 20 42 | |Object B|
|00004ea0| 72 6f 77 73 65 72 2c 20 | 52 65 73 75 6c 74 20 50 |rowser, |Result P|
|00004eb0| 61 6e 65 20 61 73 20 77 | 65 6c 6c 20 61 73 20 74 |ane as w|ell as t|
|00004ec0| 68 65 20 51 75 65 72 79 | 20 3d 0d 0a 57 69 6e 64 |he Query| =..Wind|
|00004ed0| 6f 77 2e 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |ow.=20..| |
|00004ee0| 20 20 20 20 20 20 20 20 | 20 20 54 68 65 72 65 66 | | Theref|
|00004ef0| 6f 72 65 20 62 79 20 68 | 69 64 69 6e 67 20 4f 62 |ore by h|iding Ob|
|00004f00| 6a 65 63 74 20 42 72 6f | 77 73 65 72 20 61 6e 64 |ject Bro|wser and|
|00004f10| 20 74 68 65 20 52 65 73 | 75 6c 74 20 50 61 6e 65 | the Res|ult Pane|
|00004f20| 20 3d 0d 0a 79 6f 75 20 | 63 61 6e 3d 32 30 0d 0a | =..you |can=20..|
|00004f30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004f40| 20 20 75 73 65 20 74 68 | 65 20 63 6f 6d 70 6c 65 | use th|e comple|
|00004f50| 74 65 20 73 70 61 63 65 | 20 69 6e 20 65 64 69 74 |te space| in edit|
|00004f60| 69 6e 67 20 79 6f 75 72 | 20 71 75 65 72 79 2e 20 |ing your| query. |
|00004f70| 59 6f 75 20 63 61 6e 3d | 32 30 0d 0a 20 20 20 20 |You can=|20.. |
|00004f80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 73 68 | | sh|
|00004f90| 6f 77 2f 68 69 64 65 20 | 4f 62 6a 65 63 74 20 42 |ow/hide |Object B|
|00004fa0| 72 6f 77 73 65 72 20 62 | 79 20 70 72 65 73 73 69 |rowser b|y pressi|
|00004fb0| 6e 67 20 43 74 72 6c 2b | 31 20 61 6e 64 20 3d 0d |ng Ctrl+|1 and =.|
|00004fc0| 0a 73 68 6f 77 2f 68 69 | 64 65 3d 32 30 0d 0a 20 |.show/hi|de=20.. |
|00004fd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004fe0| 20 52 65 73 75 6c 74 20 | 50 61 6e 65 20 62 79 20 | Result |Pane by |
|00004ff0| 70 72 65 73 73 69 6e 67 | 20 43 74 72 6c 2b 32 2e |pressing| Ctrl+2.|
|00005000| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00005010| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|00005020| 3d 33 44 74 65 78 74 20 | 61 6c 69 67 6e 3d 33 44 |=3Dtext |align=3D|
|00005030| 6c 65 66 74 3e 3c 53 50 | 41 4e 20 63 6c 61 73 73 |left><SP|AN class|
|00005040| 3d 33 44 71 75 65 73 74 | 69 6f 6e 3e 51 2e 20 3d |=3Dquest|ion>Q. =|
|00005050| 0d 0a 49 20 68 61 76 65 | 20 61 20 68 75 67 65 3d |..I have| a huge=|
|00005060| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00005070| 20 20 20 20 20 20 53 51 | 4c 20 62 61 74 63 68 20 | SQ|L batch |
|00005080| 66 69 6c 65 20 28 20 69 | 6e 20 67 69 67 61 62 79 |file ( i|n gigaby|
|00005090| 74 65 73 21 20 29 2e 20 | 48 6f 77 20 63 61 6e 20 |tes! ). |How can |
|000050a0| 49 20 65 78 65 63 75 74 | 65 20 69 74 20 3d 0d 0a |I execut|e it =..|
|000050b0| 75 73 69 6e 67 3d 32 30 | 0d 0a 20 20 20 20 20 20 |using=20|.. |
|000050c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 51 4c 79 | | SQLy|
|000050d0| 6f 67 20 3f 3c 2f 53 50 | 41 4e 3e 3c 2f 50 3e 0d |og ?</SP|AN></P>.|
|000050e0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000050f0| 20 20 20 3c 50 20 63 6c | 61 73 73 3d 33 44 74 65 | <P cl|ass=3Dte|
|00005100| 78 74 20 61 6c 69 67 6e | 3d 33 44 6c 65 66 74 3e |xt align|=3Dleft>|
|00005110| 41 2e 20 53 51 4c 79 6f | 67 20 61 6c 6c 6f 77 73 |A. SQLyo|g allows|
|00005120| 20 79 6f 75 20 74 6f 20 | 3d 0d 0a 65 78 65 63 75 | you to |=..execu|
|00005130| 74 65 20 61 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |te a=20.|. |
|00005140| 20 20 20 20 20 20 20 20 | 20 20 20 62 61 74 63 68 | | batch|
|00005150| 20 66 69 6c 65 20 6f 66 | 20 61 6e 79 20 73 69 7a | file of| any siz|
|00005160| 65 20 28 79 65 73 2e 2e | 2e 2e 61 6e 79 20 73 69 |e (yes..|..any si|
|00005170| 7a 65 20 2d 20 6c 69 6d | 69 74 65 64 20 62 79 20 |ze - lim|ited by |
|00005180| 3d 0d 0a 74 68 65 20 4f | 53 29 2e 3d 32 30 0d 0a |=..the O|S).=20..|
|00005190| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000051a0| 20 20 53 65 6c 65 63 74 | 20 54 6f 6f 6c 73 20 2d | Select| Tools -|
|000051b0| 26 67 74 3b 20 45 78 65 | 63 75 74 65 20 42 61 74 |> Exe|cute Bat|
|000051c0| 63 68 20 46 69 6c 65 20 | 28 43 74 72 6c 2b 53 68 |ch File |(Ctrl+Sh|
|000051d0| 69 66 74 2b 51 29 2e 20 | 3d 0d 0a 53 65 6c 65 63 |ift+Q). |=..Selec|
|000051e0| 74 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |t=20.. | |
|000051f0| 20 20 20 20 20 20 20 20 | 74 68 65 20 66 69 6c 65 | |the file|
|00005200| 20 61 6e 64 20 70 72 65 | 73 73 20 45 78 65 63 75 | and pre|ss Execu|
|00005210| 74 65 2e 20 49 66 20 53 | 51 4c 79 6f 67 20 65 6e |te. If S|QLyog en|
|00005220| 63 6f 75 6e 74 65 72 73 | 20 61 6e 20 3d 0d 0a 65 |counters| an =..e|
|00005230| 72 72 6f 72 20 69 74 3d | 32 30 0d 0a 20 20 20 20 |rror it=|20.. |
|00005240| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 73 74 | | st|
|00005250| 6f 70 73 20 66 75 72 74 | 68 65 72 20 65 78 65 63 |ops furt|her exec|
|00005260| 75 74 69 6f 6e 20 61 6e | 64 20 6c 6f 67 73 20 74 |ution an|d logs t|
|00005270| 68 65 20 71 75 65 72 79 | 20 61 73 20 77 65 6c 6c |he query| as well|
|00005280| 20 61 73 20 3d 0d 0a 74 | 68 65 3d 32 30 0d 0a 20 | as =..t|he=20.. |
|00005290| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000052a0| 20 65 72 72 6f 72 20 6d | 65 73 73 61 67 65 20 69 | error m|essage i|
|000052b0| 6e 20 73 71 6c 79 6f 67 | 2e 65 72 72 20 6c 6f 63 |n sqlyog|.err loc|
|000052c0| 61 74 65 64 20 69 6e 20 | 74 68 65 20 53 51 4c 79 |ated in |the SQLy|
|000052d0| 6f 67 20 3d 0d 0a 69 6e | 73 74 61 6c 6c 61 74 69 |og =..in|stallati|
|000052e0| 6f 6e 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |on=20.. | |
|000052f0| 20 20 20 20 20 20 20 20 | 20 66 6f 6c 64 65 72 2e | | folder.|
|00005300| 20 3c 41 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 | <A=20..| |
|00005310| 20 20 20 20 20 20 20 20 | 20 20 3d 0d 0a 68 72 65 | | =..hre|
|00005320| 66 3d 33 44 22 68 74 74 | 70 3a 2f 2f 77 77 77 2e |f=3D"htt|p://www.|
|00005330| 77 65 62 79 6f 67 2e 63 | 6f 6d 2f 73 71 6c 79 6f |webyog.c|om/sqlyo|
|00005340| 67 2f 73 71 6c 79 6f 67 | 68 65 6c 70 2f 69 6d 61 |g/sqlyog|help/ima|
|00005350| 67 65 32 37 2e 67 69 66 | 22 3e 63 6c 69 63 6b 3d |ge27.gif|">click=|
|00005360| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00005370| 20 20 20 20 20 20 68 65 | 72 65 20 74 6f 20 73 65 | he|re to se|
|00005380| 65 20 61 20 73 63 72 65 | 65 6e 73 68 6f 74 20 6f |e a scre|enshot o|
|00005390| 66 20 65 78 65 63 75 74 | 65 20 62 61 74 63 68 20 |f execut|e batch |
|000053a0| 66 69 6c 65 20 64 69 61 | 6c 6f 67 3d 32 30 0d 0a |file dia|log=20..|
|000053b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000053c0| 20 20 62 6f 78 3c 2f 41 | 3e 3c 2f 50 3e 0d 0a 20 | box</A|></P>.. |
|000053d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000053e0| 20 3c 50 20 63 6c 61 73 | 73 3d 33 44 74 65 78 74 | <P clas|s=3Dtext|
|000053f0| 20 61 6c 69 67 6e 3d 33 | 44 6c 65 66 74 3e 3c 53 | align=3|Dleft><S|
|00005400| 50 41 4e 20 63 6c 61 73 | 73 3d 33 44 71 75 65 73 |PAN clas|s=3Dques|
|00005410| 74 69 6f 6e 3e 51 2e 20 | 3d 0d 0a 49 20 77 61 6e |tion>Q. |=..I wan|
|00005420| 74 20 74 6f 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |t to=20.|. |
|00005430| 20 20 20 20 20 20 20 20 | 20 20 20 65 78 70 6f 72 | | expor|
|00005440| 74 20 74 68 65 20 72 65 | 73 75 6c 74 73 65 74 20 |t the re|sultset |
|00005450| 69 6e 20 61 20 66 69 6c | 65 20 6f 6e 20 74 68 65 |in a fil|e on the|
|00005460| 20 63 6c 69 65 6e 74 2e | 20 54 68 65 20 3d 0d 0a | client.| The =..|
|00005470| 4d 79 53 51 4c 3d 32 30 | 0d 0a 20 20 20 20 20 20 |MySQL=20|.. |
|00005480| 20 20 20 20 20 20 20 20 | 20 20 20 20 63 6f 6d 6d | | comm|
|00005490| 61 6e 64 20 53 45 4c 45 | 43 54 20 49 4e 54 4f 20 |and SELE|CT INTO |
|000054a0| 4f 55 54 46 49 4c 45 2e | 2e 2e 20 63 72 65 61 74 |OUTFILE.|.. creat|
|000054b0| 65 73 20 61 20 66 69 6c | 65 20 6f 6e 20 74 68 65 |es a fil|e on the|
|000054c0| 20 3d 0d 0a 73 65 72 76 | 65 72 3d 32 30 0d 0a 20 | =..serv|er=20.. |
|000054d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000054e0| 20 6f 6e 6c 79 2e 20 43 | 61 6e 20 53 51 4c 79 6f | only. C|an SQLyo|
|000054f0| 67 20 63 72 65 61 74 65 | 20 61 20 66 69 6c 65 20 |g create| a file |
|00005500| 6f 6e 20 74 68 65 20 63 | 6c 69 65 6e 74 20 3d 0d |on the c|lient =.|
|00005510| 0a 3f 3c 2f 53 50 41 4e | 3e 3c 2f 50 3e 0d 0a 20 |.?</SPAN|></P>.. |
|00005520| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005530| 20 3c 50 20 63 6c 61 73 | 73 3d 33 44 74 65 78 74 | <P clas|s=3Dtext|
|00005540| 20 61 6c 69 67 6e 3d 33 | 44 6c 65 66 74 3e 41 2e | align=3|Dleft>A.|
|00005550| 20 41 66 74 65 72 20 79 | 6f 75 20 65 78 65 63 75 | After y|ou execu|
|00005560| 74 65 20 61 20 3d 0d 0a | 71 75 65 72 79 2e 20 53 |te a =..|query. S|
|00005570| 65 6c 65 63 74 3d 32 30 | 0d 0a 20 20 20 20 20 20 |elect=20|.. |
|00005580| 20 20 20 20 20 20 20 20 | 20 20 20 20 74 68 65 20 | | the |
|00005590| 74 61 62 20 6f 66 20 74 | 68 65 20 70 61 72 74 69 |tab of t|he parti|
|000055a0| 63 75 6c 61 72 20 72 65 | 73 75 6c 74 73 65 74 20 |cular re|sultset |
|000055b0| 77 68 69 63 68 20 79 6f | 75 20 77 61 6e 74 20 74 |which yo|u want t|
|000055c0| 6f 20 3d 0d 0a 65 78 70 | 6f 72 74 3d 32 30 0d 0a |o =..exp|ort=20..|
|000055d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000055e0| 20 20 61 6e 64 20 72 69 | 67 68 74 20 63 6c 69 63 | and ri|ght clic|
|000055f0| 6b 20 6f 6e 20 69 74 20 | 28 20 43 74 72 6c 2b 53 |k on it |( Ctrl+S|
|00005600| 68 69 66 74 2b 45 20 29 | 20 61 6e 64 20 73 65 6c |hift+E )| and sel|
|00005610| 65 63 74 20 3d 0d 0a 45 | 78 70 6f 72 74 3d 32 30 |ect =..E|xport=20|
|00005620| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00005630| 20 20 20 20 52 65 73 75 | 6c 74 73 65 74 2e 20 53 | Resu|ltset. S|
|00005640| 51 4c 79 6f 67 20 61 6c | 6c 6f 77 73 20 79 6f 75 |QLyog al|lows you|
|00005650| 20 65 78 70 6f 72 74 20 | 74 68 65 20 72 65 73 75 | export |the resu|
|00005660| 6c 74 20 73 65 74 20 69 | 6e 20 3d 0d 0a 58 4d 4c |lt set i|n =..XML|
|00005670| 2c 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |,=20.. | |
|00005680| 20 20 20 20 20 20 20 20 | 48 54 4d 4c 2c 20 43 53 | |HTML, CS|
|00005690| 56 20 28 20 66 69 78 65 | 64 20 6c 65 6e 67 74 68 |V ( fixe|d length|
|000056a0| 20 61 6e 64 20 76 61 72 | 69 61 62 6c 65 20 6c 65 | and var|iable le|
|000056b0| 6e 67 74 68 20 29 2e 20 | 3c 41 3d 32 30 0d 0a 20 |ngth ). |<A=20.. |
|000056c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000056d0| 20 3d 0d 0a 68 72 65 66 | 3d 33 44 22 68 74 74 70 | =..href|=3D"http|
|000056e0| 3a 2f 2f 77 77 77 2e 77 | 65 62 79 6f 67 2e 63 6f |://www.w|ebyog.co|
|000056f0| 6d 2f 73 71 6c 79 6f 67 | 2f 73 71 6c 79 6f 67 68 |m/sqlyog|/sqlyogh|
|00005700| 65 6c 70 2f 69 6d 61 67 | 65 33 33 2e 67 69 66 22 |elp/imag|e33.gif"|
|00005710| 3e 63 6c 69 63 6b 3d 32 | 30 0d 0a 20 20 20 20 20 |>click=2|0.. |
|00005720| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 68 65 72 | | her|
|00005730| 65 20 74 6f 20 73 65 65 | 20 61 20 73 63 72 65 65 |e to see| a scree|
|00005740| 6e 73 68 6f 74 20 6f 66 | 20 65 78 70 6f 72 74 20 |nshot of| export |
|00005750| 72 65 73 75 6c 74 73 65 | 74 20 64 69 61 6c 6f 67 |resultse|t dialog|
|00005760| 3d 32 30 0d 0a 62 6f 78 | 3c 2f 41 3e 3c 2f 50 3e |=20..box|</A></P>|
|00005770| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00005780| 20 20 20 20 3c 50 20 63 | 6c 61 73 73 3d 33 44 74 | <P c|lass=3Dt|
|00005790| 65 78 74 20 61 6c 69 67 | 6e 3d 33 44 6c 65 66 74 |ext alig|n=3Dleft|
|000057a0| 3e 3c 53 50 41 4e 20 63 | 6c 61 73 73 3d 33 44 71 |><SPAN c|lass=3Dq|
|000057b0| 75 65 73 74 69 6f 6e 3e | 51 2e 20 3d 0d 0a 43 61 |uestion>|Q. =..Ca|
|000057c0| 6e 20 49 20 65 78 70 6f | 72 74 3d 32 30 0d 0a 20 |n I expo|rt=20.. |
|000057d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000057e0| 20 64 61 74 61 20 69 6e | 20 66 69 78 65 64 20 6c | data in| fixed l|
|000057f0| 65 6e 67 74 68 20 66 6f | 72 6d 61 74 20 75 73 69 |ength fo|rmat usi|
|00005800| 6e 67 20 53 51 4c 79 6f | 67 20 3f 3c 2f 53 50 41 |ng SQLyo|g ?</SPA|
|00005810| 4e 3e 3c 2f 50 3e 0d 0a | 20 20 20 20 20 20 20 20 |N></P>..| |
|00005820| 20 20 20 20 20 20 20 20 | 20 20 3c 50 20 63 6c 61 | | <P cla|
|00005830| 73 73 3d 33 44 74 65 78 | 74 20 61 6c 69 67 6e 3d |ss=3Dtex|t align=|
|00005840| 33 44 6c 65 66 74 3e 41 | 2e 20 59 65 73 21 20 41 |3Dleft>A|. Yes! A|
|00005850| 70 61 72 74 20 66 72 6f | 6d 20 74 68 65 20 3d 0d |part fro|m the =.|
|00005860| 0a 75 73 75 61 6c 20 76 | 61 72 69 61 62 6c 65 3d |.usual v|ariable=|
|00005870| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00005880| 20 20 20 20 20 20 6c 65 | 6e 67 74 68 20 66 6f 72 | le|ngth for|
|00005890| 6d 61 74 20 53 51 4c 79 | 6f 67 20 63 61 6e 20 65 |mat SQLy|og can e|
|000058a0| 78 70 6f 72 74 2f 69 6d | 70 6f 72 74 20 66 69 78 |xport/im|port fix|
|000058b0| 65 64 20 77 69 64 74 68 | 20 3d 0d 0a 66 6f 72 6d |ed width| =..form|
|000058c0| 61 74 3d 32 30 0d 0a 20 | 20 20 20 20 20 20 20 20 |at=20.. | |
|000058d0| 20 20 20 20 20 20 20 20 | 20 64 61 74 61 2e 20 53 | | data. S|
|000058e0| 65 6c 65 63 74 20 74 68 | 65 20 74 61 62 6c 65 20 |elect th|e table |
|000058f0| 69 6e 20 74 68 65 20 4f | 62 6a 65 63 74 20 42 72 |in the O|bject Br|
|00005900| 6f 77 73 65 72 20 66 6f | 72 20 77 68 69 63 68 20 |owser fo|r which |
|00005910| 3d 0d 0a 79 6f 75 3d 32 | 30 0d 0a 20 20 20 20 20 |=..you=2|0.. |
|00005920| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 77 61 6e | | wan|
|00005930| 74 20 74 6f 20 65 78 70 | 6f 72 74 20 74 68 65 20 |t to exp|ort the |
|00005940| 64 61 74 61 20 61 6e 64 | 20 73 65 6c 65 63 74 20 |data and| select |
|00005950| 54 61 62 6c 65 20 2d 26 | 67 74 3b 20 45 78 70 6f |Table -&|gt; Expo|
|00005960| 72 74 20 3d 0d 0a 54 61 | 62 6c 65 3d 32 30 0d 0a |rt =..Ta|ble=20..|
|00005970| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005980| 20 20 44 61 74 61 20 41 | 73 20 43 53 56 20 28 20 | Data A|s CSV ( |
|00005990| 43 74 72 6c 2b 41 6c 74 | 2b 43 20 29 2e 20 53 65 |Ctrl+Alt|+C ). Se|
|000059a0| 6c 65 63 74 20 46 69 78 | 65 64 20 4c 65 6e 67 74 |lect Fix|ed Lengt|
|000059b0| 68 20 69 6e 20 74 68 65 | 20 3d 0d 0a 0d 0a 20 20 |h in the| =.... |
|000059c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000059d0| 65 73 63 61 70 69 6e 67 | 20 63 68 61 72 61 63 74 |escaping| charact|
|000059e0| 65 72 73 20 64 69 61 6c | 6f 67 20 62 6f 78 20 28 |ers dial|og box (|
|000059f0| 79 6f 75 20 67 65 74 20 | 74 68 69 73 20 62 79 20 |you get |this by |
|00005a00| 3d 0d 0a 70 72 65 73 73 | 69 6e 67 20 74 68 65 3d |=..press|ing the=|
|00005a10| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00005a20| 20 20 20 20 20 20 43 68 | 61 6e 67 65 2e 2e 2e 20 | Ch|ange... |
|00005a30| 62 75 74 74 6f 6e 29 2e | 20 3c 41 3d 32 30 0d 0a |button).| <A=20..|
|00005a40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005a50| 20 20 3d 0d 0a 68 72 65 | 66 3d 33 44 22 68 74 74 | =..hre|f=3D"htt|
|00005a60| 70 3a 2f 2f 77 77 77 2e | 77 65 62 79 6f 67 2e 63 |p://www.|webyog.c|
|00005a70| 6f 6d 2f 73 71 6c 79 6f | 67 2f 73 71 6c 79 6f 67 |om/sqlyo|g/sqlyog|
|00005a80| 68 65 6c 70 2f 69 6d 61 | 67 65 31 37 2e 67 69 66 |help/ima|ge17.gif|
|00005a90| 22 3e 63 6c 69 63 6b 3d | 32 30 0d 0a 20 20 20 20 |">click=|20.. |
|00005aa0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 68 65 | | he|
|00005ab0| 72 65 20 74 6f 20 73 65 | 65 20 61 20 73 63 72 65 |re to se|e a scre|
|00005ac0| 65 6e 73 68 6f 74 20 6f | 66 20 65 78 70 6f 72 74 |enshot o|f export|
|00005ad0| 20 74 61 62 6c 65 20 64 | 61 74 61 20 69 6e 20 3d | table d|ata in =|
|00005ae0| 0d 0a 43 53 56 3c 2f 41 | 3e 3c 2f 50 3e 0d 0a 20 |..CSV</A|></P>.. |
|00005af0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005b00| 20 3c 50 20 63 6c 61 73 | 73 3d 33 44 74 65 78 74 | <P clas|s=3Dtext|
|00005b10| 20 61 6c 69 67 6e 3d 33 | 44 6c 65 66 74 3e 3c 53 | align=3|Dleft><S|
|00005b20| 50 41 4e 20 63 6c 61 73 | 73 3d 33 44 71 75 65 73 |PAN clas|s=3Dques|
|00005b30| 74 69 6f 6e 3e 51 2e 20 | 3d 0d 0a 49 20 77 61 6e |tion>Q. |=..I wan|
|00005b40| 74 20 74 6f 3d 32 30 0d | 0a 20 20 20 20 20 20 20 |t to=20.|. |
|00005b50| 20 20 20 20 20 20 20 20 | 20 20 20 63 72 65 61 74 | | creat|
|00005b60| 65 20 61 20 64 6f 63 75 | 6d 65 6e 74 61 74 69 6f |e a docu|mentatio|
|00005b70| 6e 20 6f 66 20 6d 79 20 | 64 61 74 61 62 61 73 65 |n of my |database|
|00005b80| 20 3f 20 44 6f 65 73 20 | 53 51 4c 79 6f 67 20 3d | ? Does |SQLyog =|
|00005b90| 0d 0a 70 72 6f 76 69 64 | 65 3d 32 30 0d 0a 20 20 |..provid|e=20.. |
|00005ba0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005bb0| 61 6e 79 20 74 6f 6f 6c | 20 66 6f 72 20 63 72 65 |any tool| for cre|
|00005bc0| 61 74 69 6e 67 20 61 20 | 73 63 68 65 6d 61 20 64 |ating a |schema d|
|00005bd0| 6f 63 75 6d 65 6e 74 20 | 3f 3c 2f 53 50 41 4e 3e |ocument |?</SPAN>|
|00005be0| 3c 2f 50 3e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |</P>.. | |
|00005bf0| 20 20 20 20 20 20 20 20 | 3c 50 20 63 6c 61 73 73 | |<P class|
|00005c00| 3d 33 44 74 65 78 74 20 | 61 6c 69 67 6e 3d 33 44 |=3Dtext |align=3D|
|00005c10| 6c 65 66 74 3e 41 2e 20 | 59 65 73 21 20 53 51 4c |left>A. |Yes! SQL|
|00005c20| 79 6f 67 20 61 6c 6c 6f | 77 73 20 79 6f 75 20 3d |yog allo|ws you =|
|00005c30| 0d 0a 74 6f 20 62 75 69 | 6c 64 20 61 3d 32 30 0d |..to bui|ld a=20.|
|00005c40| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00005c50| 20 20 20 70 72 69 6e 74 | 65 72 20 66 72 69 65 6e | print|er frien|
|00005c60| 64 6c 79 20 73 63 68 65 | 6d 61 20 64 6f 63 75 6d |dly sche|ma docum|
|00005c70| 65 6e 74 20 69 6e 20 48 | 54 4d 4c 2e 20 59 6f 75 |ent in H|TML. You|
|00005c80| 20 63 61 6e 20 3d 0d 0a | 65 69 74 68 65 72 3d 32 | can =..|either=2|
|00005c90| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00005ca0| 20 20 20 20 20 73 65 6c | 65 63 74 20 74 68 65 20 | sel|ect the |
|00005cb0| 65 6e 74 69 72 65 20 64 | 61 74 61 62 61 73 65 20 |entire d|atabase |
|00005cc0| 6f 72 20 73 70 65 63 69 | 66 69 63 20 74 61 62 6c |or speci|fic tabl|
|00005cd0| 65 73 2e 20 53 65 6c 65 | 63 74 20 3d 0d 0a 74 68 |es. Sele|ct =..th|
|00005ce0| 65 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |e=20.. | |
|00005cf0| 20 20 20 20 20 20 20 20 | 64 61 74 61 62 61 73 65 | |database|
|00005d00| 20 2d 26 67 74 3b 20 72 | 69 67 68 74 20 63 6c 69 | -> r|ight cli|
|00005d10| 63 6b 20 2d 26 67 74 3b | 20 43 72 65 61 74 65 20 |ck ->| Create |
|00005d20| 53 63 68 65 6d 61 20 46 | 6f 72 20 54 68 65 20 3d |Schema F|or The =|
|00005d30| 0d 0a 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |.... | |
|00005d40| 20 20 20 20 20 20 44 61 | 74 61 62 61 73 65 20 69 | Da|tabase i|
|00005d50| 6e 20 48 54 4d 4c 20 28 | 43 74 72 6c 2b 73 68 69 |n HTML (|Ctrl+shi|
|00005d60| 66 74 2b 53 29 2e 20 3c | 41 3d 32 30 0d 0a 20 20 |ft+S). <|A=20.. |
|00005d70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005d80| 3d 0d 0a 68 72 65 66 3d | 33 44 22 68 74 74 70 3a |=..href=|3D"http:|
|00005d90| 2f 2f 77 77 77 2e 77 65 | 62 79 6f 67 2e 63 6f 6d |//www.we|byog.com|
|00005da0| 2f 73 71 6c 79 6f 67 2f | 73 71 6c 79 6f 67 68 65 |/sqlyog/|sqlyoghe|
|00005db0| 6c 70 2f 69 6d 61 67 65 | 31 35 2e 67 69 66 22 3e |lp/image|15.gif">|
|00005dc0| 63 6c 69 63 6b 3d 32 30 | 0d 0a 20 20 20 20 20 20 |click=20|.. |
|00005dd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 68 65 72 65 | | here|
|00005de0| 20 74 6f 20 73 65 65 20 | 61 20 73 63 72 65 65 6e | to see |a screen|
|00005df0| 73 68 6f 74 20 6f 66 20 | 73 63 68 65 6d 61 20 63 |shot of |schema c|
|00005e00| 72 65 61 74 65 64 20 62 | 79 20 3d 0d 0a 53 51 4c |reated b|y =..SQL|
|00005e10| 79 6f 67 3c 2f 41 3e 3c | 2f 50 3e 0d 0a 20 20 20 |yog</A><|/P>.. |
|00005e20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 3c | | <|
|00005e30| 50 20 63 6c 61 73 73 3d | 33 44 74 65 78 74 20 61 |P class=|3Dtext a|
|00005e40| 6c 69 67 6e 3d 33 44 6c | 65 66 74 3e 3c 53 50 41 |lign=3Dl|eft><SPA|
|00005e50| 4e 20 63 6c 61 73 73 3d | 33 44 71 75 65 73 74 69 |N class=|3Dquesti|
|00005e60| 6f 6e 3e 51 2e 20 3d 0d | 0a 49 20 68 61 76 65 3d |on>Q. =.|.I have=|
|00005e70| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00005e80| 20 20 20 20 20 20 63 72 | 65 61 74 65 64 20 61 20 | cr|eated a |
|00005e90| 74 61 62 6c 65 20 61 6e | 64 20 77 6f 75 6c 64 20 |table an|d would |
|00005ea0| 6c 69 6b 65 20 74 6f 20 | 69 6e 73 65 72 74 20 73 |like to |insert s|
|00005eb0| 61 6d 70 6c 65 20 64 61 | 74 61 3d 32 30 0d 0a 20 |ample da|ta=20.. |
|00005ec0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005ed0| 20 71 75 69 63 6b 6c 79 | 2e 2e 2e 44 6f 20 49 20 | quickly|...Do I |
|00005ee0| 6e 65 65 64 20 74 6f 20 | 77 72 69 74 65 20 69 6e |need to |write in|
|00005ef0| 73 65 72 74 20 73 74 61 | 74 65 6d 65 6e 74 73 20 |sert sta|tements |
|00005f00| 3d 0d 0a 3f 3c 2f 53 50 | 41 4e 3e 3c 2f 50 3e 0d |=..?</SP|AN></P>.|
|00005f10| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00005f20| 20 20 20 3c 50 20 63 6c | 61 73 73 3d 33 44 74 65 | <P cl|ass=3Dte|
|00005f30| 78 74 20 61 6c 69 67 6e | 3d 33 44 6c 65 66 74 3e |xt align|=3Dleft>|
|00005f40| 41 2e 20 4e 6f 21 20 53 | 51 4c 79 6f 67 20 70 72 |A. No! S|QLyog pr|
|00005f50| 6f 76 69 64 65 73 20 3d | 0d 0a 79 6f 75 20 77 69 |ovides =|..you wi|
|00005f60| 74 68 20 61 6e 3d 32 30 | 0d 0a 20 20 20 20 20 20 |th an=20|.. |
|00005f70| 20 20 20 20 20 20 20 20 | 20 20 20 20 45 78 63 65 | | Exce|
|00005f80| 6c 20 6c 69 6b 65 20 47 | 72 69 64 20 74 6f 20 49 |l like G|rid to I|
|00005f90| 6e 73 65 72 74 2f 55 70 | 64 61 74 65 20 64 61 74 |nsert/Up|date dat|
|00005fa0| 61 20 74 68 72 6f 75 67 | 68 20 77 68 69 63 68 20 |a throug|h which |
|00005fb0| 3d 0d 0a 79 6f 75 20 63 | 61 6e 3d 32 30 0d 0a 20 |=..you c|an=20.. |
|00005fc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005fd0| 20 69 6e 73 65 72 74 20 | 64 61 74 61 20 71 75 69 | insert |data qui|
|00005fe0| 63 6b 6c 79 2e 20 4d 6f | 72 65 6f 76 65 72 2c 20 |ckly. Mo|reover, |
|00005ff0| 79 6f 75 20 63 61 6e 20 | 75 73 65 20 74 68 65 20 |you can |use the |
|00006000| 74 6f 6f 6c 20 74 6f 20 | 3d 0d 0a 69 6e 73 65 72 |tool to |=..inser|
|00006010| 74 3d 32 30 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |t=20.. | |
|00006020| 20 20 20 20 20 20 20 20 | 62 6c 6f 62 20 64 61 74 | |blob dat|
|00006030| 61 20 61 6e 64 20 69 74 | 20 67 69 76 65 73 20 79 |a and it| gives y|
|00006040| 6f 75 20 61 20 70 69 63 | 6b 6c 69 73 74 20 66 6f |ou a pic|klist fo|
|00006050| 72 20 45 6e 75 6d 2f 53 | 65 74 20 3d 0d 0a 64 61 |r Enum/S|et =..da|
|00006060| 74 61 74 79 70 65 20 74 | 6f 3d 32 30 0d 0a 20 20 |tatype t|o=20.. |
|00006070| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006080| 73 70 65 65 64 20 75 70 | 20 69 6e 73 65 72 74 69 |speed up| inserti|
|00006090| 6f 6e 2e 3c 2f 50 3e 0d | 0a 20 20 20 20 20 20 20 |on.</P>.|. |
|000060a0| 20 20 20 20 20 20 20 20 | 20 20 20 3c 50 20 63 6c | | <P cl|
|000060b0| 61 73 73 3d 33 44 74 65 | 78 74 20 61 6c 69 67 6e |ass=3Dte|xt align|
|000060c0| 3d 33 44 6c 65 66 74 3e | 3c 53 50 41 4e 20 3d 0d |=3Dleft>|<SPAN =.|
|000060d0| 0a 63 6c 61 73 73 3d 33 | 44 71 75 65 73 74 69 6f |.class=3|Dquestio|
|000060e0| 6e 3e 3c 2f 53 50 41 4e | 3e 3c 53 50 41 4e 3d 32 |n></SPAN|><SPAN=2|
|000060f0| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00006100| 20 20 20 20 20 63 6c 61 | 73 73 3d 33 44 71 75 65 | cla|ss=3Dque|
|00006110| 73 74 69 6f 6e 3e 51 2e | 20 49 20 68 61 76 65 20 |stion>Q.| I have |
|00006120| 67 6f 74 20 61 20 74 61 | 62 6c 65 20 74 68 61 74 |got a ta|ble that|
|00006130| 20 68 61 73 20 62 6c 6f | 62 20 3d 0d 0a 66 69 65 | has blo|b =..fie|
|00006140| 6c 64 73 3d 32 30 0d 0a | 20 20 20 20 20 20 20 20 |lds=20..| |
|00006150| 20 20 20 20 20 20 20 20 | 20 20 63 6f 6e 74 61 69 | | contai|
|00006160| 6e 69 6e 67 20 74 65 78 | 74 2f 69 6d 61 67 65 73 |ning tex|t/images|
|00006170| 2e 2e 2e 43 61 6e 20 49 | 20 76 69 65 77 20 2f 20 |...Can I| view / |
|00006180| 6d 6f 64 69 66 79 20 42 | 4c 4f 42 20 3d 0d 0a 66 |modify B|LOB =..f|
|00006190| 69 65 6c 64 73 3d 32 30 | 0d 0a 20 20 20 20 20 20 |ields=20|.. |
|000061a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 3f 3c 42 52 | | ?<BR|
|000061b0| 3e 3c 2f 53 50 41 4e 3e | 3c 2f 50 3e 0d 0a 20 20 |></SPAN>|</P>.. |
|000061c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000061d0| 3c 50 20 63 6c 61 73 73 | 3d 33 44 74 65 78 74 20 |<P class|=3Dtext |
|000061e0| 61 6c 69 67 6e 3d 33 44 | 6c 65 66 74 3e 41 2e 20 |align=3D|left>A. |
|000061f0| 59 65 73 21 20 53 65 6c | 65 63 74 20 74 68 65 20 |Yes! Sel|ect the |
|00006200| 74 61 62 6c 65 20 3d 0d | 0a 69 6e 20 74 68 65 3d |table =.|.in the=|
|00006210| 32 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |20.. | |
|00006220| 20 20 20 20 20 20 4f 62 | 6a 65 63 74 20 42 72 6f | Ob|ject Bro|
|00006230| 77 73 65 72 20 61 6e 64 | 20 73 65 6c 65 63 74 20 |wser and| select |
|00006240| 54 61 62 6c 65 20 2d 26 | 67 74 3b 20 49 6e 73 65 |Table -&|gt; Inse|
|00006250| 72 74 20 2f 20 55 70 64 | 61 74 65 20 3d 0d 0a 44 |rt / Upd|ate =..D|
|00006260| 61 74 61 20 28 3d 32 30 | 0d 0a 20 20 20 20 20 20 |ata (=20|.. |
|00006270| 20 20 20 20 20 20 20 20 | 20 20 20 20 43 74 72 6c | | Ctrl|
|00006280| 2b 45 6e 74 65 72 20 29 | 2e 20 59 6f 75 20 63 61 |+Enter )|. You ca|
|00006290| 6e 20 69 6e 73 65 72 74 | 2f 65 64 69 74 2f 73 61 |n insert|/edit/sa|
|000062a0| 76 65 20 61 6e 79 20 74 | 79 70 65 20 6f 66 20 3d |ve any t|ype of =|
|000062b0| 0d 0a 42 4c 4f 42 20 64 | 61 74 61 2e 3d 32 30 0d |..BLOB d|ata.=20.|
|000062c0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000062d0| 20 20 20 49 74 20 61 75 | 74 6f 6d 61 74 69 63 61 | It au|tomatica|
|000062e0| 6c 6c 79 20 64 65 74 65 | 63 74 73 20 70 6f 70 75 |lly dete|cts popu|
|000062f0| 6c 61 72 20 69 6d 61 67 | 65 20 66 6f 72 6d 61 74 |lar imag|e format|
|00006300| 73 20 6c 69 6b 65 3d 32 | 30 0d 0a 20 20 20 20 20 |s like=2|0.. |
|00006310| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 4a 50 47 | | JPG|
|00006320| 2f 47 49 46 2f 50 4e 47 | 20 61 6e 64 20 64 69 73 |/GIF/PNG| and dis|
|00006330| 70 6c 61 79 73 20 74 68 | 65 6d 2e 20 4d 6f 72 65 |plays th|em. More|
|00006340| 6f 76 65 72 20 79 6f 75 | 20 63 61 6e 20 73 61 76 |over you| can sav|
|00006350| 65 20 3d 0d 0a 42 4c 4f | 42 20 64 61 74 61 3d 32 |e =..BLO|B data=2|
|00006360| 30 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |0.. | |
|00006370| 20 20 20 20 20 74 6f 20 | 61 20 66 69 6c 65 20 6f | to |a file o|
|00006380| 72 20 69 6d 70 6f 72 74 | 20 63 6f 6e 74 65 6e 74 |r import| content|
|00006390| 73 20 66 72 6f 6d 20 61 | 20 66 69 6c 65 20 74 6f |s from a| file to|
|000063a0| 20 61 20 42 4c 4f 42 20 | 3d 0d 0a 63 6f 6c 75 6d | a BLOB |=..colum|
|000063b0| 6e 2e 20 3c 41 3d 32 30 | 0d 0a 20 20 20 20 20 20 |n. <A=20|.. |
|000063c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 3d 0d 0a 68 | | =..h|
|000063d0| 72 65 66 3d 33 44 22 68 | 74 74 70 3a 2f 2f 77 77 |ref=3D"h|ttp://ww|
|000063e0| 77 2e 77 65 62 79 6f 67 | 2e 63 6f 6d 2f 73 71 6c |w.webyog|.com/sql|
|000063f0| 79 6f 67 2f 73 71 6c 79 | 6f 67 68 65 6c 70 2f 69 |yog/sqly|oghelp/i|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
