Home

Product Menual - SQLGate for SQL Server

1. lt 62 gt http www antwiz com SQLGate for MySQL User Manual If you add or modify SQL in SQL Query Editor symbol will be displayed on the tab MUI MD bn DI Qoo E Ra Net Sl Pje ER EIERE EE suis sQ2 x SELECT FROM SELECT FROM help_category A WHERE help category ID lt 1e _ A WHERE help category ID 5 C 04 LA KA If you modify SQL after saving SQL you can check modified line in gutter SQL Query Editor FOOTMIOCaINOSE Dow WC K_ gt 5pacer1111 5q1 CAEN RIK Tm ST D n QNM eo bonm 1111 59 x fe SELECT FROM SELECT FROM help category A WHERE help category ID 10 _ A WHERE help category ID lt 5 bosam D D Quee b KIK o a a D O MHzeolilcoapA 002 BUS RR Bis 00 2 SELECT FROM help_category A WHERE help category ID 10 A gt 8 SELECT FROM WHERE help category ID lt 5 3 4 5 Sur o Seel S help category id name parent category id 1 1 Geographic 2 2 Polygon properties 3 3 WKT 4 4 Numeric Functions OC Ca S Donn es Pan d ex cution Historique des messages 1 4 LIMITO 1000 OSec Table Auto Completion Table lists are displayed after From Into Update keyword automatically You can create SQL statement faster through this feature If you press shortcut key lt Ctrl H gt table auto completion will be executed wherever Kan
2. 26 R n SOU le e SECRET 26 Run Current SQL Modi sese 27 PXecution Plan Of ig EE 27 A A 28 AUTO UE iaa 28 sS AA o A 28 d A 30 KS 20 KIEREN 20 New el EE 31 eU MIN EE 32 NEW Store Reie e EE 33 I Ai a de E E 24 A E A E A 34 NeW VE 35 A 36 VISITE 37 Database Kai te in Po OEA Pu EE TE 38 View Table Tntormmaton enne nnne nnns en nnn siens inns sierras 40 FOC SSS IG T m c 41 Bi NEM 41 Database EE 42 FE eat sL EE 43 IA A o A E E E T 43 Chek An x 43 o E E aseeonnvach tions catooniuoneioanss 45 Sdn CET 46 EEUN MIT rc OTT Emm 46 WONG 47 AT 47 EXDOFt DA a 50 Mi S 52 e o o A E E 55 WI 59 EI Xnis rae CG IY oea 59 llus mL 59 SH eenegen eeng 59 dr act 59 A 59 FeV IO 59 PRCT NON EE 59 CS ONCEK EE 59 AOL eo BG r T D 60 SOL QUE EDITOR TTT 61 ule c 61 o e A O III A 62 ud e A o e oo SP SO O E A 62 eege 63 Feld Alto CO e SEI ON EEN 64 ode AULO Ome Le EE 64 ucc re TOM ese I m UU m 64 Specify background color of dh EE 65 EEE cmm 67 EXECDEe rees tania pio 69 U
3. q columns_priv commonconfig db domainriskfactoritems m sine Table Operation Message tyr Message Text analysesver Truncate Status Succeeded analysistype Truncate Status Succeeded TRUNCATE TABLE root localhost 1 Select a Database 2 Select tables to truncate at left table list and then move them to right list by clicking IE Add All or L gt Add 3 If you click the OK button command to delete will be executed Tools 3 13 1 Object Reports If you use Object Report Tool you can design and print out various reports by yourself You can handle report writing easily and fast because report can be designed and printed out in template format Object report template files are stored in Report folder in fr3 file format You can select report type at left panel and set printout options at right panel in object report tool Select Tools gt Reports gt Object Reports on the main menu or click the El button Object Reports root localhost tojtak WE A cda ReportFont Segoe UI D Objects G Tables Database mysql 4 see Table Scripts Views Tables 82 View and Columns O ah View Scripts O ahn2 Functions C analyses Function Scripts k C analysesversion Procedures C analysesversiondata Procedure Scripts E analysiscells E analysisstates j C analysistypes C category C columns priv C commonconfig db C domainriskf
4. pos 4 TEST An CATEGORY TEST HRE DION 5 WHERE 6 TEST AHN CATEGORY help category id WESTEABNZREEATION HELP RELATIC 3 When you specify the background color of an object which is not specified background color in the previous editor in other editor the background color will not removed in the previous editor si SQL Query Editor oso S Jr pRn P Oz b Rel ma ira D ien d ieg osDS4 amp gDn suem pos SQLi sQL2 00 TEST Am Kenora Run D gt Oso K o A E L gt E O WM 343 ig D Tl 3 TEST AHN KEYWORD 00 WHERE gt 2 3 4 5 6 7 8 9 10 11 12 13 TEST_AHN_CATEGORY TESTSABNORELATION WHERE ou A WN v TEST AHN CATEGORY help category id TEST AAN RELATION HELP RELATI Q lt 66 gt http www antwiz com 4 9 SQLGate for MySQL User Manual Limit feature Limit feature is for that you inquire quickly by specifying desired portion of data If you assign the start line and number of data it will show you as much as data that you want Work speed is improved because it reduces search time when you search lots of data and you can check desired portion of data quickly without using query 1 This is result when you do not use Limit feature R aan A GHz b E IR BEES a Ga Lad EI E d lt RRG 09 4 8g D denten EJ C sE sm 9 B sQi x a 00 be select from help keyword a mzuwr o z mp 1000 ll Ay E i
5. SQLGate for MySQL User Manual If you select highlight option or select sentence in editor highlights will be selected automatically 15 http www antwiz com SQLGate for MySQL User Manual e Code Template Add Edit or Delete code template select select from select from where dedare begin end cursor ifvend SELECT lt column_list gt FROM lt table_list gt WHE LN r n n 1 select 2 from caret If you press lt Ctrl4J gt in editor template will be displayed e Keyword Template Add Edit or Delete keyword template Keyword ABS ACOS ADDTIME 16 http www antwiz com SQLGate for MySQL User Manual e Auto Completion Set whether to use Auto Completion feature Editor Options x General Font Highlight Code Template Keyword Template Auto Completion Auto Completion Features V Code Auto Completion lt Ctrl J gt d Table Auto Completion lt Ctrl H gt V Keyword Auto Completion Ctrl K Y Reuse SQL lt Ctrl M gt V Field Auto Completion lt gt Y Tables v View Keyword Change Case Auto Completion Normal v Auto Completion for Change Case of Object Name Normal L Delay 0 1Sec 1 5 Sec Code Auto Completion lt Ctrl gt Display contents in code template Keyword Auto Completion lt Ctrl K gt Keyword Auto Completion will be displayed i
6. SQLGate for MySQL User Manual MAX QUERIES PER HOUR Input available Query count to inquire per 1 hour In case of 0 unlimited MAX UPDATES PER HOUR Input available Query count to update per 1 hour In case of 0 unlimited MAX USER CONNECTIONS Input maximum connection count In case of 0 unlimited MAX CONNECTIONS PER HOUR Input concurrent connection count of the user In case of 0 unlimited Select privilege check box to grant privilege 10 Click the View SQL button to check SQL 11 Click the OK button lt 37 gt http www antwiz com SQLGate for MySQL User Manual 3 7 Database Information Checks configuration and status of server which is connecting to MySQL database in Database Information Select Manager Database Information on the main menu Database Information l lt als leas _ Server Variables Server Status Variable pame nn Value buo erster 0 auto_increment_offset 1 autocommit ON automatic_sp_privileges ON back log 50 basedir C Program Files MySQL MySQL Server 5 11 big tables OFF binlog cache size 32768 binlog direct non transactional updates OFF binlog format STATEMENT bulk insert buffer size 8388608 character set dient latini character set connection latini character set database latini character set filesystem binary character set results latin1 d root amp localhost Database Information L LS laas _ Server Va
7. 3 4 3 3 4 4 SQLGate for MySQL User Manual Run Current SQL Executes SQL where cursor is located only in SQL Query Editor Select Query gt Run Current SQL on the main menu or press the EI button lt Ctri F5 gt key or lt Ctrl Enter gt key sad SQL Query Editor root localhost SQL1 Lo amp PR P gt Estos Db Re s EIS 5969 HRC EI LIKE ASSEN eR DUS RND IBI fe sar x E 00 gt select from help category a 2 select from help keyword a 3 select from help relation a 4 gur o da 1000 help category id name parent category id Geographic Polygon properties WKT Numeric Functions Plugins MBR Control flow functic Transactions Account Manageme Point properties Encryption Functior LineString propertie Logical operators Miscellaneous Func Information Functic 0 0 SJ Ov nia QU ina 1 e A A 5 6 E 8 9 10 11 12 13 14 15 DOG CIE Data Select 1 37 LIMIT 0 1000 0 Sec 37 rows selected Execute SQL SELECT FROM help category in the line where cursor is located Run SubQuery block Run subquery in the line where cursor is located in SQL Query Editor Subquery can be executed even it is not in block Font color of subquery in editor is changed automatically Also the Run SubQuery block lt Alt F5 gt button is activated Select Query Run SubQuery block on the main menu
8. Capitalize 3 2 18 Increase Indent Indent one line in editor Shortcut key Tab gt Select Edit Increase Indent on the main menu 3 2 19 Decrease Indent Unindent on line in editor Shortcut key Shift Tab gt Select Edit Decrease Indent on the main menu 3 2 20 Convert SQL Convert texts in editor into Delphi Visual Basic ASP PHP J SP code and copy to clipboard Select a submenu of Edit Convert SQL on the main menu sd Convert SQL gt Delphi Description Schema F4 VB C 8 Editor Options ASP JSP Java Options 3 2 21 Description Schema Open Description Schema window about the keyword where a cursor is located in editor Shortcut key lt F4 gt Select Edit gt Description Schema on the main menu 3 2 22 Editor Options Set options of editor Select Edit gt Editor Options on the main menu e General Set general options 14 http www antwiz com 7 Overwrite Mode V Overwrite Block 7 Auto Indent Mode V Show caret in read only mode Y Backspace Unindents E Copy to clipboard as RTF format E Undo Group 7 Enable Column Selection E Redo Group 7 Hide Selection no focus Y Keep caret in text 7 Dynamic Hide no focus E Double E Fix line dick to select a line 7 Enable text drag n drop height of row E Collapse Empty Line Persistent Block Keep Trailing Blanks Word Break on Right Margin Word Wrap E Pin Co
9. Display NULL value in grid Set background Font color of amp multiple line Set background color when text in grid has carriage return value Only one line of data is displayed in grid so you cannot know how many lines in grid Grid Type Change grid type Standard Flat Ultra Flat Office Grid Style Change grid style You can change grid style manually Query Shortcuts lt 57 gt http www antwiz com You can set specific commands as shortcut keys lt Alt 1 10 gt b MySQL Configuration r SQL Query Editor Alt 1 SHOW COLUMNS FROM amp Var L Convert SOL lt Please input amp Var in case of variables 1 Select from Var K Run P P stop P We N in sl A Sei ae BE STEEN EE TE IKEA AK GIRI USSR BN LG 8 SQLi x 3 00 mmm T Sur S zll a 3 E Field Type Null 2 1 category id smallint 5 unsigned INO 2 name char 64 INO 3 parent category id smallint 5 unsigned YES 4 url char 128 INO eaa o Jo Jovy I4 J x fefe f Message History Select 1 4 O0Sec 4rows selected Above example is execution result of shortcut key which is defined as SELECT FROM amp Var after selecting inputted keyword X SQL SHOW FROM Inputted keyword e SQL Conversion Options Sets format to use at SQL conversion Sets conversion format of e
10. Object Explorer root localhost el lm tea ts v EA view1 Object Comment Column Data Scripts W root amp localhost e ont a z w Column Data Type Default NULL Comment E Gs 1 help category id smallint 5 unsigned NOT NULL ker 4 2 name char 64 NOT NULL e BS 3 parent category id smallint 5 unsigned E brena J 4 ul char 128 NOT NULL unctions Procedures i Event A information schema g test i lt root localhost e Tab Information of View Column You can inquire and print out column information and comment of the selected view Data You can add modify delete and print out data of the selected view Scripts You can inquire creation script by wanting options and save it 12 http www antwiz com e Context menu of View Object Explorer root localhost K ch 2 ven Object Comment g Column LA root amp localhost ea 2 A msd i kens talhep c m3 beet Gadgete 3 rent Triggers ds New View 4 e Functior amp Alter Procedu lt Hs Event 4 information Row Count H test ObjectReports Script Report gt Y Filter Refresh New View The New View window pops up Alter The Alter View window of the selected view pops up Delete Drop the selected view Row Count Show record count of the selected view s data Filter Filter and sort lists by using the Filter window SQLGate fo
11. Select Open Select script of the selected object in new tab New Window Select Open Select script of the selected object in new SQL Query Editor window Drop Script Paste Drop script of the selected table or view to SQL Query Editor Insert Script Paste Insert script of the selected table or view to SQL Query Editor Update Script Paste Update script of the selected table or view to SQL Query Editor Delete Script Paste Delete script of the selected table or view to SQL Query Editor 19 http www antwiz com SQLGate for MySQL User Manual 3 3 2 SQL History SQL Query Editor saves SQLs which executed successfully Check Tools gt Options gt SQL Query Editor Auto Save SQL History to save SQL history Query Editor Options Current SQL Separator i Convert SQL Semicolon Carriage Return n Auto Save SQL History Max Save Count of SOL History Store point of SQL History After Execution 7 Use LIMIT V Show Grid at Startup Display SQL Hint on Tab Auto Save SQL History Option for whether to save When checked SQL will be saved Max Save Count of SQL History Unlimited Save all without limitation Count Save as much as inputted number Store Point of SQL History After Execution Save only succeeded query command Before Execution Save all query commands Select View gt SQL History
12. Select Edit gt Cut on the main menu or press the shortcut key lt Ctrl X gt 3 2 4 Copy Copy selected contents to clipboard Select Edit Copy lt Ctrl C gt on the main menu or press the shortcut key lt Ctrl C gt 3 2 5 Paste Paste contents in clipboard Select Edit Paste lt Ctrl V gt on the main menu or press the shortcut key lt Ctrl P gt 3 2 6 Paste from the code Paste SQL statement by extracting from content of clipboard Select Edit Paste from the code Paste from the code on the main menu or press the shortcut key lt Shift Ctrl C gt X Ex Clipboard select from member X Paste in the code select from member 3 2 7 Select All Select all texts in editor Select Edit Select All lt Ctrl A gt on the main menu or press the shortcut key lt CtrI A gt 3 2 8 Clear All Clear all texts in editor Select Edit gt Clear All on the main menu 3 2 9 Find and Replace 12 http www antwiz com SQLGate for MySQL User Manual Find or Replace contents in editor Select Edit gt Find and Replace gt Find lt Ctrl F gt on the main menu To replace select Edit gt Find and Replace Replace Ctrl R gt on the main menu 3 2 10 Bookmark Add Move or Delete bookmark in editor Select Edit Bookmark on the main menu Select Edit Bookmark on the main menu Toggle Bookmark Add bookmark Goto Bookma
13. host L Host privileges Merged with database pri CHAR 128 N n ENUM 0 gt root 192 168 0 30 e ER Design ToolBar L It is a feature to select object in drag area by dragging mouse on the Canvas Select Move D Move the selected object ER Resize group area Resize Delete x Delete the selected object Panning Hand ET Move working area of Canvas by dragging mouse Zoom Out L Zoom out working area of Canvas Zoom In L Zoom in working area of Canvas Region ol Add the Region object which ties up objects into one group Text Box El Add sentence with simple contents on Canvas lt 78 gt http www antwiz com SQLGate for MySQL User Manual m 1 1 Non Identifying Relationship yi Set the 1 1 Non Identifying Relationship between table objects 1 n Non Identifying Relationship yt Set the 1 n Non Identifying Relationship between table objects n m Non Identifying Relationship yt Set the n m Non Identifying Relationship between table objects Cs SQL 37 1 Inquire creation script of currently designed ERD e Canvas This is working space that you can place ERD objects Table Text Box Region Object on the screen manually You can design ERD in easier way e Select Database Tables of the selected database in select database are displayed on table
14. 0 0 0 21 http www antwiz com E SQL which is saved in SQL history is inputted automatically L ail SQL Query Editor root localhost SQL1 e mE K Run P P swn E Ks Js mysd sl 4 Gal a Gi DE EB D t Id 2 OG i 4 SAA GOV BS BR sQi x 3 00 la select from help category m t N ata secan plan Message eT 0 0 0 SQL Align Options It is option for alignment feature of created SQL Select View gt SQL Align Options on the main menu SQL Align Options Default Align amp Indent Keywords Uppercase y Vi Keyword Right Align Clear Comment Relational Operator Align lt lt gt gt Align Operator V Remove Unnecessary Space li AS Keyword Align String Separator CHEM 7 Indent use tab character Prior to SELECT FROM WHERE Block Indent Width Before Comma S Y After Comma L Y Before And Or Y And Or Indent E After And Subquer Comma E Unchanged Case Keyword T WHEN THEN ELSE AND OR I SELECT s 7 Before Comments dzee SELECT a b c S Prior Space SELECT a b c gt Prior After Space SELECT a b c E Link Feed when Less than Less Right Margin Parenthesis Unchanged BEEN No Space count a z Sp gt Inside Space count a us mg i i count a Prior After Space WHEREa b
15. Close All Close all tabs Add Editor lt Ctri Alt N gt Add a tab Open File lt Ctrl 0 gt Open a file in the current tab Save As Save SQL in the current tab as another name Save lt Ctrl S gt Save SQL in the current tab Print Preview lt Ctrl P gt Preview contents to print in the current tab e Context Menu of SQL QUERY EDITOR If you click the right mouse button in SQL Query Editor following popup window will be shown gt Run SQL F5 E Run SubQuery block Alt F V Run Current SQL Ctrl F5 Ek Run Current SQL amp Modify F6 Js Execution plan of current SQL F7 Es Execution plan Block SQL AIt F7 Shift F4 Row Count F12 L i SQL Align F9 o Undo Redo sq Query Description 3 Paste s Paste from the code Select All Clear All x Delete Del Find and Replace Bookmark 2 Goto line 5 Word Wrap Ctrl G d Show Space Tab Carriage Return EH Toggle Folding Ctrl Shift Ctrl Comment Block C Uncomment Block Convert 8 Increase Indent 8 Decrease Indent Shift Tab d i Convert SQL Description Schema F4 Editor Options 23 L gt Run SQL lt F5 gt Execute SQL in editor Execute SQL of the selected text Run SubQuery block lt AIt F5 gt Execute blocked SQL where cursor is located Run Current SQL lt Ctrl F5 gt Execute only SQL where cursor is located Run Current SQL amp Modify F6 gt Execute SQL and modify Ex
16. HOST 2 REPEAT SERIALIZ H m o S P BD 1 2 3 4 AT SCHEDUL RETURNS STARTS N pata Execution pen Mesage sto oS 1 450 LIMIT 0 1000 0 Sec onomu B o Din Aun Ira 169 VD If you click the button you can see in horizontal grid i SQL Qu pun P gt Qstoo Dd ves Wiima Aaa ibGl BbiG BHS O SBAGO P242 89 ossES 8s 00 select from help category a select from help keyword a zip o Seel E help category id name parent category id help keyword id name Geographic JOIN Polygon properties HOST WKT REPEAT Numeric Functions SERIALIZ Plugins REPLACE MBR AT Control flow functic SCHEDUL Transactions RETURNS Account Manageme Point properties Encryption Functior LineString propertie Logical operators nue nio BIE IS lwolaluia L La G9 Ga Ga Q2 MTM Ga a Go G0 Go CJ CO G K DED GB GONDO AUNG GIS GIB EIS oo uo ula win 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 450 LIMIT 0 1000 0 Sec lt 61 gt http www antwiz com SQLGate for MySQL User Manual 4 2 Run SubQuery block You can find subquery in complex SQL automatically and execute it dun F P so b Fs IN EHS OESCH ERC EK EES soi SQ2 x SELECT FROM SELECT FROM
17. Primary Key check box 5 Select columns to use as primary key at left list of Table Columns and then move them to right list by clicking Add All or gt Add lt 31 gt http www antwiz com SQLGate for MySQL User Manual 6 Click the View SQL button to check SQL 7 Click the OK button UNIQUE Input name of index to create at Name Select Tables to create Unique Key Check at UNIQUE check box de XB DA qp Select columns to use as unique key at left list of Table Columns and then move them to right list by click ing 9 J Add All or gt Add 5 Click the View SQL button to check SQL 6 Click the OK button e FULL TEXT Input name of index to create at Name Select Tables to create Full text index Check at Full text check box e ge p Select columns to use as full text index at left list of Table Columns and then move them to right list by clicking Add All or gt Add 5 Click the View SQL button to check SQL 6 Click the OK button 3 5 4 New View Creates new view on database To create view CREATE VIEW privilege is needed Select Create gt View on the main menu E New View root localhost lS _ General Database mysql Name Algorithm UNDEFINED Definer CURRENT_USER 8 SQL Security DEFINER e f E pp validate SQL View SQL OK Cancel root amp localhost 1 Select a Database 2
18. Visual Basic ASP PHP and J SP code Description Schema F4 gt Show Describe window of keyword where cursor is located Editor Options Open editor options window Run SQL Executes created SQL in SQL Query Editor If several SQLs are executed it is separated with semicolon lt gt In case of non Select statement execution results are displayed in Message History tab stop KN button or press ESC key to cancel execution YA button or F5 key sat SQL Query Editor root localhost SQL1 L le ze K run P P Gan E Ee R i mysd sl A amp Em ae PRI GR Qd bd 32 Q Ex D d D UD A E A E LISS zs BEA 85 gt sai x fe a 00 gt 2 select from help keyword a d select from help relation a 4 4 m S um o 1000 Apply E help category id name parent category id url 1 1 Geographic 0 2 Polygon properties 32 3 3 WKT 32 4 4 Numeric Functions 36 5 5 Plugins 33 6 6 MER 32 7 7 Control flow functic 36 8 8 Transactions 33 9 9 Account Manageme 33 10 10 Point properties 32 11 11 Encryption Functior 36 12 12 LineString propertie 32 13 13 Logical operators 36 14 14 Miscellaneous Func 36 15 15 Information Functic 36 c If you select text in SQL Query Editor only selected text will be executed 24 gt 1c a a 1 Comctaes and Madi 272 f pw ca s 2 Data Execubon pen Bo o o DS Em DL Eee Selec
19. hep keyword id name D JOIN ios 2 REPEAT E wo o DH K a H ra e 1 450 LIMIT 0 1000 You can check total 450 datas 2 Click the Apply button after checking Limit and assigning the start line and display count SQL Query Edit P Run P P Qt b Rs Ws amp Rm m3 a m E 9 4H42 gt 2 09 0 BABDOD 20 AO Aa 4 sQi x 00 be select from help keyword a W Vium o da 2 help_keyword_id name 12 11 COLUMNE 3o 12 COMPLET 14 13 WORK 15 14 DATETIM is wore 16 OPEN 17 INTEGER 18 ESCAPE 19 VALUE de y v Joa N Data 1 20 LIMIT 0 20 You can check 20 datas from the first as result 3 If you click the Next page button it shows you as much as set display count 67 gt http www antwiz com 68 gt si SQL Query Editor SJ TS i prun P lr Gs b R IR mst A RE amm D ipd eH OO ABLA Lc AO AAA squi x 00 PU select from help keyword a my IZIT o k help keyword id You can check 20 datas from the 21th again SQLGate for MySQL User Manual http www antwiz com SQLGate for MySQL User Manual 5 Execute Procedure Helps to execute existing procedure and function 1 Select a procedure or function and the click the Run on the context menu 2 Input parameter of procedure Variable Type Input Output Value b
20. Alexander Hunold AHUNOLD 590 Data Exporting Geet Sheet 6 Check Column Mapping between target table and original source file Data Import Wizard exem Column Mapping Set field mappings to specify the correspondence between fields in the source and 7 Preview data Make sure that mapping between data of original source file and column of target table is done correctly 53 http www antwiz com C x Data Preview Please check your data before importing ag L3 Import Wizard 010 Fl Load when i ua F Skip ss sm TL e Je 8 Select the Import Mode and then click the Execute button CE Summary We ve gathered all the information the wizard needs to import your data Please click the Execute button to begin the import process Import Mode 0 Append Add records to the destination table Import Wizard Update Update record in destination matching with record from source Append Update If record exists in destination update it Otherwise add it Delete Delete records in destination that match records in source 010 Copy Delete all records in destination table replace with source contents Append New Add records only if there is no recored in destination table Add Add record to target table Update Update records in target table X You have to select necessary field in mapping step on update Da
21. GOP a A T soi SQ2 x HD select from help category a select from help keyword a 1 2 p select from help relation a 4 1 1 0 2 353 0 a 469 1 4 228 2 5 445 3 6 3 E 7 420 E 8 87 5 9 87 6 10 405 6 11 95 7 12 87 8 13 184 9 Select 1 990 LIMIT 0 1000 0 Sec 990 rows selected Execution plan of current SQL Executes Execution Plan for created SQL in SQL Query Editor Results will be shown as tree type after executing Explain Plan command which saves execution plan to plan table Plan table must exist to execute Execution Plan Press Query Execution plan of current SQL on the main menu the T button or F7 key Results can be checked at Execution plan tab ei sat SQL Query Editor root localhost SQL1 Les P Run Fl P sp b Be Us mysd sl A Aaa a Bei amp 3 BRA iO Aa BAS AAA S m CE SS b E BOT SQLI x sq2 D 00 SELECT FROM SELECT FROM help category A _ WHERE help category ID lt 10 A WHERE help category ID 5 n mn Y HL id select type table type possiblekeys key keylen ref rows Extra EI o PRIMARY lt derived2 gt ALL 9 Using where E DERIVED A range PRIMARY PRIMARY 2 10 Using where p ata execution pan Messe o Select 1 9 LIMIT 0 1000 D Sec lt 27 gt http www antwiz com 3 4 7 3 4 8 3 4 9 SQLGate for MySQL User Manual
22. NOT NULL arenam 4 analysisStatus int 2 NOT NULL X ita 5 analysisType int 2 NOT NULL 6 userNick varchar 20 d analysistypes 7 userGroupSid lint 11 1 ES category E columns priv E commonconfig L e e d Comment Save E domainriskfactoritems Gel domainriskitems Seil domains Gel domainstates Cl eg file E event FA fine 4 D 4 m p root localhost Tab Information of Tables Column You can inquire create delete and print out column information of the selected table Also you can inquire and modify column comment and table comment Index You can inquire add modify delete print out and rebuild index information of the selected table Triggers You can inquire add modify delete print out enable and disable trigger information of the selected table Data You can inquire add modify delete and print out all data of the selected table Scripts You can inquire DDL by wanting option and save it Properties You can inquire creation option of the selected table and storage information Context menu of Tables Object Explorer root localhost tellis v GI ahni Creation Date object D ae zm amp re PK Colun EH ahn Add T a PK laid 2 anal Jh New Table E anal Me Gel anal ES anal mm Drop Truncate e anal Rename Gel anal Copy fs cate Edit Comment E colui Si comi Row Count c db Object Reports gt 2 d
23. None Click the right mouse button at table object and then select the Change Table Display Options on the context menu to open Change Table Display Options window Reflected in All Tables Reflect changed option value of table display to all tables View Table Logical Name Display with logical name of table 1Column nColumn Select items to display at table object OK Reflect changed option value of table display to table Delete Object Align Refresh Change Table Display Options Reference Table Parent tables Referenced By Child tables Delete Object Delete the selected object Align Align the table to up down left and right horizontal vertical Refresh Refresh the table Reference table Parent table Referrer Child table If there is a constraint on the table the parent or the child table of the selected table will be called automatically lt 80 gt http www antwiz com 8 4 SQLGate for MySQL User Manual Relationship If you select one among 1 1 Non Identifying Relationship Us 1 n Non Identifying Relationship laua yt n m Non Identifying Relationship yt on the ER Design tool after that click original table object and target table object in order logical relationship of tables will be set Change Relationship object If you double click the relationship object the Change Relationship window will pop up Relationship exa Relationship Name Re
24. Security Manager Database Information Es Table Information ES Process Manager Ping Server ES Database Backup y Database Restore E Table Manager 2 You can check table information You can check each table in database 12 13 14 15 MyISAM E format Rows Avg row length Data length 810 Fixed 440 eg file IMyISAM Dynamic 0 event MyISAM Dynamic func MyISAM help_categor MyISAM help_keywor MyISAM help_relation MyISAM help topic MyISAM host MyISAM proc MyISAM procs_priv MyISAM tables priv MyISAM time zone MyISAM tme zone je MyISAM time zone ni IMyISAM time zone tr MyISAM time zone tr MyISAM user IMyISAM a ulololelololalelalolal8lBlulolilo lulu lt 40 gt root 192 168 0 30 http www antwiz com SQLGate for MySQL User Manual 3 9 Process Manager Displays status of session which is connected to MySQL database in Session Browser Also you can kill user session To use Session Browser Process privilege is needed LN Select Manager Process Manager on the main menu or click the H button Process Manager root localhost o mesa Refresh sec 5 2 Auto Refresh _ process Z Group By Command X _ Exclude Sleep Process Command Id User Host db Command Time State
25. c Inside Outside Space E Le j Cont SQLGate for MySQL User Manual Default Set Upper Lower case Clear Comment Remove Blank and Separator of keyword Line break Set location of line to change Align amp Indent Set alignment of Keyword Operator AS Keyword Comment AND OR and so on Comma Set blank before after comma Parenthesis Set blank before after parenthesis Operator Set blank before after operator 22 http www antwiz com 3 4 3 4 1 Query Create SQL SQLGate for MySQL User Manual If you select File gt New gt SQL QUERY EDITOR on the main menu or press the shortcut key lt Ctrl N gt or the sal button SQL Query Editor window will be shown You can use up to 20 if you use tab You can use SQL Query Editor and grid in each tab separately e Context Menu of SQL QUERY EDITOR Tab You can use up to 20 if you use tab You can use SQL Query Editor and grip in each tab separately If you click the right mouse button in tab context menu will be shown P Run SQL1 3 Close Ctrl Alt 4D 3 Close All But This Close All Add Editor Ctrl Alt N SQL1 J Open File Ctrl 0 a Save As Ej Save Ctrl 5 a Print Preview Ctrl P at SQL Query Editor root localhost SQL1 Stop b Ws IG myse b b Bi O MNM we iry a Close lt Ctrl Alt D gt Close the tab Close All But This Close all tables except the current tab
26. created SQL in SQL Query Editor automatically Press Query gt SQL Align on the main menu the i button or F9 key after creating SQL d SELECT help category id name parent category id url FROM help category a d 2 lt 28 gt http www antwiz com SQLGate for MySQL User Manual 3 SELECT help category id parent category id url FROM help category a 29 gt http www antwiz com 3 5 Create 3 5 1 New Database Creates database on the connected MySQL server To create database CREATE privilege is needed Select Create Database on the main menu 3 New Database root localhost mm Name Character Set DEFAULT v Collation DEFAULT v View SQL OK Cancel root amp localhost Input name of database to crate at Name Select a Character Set Select a Collation Click the View SQL button to check SQL Click the OK button ST en Gr qe qe 3 5 2 New Table SQLGate for MySQL User Manual Creates a table on database Three methods Defined Column Defined Query and Object Table are provided Select Create gt Tables on the main menu e General Select a Database Input name of table to create at Name Select a ENGINE Select ROW FORMAT gt ce we de lt 30 gt C3 New Table root localhost oo Jew _ General Table Options Database mysql v Name ENGINE MyISAM B ROW FORMAT DEFAULT e Comment PK Column Name Data Type S
27. for MySQL User Manual Store point of SQL History After Execution Save only succeeded queries Before Execution Save succeeded or failed queries Show Grid at Startup When checked grid will be displayed when executes SQL Query Editor If it is not checked only editor will be shown and grid will be shown after executing query Display SQL Hint on Tab When checked SQL will be shown as hint when mouse over tab Object Explorer Select objects to display in Object Explorer Object Panel Options General MySQL Configuration Bring to front SQL Query Editor Visible Objects Object Explorer ep 4 Tables Query Shortcuts Convert SQL J Views Y Functions 1 Y Procedures J Triggers v Indexes Event lt Apply OK Cancel Bring to front When checked Object Browser will be shown on top Visible Objects Select objects to display on object panel Grid You can change Display Null in grid and grid style Options General SQL Query Editor Font color of multiple ine ERE Object Explorer Grid Grid Type Office Query Shortcuts l Convert SQL Grid Style Edit F y ID First Name Second Name Date E 1 Marlon Brando 1924 03 03 JP Alfred Pacino 1940 12 05 3 Seo Jung Gil 1979 07 26 4 Yang Yong Sung 1980 06 06 5 Frank Darabont 1920 05 15 6 Lan McKellen 2006 10 25 d Ryu SungHo 1981 01 01 10 Apply OK Cancel Display NULL
28. help category A WHERE help category ID lt 10 _ JA WHERE help category ID 5 Cy 04 amp KA Runs subquery in the line where cursor is located in SQL Query Editor Subquery can be executed even it is not in block Font color of sub query in editor is changed automatically Also the Run SubQuery block lt AIt F5 gt button is activated Select Query Run SubQuery block on the main menu or press the IP button or shortcut key AIt F5 gt 4 3 Multi Tab Several tabs can be added in SQL Query Editor so you don t need t open several SQL Query Editor Press shortcut key lt Ctrl AIt N gt or click the MET button on the toolbar b Run 7 P stop b Ee is 2 E fo pabio WMS go 158490 O28 SQLI sQ2 oz SQL4 x E SQL Query Editor root localhost SQL1 e lere K Run P P ser D pes I S Ez DS amp 3 O0 ti 2 99 0 80480 si RUSS RSA 85 IsQi x sq2 D 00 1 select from help category a p select from help keyword a 3 SQL Query Editor root localhost SQL em e P Run D b Oz D Es Ip mysal 4 m E i we D n O uHuH s 00g HBABOSARLAaSQE 00 SELECT FROM LIMIT 0 2 SELECT FROM help_category A e WHERE help category ID 10 category id JA WHERE help category ID lt 5 Jens y m viuwr o zg 1000 E help category id name 2 Polygon properties 32 3 WKT 1 2 3 4 5 5 7 8 9
29. http www antwiz com 3 12 3 Repair Tables This feature is to repair when errors are on table SQLGate for MySQL User Manual This is applied only for that table uses MyISAM or ARCHIVE engine and SELECT and INSERT privileges are needed Select Manager Table Manager Repair Tables on the main menu Table Manager root localhost Database mysql Tables Selected Tables lahni analysesversiondata ahn2 columns priv analyses analysesversion analysiscells analysisstates analysistypes categor commonconfig db domainriskfactoritems domainriskitems e darmsine v y Quick Extended Use Frm Result Table Op Msg type text mysql analysesversiondata repair note The storage engine for the table doe mysgl columns priv repair status OK REPAIR TABLE root localhost 1 Select a Database 2 Select tables to repair at left table list and then move them to right list by clicking Add All or L Add 3 If you click the OK button command to check will be executed lt 45 gt http www antwiz com SQLGate for MySQL User Manual 3 12 4 Optimize Tables If you delete data in table which uses variable length data types VARCHAR VARBINARY BLOB TEXT or update to longer data than previous one previous records are deleted logically and spaces are remained physically In case of update longer data than previous is
30. m File Edit View Query Create Manager Tools Window Help DefaultLayout v 161 x root amp locahost A ef SQL Query Editor G 2 BEIS Gi fo Y Ba Ga an E 00 E Run P P sr E Es Ip Jesg zji 4 ES aa li i GG BiG BHS OO FOBAGOPALA SCEE gt Object Comr SQL1 x E m ta LA root amp localhost E gt l select from help_category a E Tables 82 a hn E Open Description Window F4 f anal Object Scripts lL Paste select from ahni E anal Paste select Fields from ahn1 S anal Add ana EZ anal dis New Table zas Replace select from ahn1 anal 4 Alter Replace select Fields from ahn1 e E anal mm Drop Truncate New Tab select from ahn1 te I Rename New Tab select Fields from ahni 4 m C t category id url Y e New Window select from ahn1 0 L i eian Ke E Edit Comment ibus E cele oai 32 E 32 E dh amp E Row Count DROP Script ZEE PK came Object Reports INSERT Script 33 1 PK i i a Script Report b UPDATE Script 32 fu Export Data DELETE Script 33 Import Data 4 9 Account Manageme 33 Y Filter 10 Point properties 32 x Mueren 00 eem 4 Tm E Select 1 37 LIMIT 0 1000 0 Sec 5 1 52 community Select from s CAP NUM ENG Activation Version Paste Select Paste Select script of the selected object to SQL Query Editor Replace Select Change the Select script of the selected object in SQL Query editor New Tab
31. or press the lb button or lt AIt F5 gt key sad SQL Query Editor root localhost SQL1 lola x E Run P P Oz Dd pea De sE aja m DD O BHSi H Ba SGBOlLALCASQVPF AD AMA sQi x a 00 WHERE help category ID 18 A WHERE help category ID lt 5 SELECT FROM p SELECT FROM help category A 3 4 5 e 00 El m name in 1 Geographic E i D 2 2 Polygon properties 32 3 3 WKT 32 4 4 Numeric Functions 36 5 5 Plugins 33 6 6 MER 32 7 7 Control flow functic EI 8 8 Transactions 33 9 9 Account Manageme 33 1 9 LIMIT 0 1000 0 Sec 9 rows selected X Background color of subquery is changed automatically 26 http www antwiz com 3 4 5 3 4 0 SQLGate for MySQL User Manual Run Current SQL amp Modify You can run created SQL in SQL Query Editor and modify data in grid Run Current SQL amp Modify is available to run for one Select query Primary Key column should be included to select script to run Select Query gt Run Current SQL amp Modify on the main menu or press the dE button or F6 key after creating Select query statement Navigation is displayed at grid of Data tab as modification mode You can insert modify delete by selecting grid e i SQL Query Editor root localhost SQL2 So K Run P P stop b Ee Us 4 Ale a a ESB D kh l 2 ge i 4 amp D 44
32. saved and only position is specified again It optimizes spaces which are deleted logically and fragmented physically to quicken access speed of table and reduce disk usage Select Manager Table Manager Optimize Tables on the main menu C3 Table Manager xm Database mysql Tables Selected Tables ahni analysesversion ahn2 columns priv analyses 31 gt analysesversiondata analysiscells analysisstates analysistypes categor db domainriskfactoritems domainriskitems E domaine Result Table Op Msg type Msg text Imysql analysesversion optimize note Table does not support optimize doing r mysql analysesversion optimize status OK Imysql columns priv optimize status OK I p LLL j dee OPTIMIZE TABLE root amp localhost 1 Select a Database 2 Select tables to optimize at left table list and then move them to right list by clicking IE J Add All or 12 yada 3 If you click the OK button command to optimize will be executed 3 12 5 Truncate Tables Deletes all data in table Select Manager gt Table Manager gt Truncate Tables on the main menu lt 46 gt http www antwiz com 3 13 SQLGate for MySQL User Manual C3 Table Manager root localhost xa Database mysql y Tables Selected Tables lahn1 Y analysesversiondata ahn2 analysistypes analyses analysesversion analysiscells d
33. to see background color will be changed to desired color CG SQL Query Editor Ea BGR r gt Run P P Estop D Es iz mysql sl A S Ei A Bi D PE o e Sa Bg 1 4 4 a SOU Fr soi ez sQu3 x Ea 00 gt A SELECT 2 HELP CATEGORY ID 3 NAME 4 PARENT CATEGORY ID 5 URL 6 TEST AHN KEYWORD HELP KEYWORD ID 7 TEST AHN KEYWORD NAME 8 FROM 5 A 10 TEST AHN KEYWORD 11 WHERE 212 HELP CATEGORY ID TEST AHN KEYWORD HELP KEYWORD ID AND E NAME TEST AHN KEYWORD NAME 2 If you specify background color of the same object in another editor the specified background color of the previous editor will be removed According to the below image you can see that the background color of the EMPLOYEES table in SQL1 editor is removed when the background color of the EMPLOYEES table which is the same object is specified in SQL2 editor even though the background color of the EMPLOYEES table was specified in SQL1 editor lt 65 gt http www antwiz com SQLGate for MySQL User Manual SQL Query Editor Le le TS Ena P b Qstoo b mel Jee Jara D SI wali Be 90 bg ne ALL e EB CO SS zi sQL1 00 TEST AHN KEYWORD nal b Run P gt usto D We Bs leg AA im eH O uios 0 g su04280 2 2Au FROM TEST AHN CATEGORY SQU2 x G 00 ps SELECT TEST AHN CATEGORY ml lt TEST AHN CATEGORY MA 5
34. 0 Select full range join J oin count which is used range search in reference table Select range Join count which used range at first table Select scan Join count which scanned first table Select range check Count of join that there is no key to check key usage after using each row Questions Sent query count from server Slave open temp tables Temporary table count which is opened by current slave thread Slow launch threads Thread count which has more than connected slow launch time Slow queries Query count which takes more than long query time Sort merge passes Merge count which must use sort algorithm Sort range Sorted range count Sort rows Sorted row count Sort scan Executed sort count by table scan Table locks immediate Count which obtained table lock immediately Table locks waited Count which cannot obtain table lock immediately and needs standby Threads cached Count of thread which is in thread cache Threads connected Opened connection count currently Threads created Count of thread which is created to handle connection Threads running Count of thread which is not in sleeping status Uptime Time from server start until now 39 http www antwiz com 3 8 View Table Information SQLGate for MySQL User Manual View Table Information feature which can check table information in database in detail 1 Select Manager Table Information Manager Tools Window F En
35. 3 2 3 EE eeneg 12 3 2 4 9 O m 12 3 2 5 rs TO ora EE E E A E E AREAS 12 3 2 6 Bei ube 6 O E ME ME e 12 3 2 7 esa T M O KOCOCOKd qCGe mm 12 3 2 8 mp 12 3 2 9 o e o O A NEE E E T A EE E 12 3 2 10 1010 4007 i NR TORRENT 13 SG K LE TE 12 3 2 12 A J 13 3 2 13 Show Space Tab Calma de OPEP E 13 3 2 14 A E 13 3 2 15 Comment BIOCk EES 13 3 2 16 Uncomment BOCK T 13 3 2 17 CONV O EE 14 3 2 18 ae a se E EE 14 3 2 19 Drea ich I LT 14 3 2 20 A EEN 14 3 2 21 DESCONOCEN C TOES 14 3 2 22 Editor Bodo qi NORTE 14 3 3 VIS EE EE A E A ow 18 3 3 1 o NR s 18 3 3 2 A C 20 3 3 3 A TON r E E 22 lt 2 gt http www antwiz com EE Sek LES Ep E SS Rom Een nn U ULU L Fb bb EEE EE D E Qn U1 n Ui Ui PPP E P QU QJ QJ UU UJ NJ NJ RM NJ NJ NJ G CD nal as a T o um PRRPRRERRR e WWWWW WW WWW W UW UW UW UW WU UW UW UJ QJ CJ GJ CJ W KO CJ CJ CU KO CJ GJ KO QJ K CU KO QJ K KO QJ CJ KO KO GJ KO CJ Q0 o0U BRUNO SE SE Ee SQLGate for MySQL User Manual Sli 23 EE X PR 23 ROR UE 24 A T
36. Database Backup Whether to back up database Backup Users Whether to back up users Backup Routines Whether to back up routines Back up Tables Whether to back up tables Backup Views Whether to back up views Back up Triggers Whether to back up triggers Backup Data Whether to back up data Add locks Whether to add LOCK Complete insert Whether to add field list of table to INSERT statement Extended insert Whether to add Extended statement Disable keys Whether to add DESABLE Delayed insert Whether to add DELAYED Insert Type INSERT Create only INSERT statement INSERT IGNORE Ignore insertion of data which is violated to PRIMARY and UNIQUE REPLACE INTO If it is violated to PRIMARY and UNIQUE update data Select Table Database Backup Database mysql v Backup File Option Select Table Backup Log Tables Selected Tables analysesversiondata y EEEE analyses analysiscells ahn2 analysisstates y ahni lt analysistypes category columns priv commonconfig db domainriskfactoritems domainriskitems domains domainstates help relation Y Backup Cancel root amp localhost Select tables to back up at left table list and then move them to right list by clicking Add All or gt J Add Select a Database Input path to back up and file name at Backup File Select necessary options at Options tab If you want to back up data select table
37. ERNAL NAME f getStrCount 10 EXTERNAL LANGUAGE K 3 userage 11 PARAMETER STYLE SQL pij Procedures 12 IS DETERMINISTIC NO Y Y Event 4 13 SQL DATA ACCESS CONTAINS SQL A information schema 14 SQL PATH A test 15 SECURITY TYPE DEFINER 16 CREATED 2010 11 05 2S 2 25 56 17 LAST ALTERED 2010 11 05 amp 2 25 56 18 SQL MODE STRICT TRANS TABLES NO AUTO CREATE USER MO ENGINE SUBSTITUTION 19 ROUTINE COMMENT 20 DEFINER root amp localhost 21 CHARACTER SET CLIENT utf8 E 4 nm b 4 n p root localhost e Tab Information of Procedure Function Properties Display information of the selected procedure function Scripts Display creation script of the selected procedure function lt 4 gt http www antwiz com e Context menu of Procedure Function lt 75 gt Object W root localhost amp mysql informatic test Object Explorer root localhost bell Le Comment Fo Functions 6 el New Function At amp Alter fu ma Drop ge b ud n Execute Script Report Object Filter Filter Refresh AHN _ Properties Name 1 SPECIFIC 2 ROUTINE 3 ROUTINE 4 ROUTINE 5 ROUTINE om IDE ROUTINE ROUTINE EXTERNAI EXTERNAI JARAMET gt js DETER Io par QL PAT SECURITY TREATED New Function The New Function Stored Procedure window pops up Alter Alter the selected procedure Delete Drop the selected procedure R
38. If you select table at Object Name column you can check information columns and indexes about the table at Ta ble Info tab If you select index at Object Name column you can check columns and property values about the index at Index nfo tab Check View plan object info for above feature Query Description You can preview columns by using Query Description feature before executing a query manually if it is created as subquery type joined query of several tables or took long time to execute Create SQL in SQL Query Editor Select Query gt Query Description on the main menu or press the 1 t button or lt Shif F4 gt keys Column information of SQL will be shown C3 Query Description root localhost Sm B H 1 help category id CHAR 2 name VARCHAR2 64 3 4 parent category id CHAR url VARCHAR2 128 Add to User SQL Saves created SQL in SQL Query Editor to User Directory of SQL History Select Query gt Add to User SQL on the main menu or press the shortcut key lt Shift F8 gt Ad Add to User SQL BE ENE 3 gi Root SQL Name gt User Directory c Dual SELECT FROM WHERE help category ID 10 A 1 2 SELECT FROM help category A 3 4 WHERE help category ID lt d Cancel IQ root localhost If you click the OK button after selecting SQL name and group it will be saved Saved user SQL can be checked in SQL History SQL Align Aligns
39. Info E Query 192 root localhost 59035 mysql Query 0 T SHOW FULLPROCESSLIST Sleep 194 root localhost 59037 mysql Sleep 104 196 root localhost 59039 mysql Sleep 103 _ Current SQL 1 SHOW FULL PROCESSLIST 4 n Count 3 root amp localhost Refreshed at 2010 12 07 11 02 48 AM e Process You can see process list of user who is connecting to current database at process tab You can monitor information such as Id User Host db Command Time State Information of process and so on You can inquire current SQL information of the selected process at bottom tab 3 10 Database Backup Backs up user table procedure function view trigger and data which are contained in database by using self backup feature without provided tool by database Select Manager Database Backup on the main menu Database Backup root localhost Database mysal Backup File Generate Header V Add drop table Database Backup Backup Users Backup Routines v Back up Tables Y Backup Views Back up Triggers V Backup Data v Add ocks Complete insert 4 Extended insert Disable keys Delayed insert Insert Type INSERT y root amp localhost e Database Backup Generate Header Whether to display header Add drop table Whether to add Drop statement before object creation statement lt 41 gt http www antwiz com 3 11 SQLGate for MySQL User Manual
40. Input name of view at Name 32 http www antwiz com SQLGate for MySQL User Manual Select an Algorithm Select a Definer Select a SQL Security Input SQL to use as view in Editor window Click the Validate SQL button to check that SQL is correct Click the View SQL button to check SQL Click the OK button B9 Pe d Ge ew OM 3 5 5 New Stored Procedure You can create Function and Procedure easily Select Create Procedure on the main menu 1 Input name of object to create parameter and return type on New Function Stored Procedure window C3 New Function Stored Procedure root localhost mcm Object PROCEDURE D Function Procedure Name Parameter Name in type Name in type View SQL g d m root amp localhost 2 Click the OK button 3 Creation statement is added to SQL Query Editor sal SQL Query Editor root localhost SQL1 gt Run FP Stop D Ks IG mysql E E Pa amp 3 O BHS OG i 4S G 9 D ou SQLi x EI 3 CREATE PROCEDURE mysql Name in type Name in type 2 BEGIN 3 4 5 END lt 33 gt http www antwiz com SQLGate for MySQL User Manual 3 5 6 New Function You can create Function and Procedure easily Select Create Function on the main menu 1 Input name of object to create parameter and return type on New Function Stored Procedure window New Funct
41. P P Oz b pea ls ms A a3 ER 04H OO ARATA A or x a ki SELECT FROM H Table help keyword Table help relation Table help topic Table host Table Auto Completion 63 http www antwiz com SQLGate for MySQL User Manual 4 5 Field Auto Completion If you input dot lt gt in SQL Query Editor alias or field of table will be displayed sat SQL Query Editor K Run P b stop E Es Is mysa sl A E Boa 3 D lh l 2 OO 3G z squi x EI gt SELECT FROM help category A 2 WHERE A help_category_id smallint 5 unsigned name char 64 parent category id smallint 5 unsigned url char 128 mysgl help category Field Auto Completion 4 6 Code Auto Completion Code Auto Completion is a useful feature that you save often using code in advance and call them whenever you need If you press shortcut key lt Ctrl gt code auto completion will be executed If you input Selectw in SQL Query Editor and then press Ctrl4J keys it will be converted into select from where code 1 SELECTW 2 3 select from where 4 7 Paste from the code This is a feature to extract only SQL in development code For example it can extract SQL statement only in PHP code that includes SQL code headcolor FF6699 code footcolor FFDDE8 code bgcolor f9fafb btn type board select user_nm passwd email p from faq whe
42. PS EDO EE 71 lt 3 gt http www antwiz com b adn m O tO O000000 00000000000 o NI O O 00 OY Ur E UU HM L Im SQLGate for MySQL User Manual LE o 71 A e o SO O E E E E 72 THT o II E vests 73 q O PP 74 Quen BUS asiatica aoeiian 76 o o A oo o N ee S 78 nn E 80 Essere m c 80 PRS FON SIU 81 Change gelen O zo 81 LOU EE 82 j i5 E X O 82 SUID 82 Nele LRT He A 83 RA Nr DC eee T P 83 A e o a RR ES e E 84 lo PAP a E A 84 lt 4 gt http www antwiz com 1 1 1 1 2 SQLGate for MySQL Introduction Introduction SQLGate for MySQL User Manual SQLGate for MySQL is a database management tool which helps you with an easy development and management for MySQL database applications It shortens development time and increases business efficiency of database manager and application developer by providing user friendly interface and various features If you use features such as SQL Tuning feature and Query Builder you can create and execute SQL easily Moreover you can work by connecting to server conveniently without installing MySQL client lb vle Comr Object W root
43. SQLGate for MySQL User Manual MySQL Database Development amp Management Tool SQLGate for MySQL User Manual 2011 Antwiz Inc All rights reserved Contents of this manual and SQLGate for MySQL program are protected by copyright law and the protection act of computer program m Technical Support Customer Support http www antwiz com supportO antwiz com els http www antwiz com SQLGate for MySQL User Manual SQLGate for MySQL Table of Contents 1 SOLGate Tor MYSQL INTO CTO rra cito 5 1 1 Mic o Pra 5 1 2 T I D ood ae 5 2 Produa deen az el 6 2 1 D SST e die Te MNT DOO 6 2 2 EE EEO TTE 7 3 CA 8 3 1 mls 8 Ep VIER 8 3 1 2 New UI Ne 8 3 1 3 DISCO EE 9 fo alley DT T 9 3 1 5 TTT PRRTCP M 10 3 1 6 VAS FSS WV OU e EE 10 3 1 7 GI 10 3 1 8 Recent E 10 3 1 9 Nae teers eet TIK E E 10 3 1 10 SVS EE 10 3 1 11 SICH COON TTT 10 3 1 12 A E E E N 11 3 1 13 Close VM use esistenti ssim M M M 11 3 1 14 A a aa dea aE aa aaan aaae iaat 11 3 1 15 PRC Rd OW RN EE EE 11 3 1 16 PIE 11 3 1 17 li N T 11 3 1 18 D 11 3 2 FPO Coen nee 5 e OI One ee ec ee Se 12 3 2 1 RT MO ge Sess T 12 3 2 2 KE lT 12
44. TABLE INFORMATION pem LS Jee Bes TABLE NAME help_category aen fae mees ewe e nem omm In ee petens IEC LL De e pep 1 kee esoe NN RN RN I ION IN CON RN RN 1 Select a report at left tree 2 Click the Preview button 49 gt http www antwiz com SQLGate for MySQL User Manual 3 13 2 Export Data You can export data in table by using Export Data in various formats such as DBF Text CSV File MS Excel MS Access SQL file and so on Select Tools Export Data on the main menu or click the fan button 1 Select table to export then click the Start button 20 Export Data root localhost 010 Export Data o m E root localhost C information schema E B mysql A ahni E ahn2 C analyses E analysesversion CE analysesversiondata E analysiscells CX analysisstates C analysistypes E category Ci columns priv C commonconfig E db Select Table Name mysql ahn1 mysql ahn2 mysql analyses mysql analysesversion mysql analysesversiondata mysql 2 E er Export Directory Gm Count 83 root amp localhost 2 Set File Type Data Export Wizard FS File Type A What kind of format you would like to export 010 Table Type 0 DBase File dbf IA Text File txt csv Excel File xls SQL Script File sql 010 MS Access File mdb 3 Set a file to export Data Export Wiza
45. actoritems C domainriskitems gt Vf Export File lt Design Preview Print Cancel root amp localhost Select a type of report to print out at left tree Select a schema and object to print out at right panel Select font to print out at the Report Font e n gen we If you click the Design button you can design reports 47 gt http www antwiz com SQLGate for MySQL User Manual 5 If you click the Preview button you can it in advance 6 If you click the Print button report will be printed out 7 f you click the Export File button you can select format to print out reports X PDF EXCEL RTF BMP J PG TEXT EMAIL HTML 48 gt http www antwiz com SQLGate for MySQL User Manual e Design Report ings a d PREOS 3 sa eara JE K Code pata Pager 4 ObjectIns 3 ReportTree 3 Q Pagei TfxRe v A T Pro Eve BackPictu BackPictureV ga j TABLE INFORMATION TABLE NAME TableInfo Name as anen Datatype Key Nou oa Columns Field Columns Type Eco xam Columns Default Columns 1 Select a report at left tree 2 Click the Design button 3 You can edit design to other formats that you want to print out 4 Select the File Save buttons after editing e Preview GUA AAA mm QEU ma DATABASE ma CREATED 11 5 2010 5 31 27 PM
46. amp localhost bi mysql Tables 82 Views Triggers Event A information schema d test url char 128 5 1 52 community Technical Support PK bein category id smallint 5 unsigne name char 64 parent category id smallint 5 unsigne 356 SQLGate2010 for MySQL Developer SQL Query Editor root localhost SQL1 File Edit View Query Create Manager Tools Window Help Default Layout v iroot localhostsss W Wa af SQL Query Editor FA lt EA fy Y a Ga ap Run F b Estop D Ps s mysal sQi x 4 S Em ae amp 2 amp Ri D AA OO La gg D 7449 LeS ks 18 x UU E d select from help category a 2 SQL Query Editor 4 m o mimt o 1000 1 Apply a help_category_id name parent_category_id url 1 1 Geographic 0 2 2 Polygon properties 32 a 3 WKT 32 es ataca 5 5 Plugins 6 6 MBR 32 T 7 Control flow functic 36 8 8 Transactions 33 9 9 Account Manageme 33 10 10 Point properties 32 DX mla Je Data Execution plan Select 1 37 LIMIT 0 1000 0 Sec CAP NUM ENG Trial period will be expired in 1 day s If you have any questions about this software refer to this document or post questions on the Technical Forum in company s homepage http www sqlgate com en support Technical Support 482 2 338 1876 lt 5 gt http www antwiz com 2 1 SQLGate for MySQL User Manual Product Specification Major Spec
47. anual Host IP address of the server which operates MySQL server SSH Tunnelling Select when access by using SSH service User Connection account Password Password Save Password Select whether to save password Port Port number of MySQL server Database Database name to connect to MySQL server Character Set Character set of client Date Format Date type format Color Select color by session when you connect to several MySQLs Test Connection Execute connection test to inputted information Authentication Kind Select SSH access authentication method Password Authentication with password on SSH login Public key Authentication with key file on SSH login SSH Server IP Address IP address of the server which operates SSH server SSH Port Port number of SSH server User Connection account Password Password MySQL Connection Access method to MySQL server by using SSH service Connect SSH Directly Access to MySQL server directly through SSH service Local Port Forwarding Access to MySQL by forwarding port to local PC Listen Port Input port number when forwards local port Disconnects to currently connected MySQL server Select File Disconnect on the main menu File Edit View Query Creat New L New Connection LA Disconnect Disconnect All L Disconnects to currently all connected MySQL servers Select File gt Disconnect All on the main menu File Edit Vie
48. at Selected Tables tab E se Pe NE Click the Backup button to execute database backup Database Restore Restores database with backup file which is backed up by database backup Select Manager gt Database Restore on the main menu lt 42 gt http www antwiz com SQLGate for MySQL User Manual Y Database Restore root localhost Ex Database mysql Y Restore SQL File logs Restore Close root localhost 1 Select backed up file SQL on Open Restore SQL file window 2 The execution script of the selected file is added to SQL Query Editor 3 Click the Restore button 3 12 Table Manager 3 12 1 Analyzer Tables Updates status after analyzing key districution of table Table is locked during analysis read lock This feature is applied only for that table uses MyISAM BDB or InnoDB engine Select Manager gt Table Manager gt Analyzer Tables on the main menu Table Manager root localhost E Database mysql v Tables Selected Tables ahni analyses ahn2 analysisstates analysesversion gt columns priv analysesversiondata domainriskfactoritems analysiscells analysistypes category commonconfig domains domainstates len Bla Result Table Op Msg type Msg text imysq analyses analyze status OK mysql analysisstates analyze status OK mysql columns_priv analyze status Table is already up to da
49. ate for MySQL User Manual e Context menu of Triggers e Object Explorer root localhost IJ v amp TRG TriggerTe j C _ Properties a root amp localhost Name amp mysql 1 TRIGGER A information schema 2 TRIGGER zd test 3 TRIGGER Tables 4 EVENT M Views 5 EVENT OI Triggers 2 9 EVENT OI trigger 7 EVENT OI ACTION Functions P New Trigger ACTION Procedure 4 Alter ACTION Y Event Drop 1 ACTION ObjectReports P CTION ACTION 1 WP Filter ACTION 1 Refresh ACTION ACTION 1 New Trigger The New Trigger window pops up Alter The Alter Trigger window of the selected trigger pops up Delete Drop the selected trigger Filter Filter and sort lists by using the Filter window 6 4 Procedure Function Inquires procedure function list of the selected owner and detail information and performs overall features about procedure such as creation modification deletion and so on Object Explorer root localhost fs gon ha ls x T gt userage Object Comment Properties Scripts a root localhost Name Value z amp mysql 1 SPECIFIC NAME userage r3 Tables 2 ROUTINE CATALOG Y 18 Views 1 3 ROUTINE SCHEMA mysql e Triggers 0 4 ROUTINE NAME userage f Functions 6 5 ROUTINE TYPE FUNCTION f AHN 6 DTD IDENTIFIER int 11 C lt AHN1 7 ROUTINE BODY SQL AN2 8 ROUTINE DEFINITION BEGIN funci 9 EXT
50. came Select Edit gt Find and Replace gt Find on the main menu or press the shortcut key Ctrl F gt to open the Find Table window Input a word to search among table names at the Keyword If you click the OK the Find Table window is closed and it finds out that table by moving working area of Canvas after finding table object which has keyword Press the F3 key to find next table 83 http www antwiz com d 9 1 Trivia Table of shortcut keys Common Search SQL History Edit Query Editor New Open Save Save As Undo Redo Find Find Next Replace Paste from the code SQL History Delete SQL Append to editor Comment Block Uncomment Block Upper Case Lower Case Run SQL Compile Stop Close Add Editor Previous Editor Next Editor Open File Save Print Preview Show Grid Run Current SQL mew eme Shift Ctrl Ctrl L Ctrl Alt D F11 SQLGate for MySQL User Manual Description Schema eus Ctrl X Ctrl C Ctrl V Ctrl A Del Shift Ctrl E Ctrl Alt Num Ctrl Num Ctrl G Ctrl C Ctrl 0 Ctrl 1 Tab Shift Tab F4 Alt F5 F6 F7 Alt F7 Shift F4 Shift F8 F9 Ctrl H Shift Ctrl V F12 Option Help 84 gt Code Auto Completion Templ ate Keyword Auto Completion Reuse SQL Ctrl M Ctrl K Field Auto Completion l http www antwiz com
51. ct a user who you want to inquire privilege in user list at left Inquire Privilege Object privileges of the user who is selected in user list window in database display at right grid Modify Privilege If you check at checkbox which is relevant to privilege of the object on right grid privilege is granted If you uncheck it privilege is revoked Only types of selected object at Tables View Procedure and Function checkbox display on right grid 36 http www antwiz com 3 6 1 New User Creates new user on database To create user CREATE USER privilege is needed Select Security Manager New User button on the main menu New User CS User Name Host Password Confirm Password MAX QUERIES PER HOUR RIE wF MAX UPDATES PER HOUR MAX USER CONNECTIONS wF 0 0 0 0 d MAX CONNECTIONS PER HOUR tor SEO do m 14 a e d pe v All privileges Y Grant Option Y SELECT Y REFERENCES Y CREATE VIEW Y INSERT Y INDEX Y SHOW VIEW v UPDATE V ALERT Y CREATE ROUTINE V DELETE J SHOW DATABASES V ALTER ROUTINE J CREATE V SUPER V CREATE USER V DROP J CREATE TEMPORARY TABLES V EVENT J RELOAD Y LOCK TABLES V TRIGGER V SHUTDOWN V EXECUTE V PROCESS V REPLICATION SLAVE Y FILE Y REPLICATION CLIENT View SQL OK Cancel root amp localhost Input User Name Input Host Input Password Input the inputted password at Confirm Password again
52. date datetime IN DELIMITER SET bdate SELECT mysql userage bdate 77 3 Click the OK button 4 Execution script will be added to SQL Query Editor ATT en Er im amp ixe pc uHus Og satin AAA soi x i 00 h DELIMITER 3 SET ibdate SELECT mysql userage ibdate wala J D m1 a b Dx llar a 5 pian Message History 5 Click the Run button to execute function or procedure and check results lt 69 gt http www antwiz com SQLGate for MySQL User Manual D n O WMMSeoAoD4A BD 00 E aw P gt Qso b Ee elma zl ag A ml DELIMITER 2 3 SET ibdate SELECT mysql userage bdate E Laa Siwe em E mysql userage bdate 1 lt 0 gt http www antwiz com 6 6 1 Object Explorer Table SQLGate for MySQL User Manual It provides overall features about tables that inquires creates modifies and deletes table lists by owner and detail information of each table Select View Object Explorer on the main menu or click the EI button on the toolbar Object Explorer root localhost J les bell v analyses Creation Date 2010 11 18 AM 10 00 59 Object t Column Index 7 Tables 82 2 b E Ed der pK Column DataType Default NULL Comment 1 PK seq int 11 NOT NULL 2 userSeq int 11 NOT NULL Mime 3 domainseq int 11
53. e data import process has completed successfully e Mm Added D Error 0 Update 0 Processed 109 Delete 0 Skipped 0 Error log will be shown if error is occurred 3 13 4 Options Sets options of program Select Tools gt Options on the main menu or click the EI button e General Options CS General gU MySQL Configuration be SQL Query Editor Dream Object Explorer Grid l Query Shortcuts Automatic Updates Convert SQL V Enable Automatic Updates 4 Select Language Engish i Start Window Y SQL Query Editor Object Explorer Apply OK Cancel Themes Select theme of program Default and Dream are provided Automatic Updates Enable A amp utomatic Updates When checked it checks update automatically whenever program executes Select Language Select a language to use at program Korean English Japanese Chinese German French and Spanish are provided Start Window SQL QUERY EDITOR Executes SQL Query Editor automatically when starts program Default is SQL Query Editor Object Explorer Executes Object Explorer automatically when starts program e MySQL Configuration 55 http www antwiz com SQLGate for MySQL User Manual Options MM General MySQL Configuration Query Options SQL Query Editor Date F D Object Explorer Grid yyyy MM dd AMPM h mm ss Query Shortcuts Convert SQL Keep Connection Fetch R
54. e main menu or click the sh button New Connection Ka Select File New Connection on the main menu or click the x button C3 New Connection Pa Se Hd Database Login SQLGate2010 for MySQL Developer _ Login s Favorite Alias User Host Database Port st Conneci Co Heat 1 root localhost root localhost mysql 3306 2010 12 02 localhost 2 root amp 192 168 0 30 root 192 168 0 mysq SSH Tunnelling User root 3306 2010 11 24 wl Save Password Port 3306 Database mysql Character Set latin 1 cp 1252 West European N Date Format DEFAULT Color eg Test Connect View Favorities Only Show Password FTIIT IEEE Server Information root amp localhost 3306 mysql e Login 8 http www antwiz com gt Ee K A Lean Host 192 168 0 30 SSH Tunnelling User root Password wl Save Password Port 3306 Database mysql Character Set latini cp1252 West European Date Format DEFAULT Color Test Connection e SSH agr zl SSH Connection Authentication Kind O Password O Public key SSH Server IP Address www sshserver com SSH Port 22 User root Password LU bd l MySQL Connection 9 Connect SSH Directly Local Port Forwarding SSH Connection Disconnect d SQLGate for MySQL User M
55. eck Click the OK button lt 35 gt http www antwiz com 3 6 SQLGate for MySQL User Manual Security Manager Security Manager can inquire user and privilege of database and add modify and delete them DBA can manage user and role of MySQL easily by using Security Manager To use Security Manager SUPER privilege is needed Click Manager Security Manager on the main menu e User EG Security Manager root localhost 5 amp m _ B User podes D a e User Host Select Insert Update Delete Create Drop Reload Shutdown Process File Grant Option root localhost y d v d d v v v y d y m E root amp localhost You can inquire information such as User ID Host privilege and so on Tool Button of User Refresh Refresh New User Create new user Modify Modify user information and role Delete Delete the selected user Privilege EG Security Manager root localhost Le ee ZB use re User Host root localhost 4 Table 4 View v Procedure Y Function Object Name Create Select Insert Update Delete Drop Grant A lahni A lahn2 Y Y J J lanalyses J lanalysesversion Y lanalysesversiondata E lanalysiscells J C lanalysisstates lanalysistypes J 3 category d E columns priv y CX commonconfig E db Y i domainriskfactoritems E domainriskitems 7 J domains i domainstates d d Y 4 n L root amp localhost Sele
56. ecords Options Fetch All Records Display all records in grid after inquiry Partially fetch records Fetch partially after inquiry Fetch rows means records count to fetch partially Query Options Date Format Set date type to display in grid Keep Connection When checked keep connection of session continuously Reconnection Check Time Set automatic reconnection time e SQL QUERY EDITOR Editor options alignment options SQL history save options and so on Options Mm General i l MySQL Configuration Query Editor Options SQL Align Options SQL Query Editor Options Options Object Explorer Grid Query Shortcuts Current SQL Separator 9 Semicolon Carriage Return fn V Auto Save SQL History Max Save Count of SQL History Q Unlimited Store point of SQL History lt O After Execution Before Execution v Use LIMIT V4 Show Grid at Startup Display SQL Hint on Tab Apply OK Cancel Query Editor Options Set query editor options If you click the Options button new window will be shown to set SQL Align Options Set SQL alignment options If you click the Options button new window will be shown to set Auto amp Save SQL History Set options whether to save or not If you check this SQL will be saved automatically Unlimited Save all without limitation Count Save only inputted count 56 http www antwiz com SQLGate
57. ecution plan of current SQL lt F7 gt View execution plan of SQL Execution plan Block SQL lt AIt F7 gt View execution plan of blocked SQL where cursor is located Query Description lt Shift F4 gt Field definition by analyzing SQL statement Row Count lt F12 gt Count records where cursor is located at SQL Align F9 gt Align all SQLs in editor Undo lt Ctrl Z gt Cancel execution Redo lt Shift Ctrl Z gt Re execute Cut lt Ctrl X gt Cut off Copy Ctrl4C gt Copy Paste lt Ctrl V gt Paste Paste from the code Extract SQL from other program codes Clear All Clear all Find and Replace Find Find Next Find All Find from first Find the last Bookmark Toggle bookmark Goto line lt Ctrl G gt Move directly to the line by inputting line number Word Wrap WordWrap http www antwiz com 3 4 2 Select Query Run on the main menu or press the Select the SQLGate for MySQL User Manual Show Space Tab Carriage Return Show space tab and carriage return character Toggle Folding Show and symbols Comment Block lt Ctrl gt Set comment Uncomment Block lt Shift Ctrl gt Release comment Convert to Convert to upper lower character Increase Indent Indent the line where cursor is located Decrease Indent Shift Tab gt Unindent line where cursor is located SQL CONVERT Convert into Delphi
58. elect from help category a select from help keyword a select from help relation a http www antwiz com SQLGate for MySQL User Manual You can add folder by selecting New Group on the context menu by clicking right button of the mouse after selecting User Directory in the left tree CES s Hia aH Root gt User Directory gt Dual gt 1503 DML is saved to SQL History group basically and other SQLs are saved to Proc Func History group SQL can move from SQL history list to the other group through drag amp drop If you double click grid the selected SQL transfers to SQL Query Editor You can save or open SQL history through Open File or e SQL Reuse Save File button Check at the Reuse checkbox of User Directory group and SQL histories which are contained in sub groups amp SQL History root localhost lad R SSR R KR 42m Kn RR e cO E EY Root Find What yo f SQL History DET Reuse Name Exec Date ea User Drectory p TEN Fonte oy 0 lt A __ Call it through the shortcut key lt Ctrl M gt in SQL Query Editor Select one among reuse lists f si SQL Query Editor root localhost SQL1 Its mysal amp 9 D kha salt x a Run Stop sou El Ee a Di oQ Ex B sh BO Pe E E Q ZS Ss NM tm te Je Ab B p 00 E Abc B N pata Execution pan Mes
59. f you type more than 3 characters Reuse SQL lt Ctrl M gt Checked sentences are displayed among contents in SQL history Field Auto Completion lt gt Display field lists next to table alias Keyword Change Case Auto Completion Display completed keyword by Keyword Auto Completion in distinguishing upper lower character Auto Completion for Change Case of Object Name Selected object by Table Auto Completion in distinguishing upper lower character Table Auto Completion lt Ctrl H gt List object next to From into set You can use it optionally when there are too many objects X You should select Keyword Auto Completion lt Ctrl K gt at Auto Completion tab to execute it in SQL Query Editor lt 17 gt http www antwiz com 3 3 E el SQLGate for MySQL User Manual View Object Panel Object panel can be docked at the left or right of the main window and it can search and manage objects If you select an object detail information about the object will be shown at the bottom of the window If you click the right mouse button after selecting an object you can add delete edit or manage it You can add SQL to SQL Query Editor or PL SQL Query Editor simply by using Object Scripting feature You can join sort and filter between objects by dragging and dropping an object to Query Builder You can create various queries and check results with only simple operation Select View Object Panel on t
60. he main menu or click the EI button e sQLGate2010 for MySQL Developer SQL Query Editor root localhost SOLIN File Edit View Query Create Manager Tools Window Help DefaultLayout v 161 x iroot localhost itcss X My fal SQL Query Editor ES REI a fu Y Bo Ga SUB ECH 00 Object Panel p Run gt stop Ek Ee Us mysql sl A E Em ae allte Ei es O udu 060g anBisunb4zsegoss gt X roter O d from help_category a Bn 2 Tables 82 E ahni E ahn2 Gel analyses Gel analysesversion Gel analysesversiondata E analysiscells Gel analysisstates 4 4 m j jp Ee lae E Ca WW d help category id name parent category id url S 1 1 Geographic 0 l 7 2 2 Polygon properties 32 1 E a S a 3 WKT 32 Set 4 4 Numeric Functions 36 PK Column 5 5 Plugins 33 1 PK help_category_id smallint 5 uns 6 6 MER 32 2 name char 64 7 7 Control flow functic 36 3 parent category id smallint 5 uns 8 8 Transactions 33 4 url char 128 9 9 Account Manageme 33 10 Point properties 1 37 LIMIT 0 1000 0 Sec CAP NUM ENG Activation Version 18 http www antwiz com SQLGate for MySQL User Manual e Object Scripts If you click the right mouse button after selecting Table or View objects you can use Object Scripts menu helping SQL creation L C3 SQLGate2010 for MySQL Developer SQL Query Editor root localhost SQL1 e J a
61. ification e Unicode Support SQLGate supports Unicode Multilingual can be handled through it UTF8 UTF16 AL32UTF8 character sets are supported User Friendly Interface It consists of editor grid and user friendly interface which are convenient and powerful features It satisfies user s needs by providing various styles and options to grid such as XP Float Office and so on Access by using MySQL Protocol Directly It supports optimized method which acceses to MySQL directly throught TCP IP by using MySQL protocol without MySQL Client installation or ODBC registration e SSH Tunneling When users try to access to MySQL which is available to access through SSH service they can access with self SSH Tunneling feature of SQLGate without installing additional program e Easy and Fast Query Execution Users can create and execute SQL code easily if they use SQL Query Editor and Query Builder eo Powerful Object Browser It helps inquiry creation modification and deletion for each user through obj ect browser Users can inquire easily and quickly by linking with SQL Query Editor e Database Monitoring Features of Various Types It provides various database monitoring features such as Process Manager User Manager Database Information and Server Statics e Tool of Various Features Provision Even beginner can handle several database management tasks by providing various tools such as Database Backup Imp
62. ion Stored Procedure root localhost FS Object FUNCTION Name Parameter Name in type Name in type Return Type CHAR 1 View SQL OK Cancel root amp localhost 2 Click the OK button 3 Creation statement is added to SQL Query Editor 3 5 7 New Trigger Creates trigger on table and database Select Create Triggers on the main menu 53 New Trigger root localhost mm Database When to use mysql Y BEFORE Table AFTER ahni Y Name Trigger Event INSERT A Definer TE URRENT USER e DELETE Es R A BEGIN 2 3 END n p View SQL OK Cancel root localhost When to use Input condition for the trigger is executed Editor Input SQL that trigger will execute manually or procedure to call on execution lt 34 gt http www antwiz com 3 5 8 SQLGate for MySQL User Manual New Event Creates new event on database Select Create gt Event on the main menu S mo M Ue 9 oa 5 New Event root localhost Database A lt Name Schedule O AT CURRENT TIMESTAMP V ENABLE V ON COMPLETION NOT PRESERVE nm p View SQL OK Cancel root localhost Select a Database Input name of event at Name Select Schedule or input manually Select Options Input SQL to execute manually or procedure to call on execution in Editor window Click the View SQL button to ch
63. izard File Source 52 SQLGate for MySQL User Manual http www antwiz com 4 Set data type Set Dates Times and Numbers format Data Import Wizard x Data Type Define additional options for the data file aug FirstRow 1 Last Row E Show file header Date Time and Number Import Wizard ANNE o Decimal Symbol Thousand Separator 4 Four Digit Years em m 010 Y Leading Zero E Date Separator Logical Values True False Time Delimiter SQLGate for MySQL User Manual First Row First Row to import If there is row name in first row set as 2 Last Row Last Row to import Default is blank 5 Map column of original file onto row of target table Click the Auto Columns Mapping button to map automatically then make sure that each column is mapped correctly Data Import Wizard Es File Preview Auto Column Mapping Click the button for mapping and then check whether column of the original file and column of the table are same 4 102 Lex De Haan LDEHAAN 515 5 103 Alexander Hunold AHUNOLD 590 Kim Data Exporting Sheet Sheet3 Data Import Wizard E File Preview Auto Column Mapping Click the button for mapping and then check whether column of the original file and column of the table are same FIRST NAME LAST NAME EMAIL Steven King SKING 515 Neena Kochhar NKOCHHAR 515 Lex De Haan LDEHAAN 515
64. ize Precision IOT NULL JNSIGNED UNIQUE O INCREME ZEROFILL Default 0 0 0 0 3 0 0 0 0 0 0 0 0 Ra 4 m E eg A View SOL OK Cancel root amp localhost http www antwiz com 29 3 p e d X SS A A A 10 11 12 13 14 15 16 Table Options Input MAX ROWS Input MIN ROWS Input KEY BLOCK SIZE Input AUTO INCREMENT Input AVG ROW LENGTH Select submenus of Advanced Select submenus of Character Set Input name of column at Column Select date type of column at Data Type Input size of column at Size If it is a Primary Key check PK Input default at DEFAULT Input comment of field at Comment Repeat steps of column addition for as much as you want to add Click the View SQL button to check SQL Click the OK button New Index Creates Primary key Unique key and Full text on table in database Select Create Index on the main menu 6G New Index root amp localhost es Database mysql Name Table help_category x PRIMARY KEY UNIQUE FULL TEXT Table Columns Index Columns PK Column Name Data Type PK Column Name Data Type v help category id SMALLINT 5 name CHAR 64 parent category i SMALLINT 5 gt url CHAR 128 View SQL OK Cancel root localhost SQLGate for MySQL User Manual PRIMARY KEY 1 Select a Database 2 Input name of index to create at Name 3 Select Tables to create Primary Key 4 Check at
65. lationship Type Rel 01 i y Y Logical Relationships Table Source Table procs priv Target Table event Relationship Keys Source Column Name Target Column Name Comment Relationship Type Select one among 1 1 1 n nim Logical Relationships When checked display as dotted line Source Table Original table of relationship is displayed Target Table Target table of relationship is displayed Relationship Keys Relationship column lists between original table and target table are displayed Source Column Name Column list of original table which is related to column of target table is displayed Target Column Name Column list of target table which is related to column of original table is displayed Add If you click the Add you can input columns which are going to be target of relationship key additionally Delete f you select relationship key list and then click the Delete the selected relationship key will be deleted Comment Input description of relationship 81 http www antwiz com 8 5 Group Area procs priv e Procedure privileges D CHAR 77 sET 0 TIMESTAMP 0 Help Table Ties up table text objects to one group SQLGate for MySQL User Manual Object in group area moves with group area when moves group area Modify Name Color Comment after popping up Edit Region window by double clicking 8 6 Text Box rrr Mm Add
66. list e Filter Table List This is a feature to filter table list and it shows only table name which has inputted word in table list e Select All Check all checkboxes by table in table list e Table List Display only table which has filter word among tables of the selected schema in select schema If there is no filtering word all table lists of the selected database are displayed e Add Table If you drag to Canvas or double click it after selecting a table in table list the selected table will be revered and putted on Canvas If you click the Add button checked tables in table list will be reversed and putted on Canvas Li Show table on Canvas and currently working area briefly You can move working area of Canvas by clicking the mouse or dragging If you click the Zoom Out button contract Canvas f you click the Zoom In button expands Canvas lt 79 gt http www antwiz com 8 1 8 2 SQLGate for MySQL User Manual Table Object time zone transibon type Y Time zone transition types INT 10 CHAR 8 This is an added object on Canvas after that you select a table from table list Displays column list of table primary key data type logical field name and so on Table Object Menu Change Table Display Options x Reflected in All Tables Y View Table Logical Name Column 1 Field Name z Column 2 Data Type zm Column 3 None Column 4
67. lumn While Caret Moves 7 Variable Horizontal Scrollbar E Float Markers Y Undo After Saving E Disable Block Selection E Highlight the current Line Hide Cursor At a Keystroke E Scroll to last line E Keep Block Selection Mode E Smart Caret 7 Unindent Align Number ofUndo 1000 TabMode E Collapse Level 1 Tab Size 4 Restore Defaults e Font Set font options Gutter 7 Visible Dare If letter is not visible select character set Right Margin Width 30 7 Visible Color Le ct V Line Number am JI oe II c jJ Position 80 Color uge Je En glish dE 245 HE amp A nvikr yAwooa T rk e ti ng Vi t may dl alt amp al DyCCKM pn let Sample SQL DROP PROCEDURE language update_language2 CREATE PROCEDURE update Language BEGIN Declare local variables DECLARE done BOOLEAN DEFAULT 8 a If specific text is broken in editor change the Character Set e Highlight Set highlight options F Bold E Italic Underline Background Color _ Whte l iveco Jugos EJ En glish 2 EE ENS amp AAnvikr yAwooa T rk e ti ng Vi t mas dl alt amp lal DyCCKM pn let Sample SQL DROP PROCEDURE language update_language2 CREATE PROCEDURE update language2 BEGIN Declare local variables DECLARE done BOOLEAN DEFAULT 8
68. om Script Report gt Gel dom Kj dom fey Export Data E dom Y Import Data Y Filter E func Refresh Gi general log omment Add lt 71 gt http www antwiz com SQLGate for MySQL User Manual Column Add columns to the selected table Constraint Add constraints to the selected table Index Add indexes to the selected table Trigger Add triggers to the selected table New Table Provide CREATE TABLE wizard that can create table Alter Change column and comment of the selected table Delete Drop Truncate Execute Drop Truncate command to the selected table Rename Change name of the selected table Copy Copy the selected table Provides Only Table Structure Table Structure and Data Edit Comment Modify table comment and column comment Row Count Display record count of the selected table s data Object Reports Print out information of the selected table as reports Script Report Print out script of the selected table as reports Export Data Export the selected table Excel Csv SQL and so on Import Data Import the selected table Excel Csv SQL and so on Filter Filter and sort lists by using the Filter window Refresh Refresh 6 2 View Inquires view list by owner and detail information of view and performs overall features about view such as creation modification deletion rebuilding and so on
69. on the main menu or click the shortcut key lt F8 gt or the S button 4 Y E E BY Root E SQL History f Proc Func History E Oe User Directory e m RRB OW Find what __ O Connection info root localhost SQL Exec Date DELIMITER SET bdate SELECT mysal userage bdate Connection Info lc Dual 20 12 6 2010 6 24 14 PM jroot amp localhost SELECT FROM SELECT FROM help category A WHERE help category ID lt 1 12 6 2010 5 46 33 PM root amp localhost SELECT FROM SELECT FROM help category A WHERE help category ID lt 1 12 6 2010 5 38 39 PM root amp localhost select from help keyword a 12 6 2010 5 24 30 PM jroot amp localhost select from help category a 12 6 2010 5 24 29 PM root amp localhost select from help relation a 12 6 2010 1 51 12 PM root amp localhost SELECT FROM help category A WHERE help category ID lt 10 select from help category a select from help keyword a select from h SELECT a help category id a name parent category id url FROM help catego 12 6 2010 11 58 59 Al 12 6 2010 11 50 31 Al 11 26 2010 3 52 43 PI root amp localhost root localhost root localhost select from ahnia 11 26 2010 11 52 40 root amp localhost ime SS E select from help category a select from help category a select from 11 25 2010 7 01 19 PI root amp localhost s
70. ort Export Utility Wizard editor and so on e Report Tool to Print as Desired Types Users can design directly and print out data by using Report Designer and shorten creation time of various reports e ER Design Feature Users can create ERD entity relationship diagram by reversing relationship between tables in ER Design window 62 http www antwiz com Lula without installation of separate program Operation Environment e Operation Environment All of Windows Family OSs Over Intel Pentium 4 Over 512MB Memory Over 50MB free hard disk space e Configuration Features of folders which are composed program are as follows Bin Composed of execution files and ini dat files Languages Folder to support multilingual Report Folder to save report samples Screen DII files which are needed at form configuration Webscript Webscript template file Workspace Temporary save folder for SQL Query Editor lt gt SQLGate for MySQL User Manual http www antwiz com 3 3 1 3 1 1 E 2 SQLGate for MySQL User Manual Main Menu File New It creates new SQL Query Editor or Query Builder window SQL QUERY EDITOR Select File New SQL Query Editor on the main menu or press the shortcut key lt Ctri N gt or the sot button Query Builder Select File New Query Builder on the main menu or click the eg button ER Design Select File New ER Design on th
71. pe of SQL Query Editor into ANSI Unicode Swapped Unicode or UTF 8 File Encoding gt E ANSI File Type gt Unicode Close Window Swapped Unicode Close All Windows UTF 8 lt 10 gt http www antwiz com SQLGate for MySQL User Manual 3 1 12 File Type If you select File File Type on the main menu you can convert file type of SQL Query Editor into Default Windows CR NL Macintosh CR or Unix NL 3 1 13 Close Window If you select File Close Window on the main menu you can close the current window 3 1 14 Close All Windows If you select File gt Close All Windows on the main menu you can close all windows 3 1 15 Print Preview Select File Print Preview on the main menu to open preview window 3 1 16 Print Select File Print on the main menu to print contents on SQL Query Editor 3 1 17 Printer Setting Select File Printer Setting on the main menu to set printer and page setting 3 1 18 Exit Select File Exit on the main menu to close program after disconnecting connected session 11 http www antwiz com SQLGate for MySQL User Manual 3 2 Edit 3 2 1 Undo Cancel the just previous task Select Edit gt Undo on the main menu or press the shortcut key lt Ctrl Z gt 3 2 2 Redo Re execute canceled task Select Edit gt Redo on the main menu or press the shortcut key lt Shift CtrI Z gt 3 2 3 Cut Cut off selected contents
72. r MySQL User Manual 6 3 Triggers Inquires trigger list of the selected owner and detail information and performs overall features about trigger such as creation modification deletion and so on Object Explorer root localhost df Object a root amp localhost amp mysql A information schema B test Tables Views E Triggers 2 wf triggeri Y roge Test oir Functions Procedures Event root localhost 2 C lt ba ba ba ba ba zl Oh Un bh Lu 18 ACTION REFERENCE OLD TABLE ACTION REFERENCE NEW TABLE Le le les TRG TriggerTest UPDATE _ Properties Scripts Name Value 1 TRIGGER CATALOG 2 TRIGGER SCHEMA test 3 TRIGGER NAME TRG TriggerTest UPDATE 4 EVENT MANIPULATION UPDATE 5 EVENT OBJECT CATALOG 6 EVENT OBJECT SCHEMA test 7 EVENT OBJECT TABLE triggertest 8 ACTION ORDER 0 9 ACTION CONDITION 10 ACTION STATEMENT BEGIN 11 ACTION ORIENTATION ROW 12 ACTION TIMING BEFORE ACTION REFERENCE OLD ROW OLD ACTION REFERENCE NEW ROW NEW CREATED SQL MODE DEFINER 20 CHARACTER SET CLIENT COLLATION CONNECTION DATABASE COLLATION STRICT TRANS TABLES NO AUTO CREATE USER NO ENGINE SUBSTITUTION root amp localhost US utf8 general ci latini swedish ci e Tab Information of Triggers Properties You can check information of the selected trigger Scripts You can check creation script of the selected trigger lt 73 gt http www antwiz com SQLG
73. rd CS File Name A Please select the file to export data 010 Export to a file ci ahni XLS um Export Wizard Records Count of Each File Action After Exporting 9 None 010 C Open export file If records exceed 6 hundred thousand a file will be created additionally every 6 hundred thousand by selecting Records Count of Each File If you input a file name to export as ExportObject xls ExportObject001 xls and ExportObj ect002 xls files will be created 50 http www antwiz com SQLGate for MySQL User Manual 4 Click the Run button lt 51 gt http www antwiz com 3 13 3 Import Data You can import data in various formats files such as MS Excel DBF Text CSV File and so on to table by using Import Data Select Tools Import Data on the main menu or click the EN button 1 Select a table to import then click the Start button 4 Import Data root localhost ge LA root amp localhost H d information schema O B mysql A ahni 2 Set type of original file Data Import Wizard File Type Please select the file format of the data you would like to import amp g Table Type DBase File dbf Import Wizard Text File txt csv 9 Excel File xls C MS Access File mdb Data Import Wizard File Name Select the file that contains the data you would like to import aug Import File m Import W
74. re code qna seg ansnum depth title contents html flag reg date view no stmt mysql query qry if row mysql fetch array stmt user nm row user nm email row email passwd row passwd p_seq row p_seq ansnum row ansnum depth row depth title row title contents row contents Copy above PHP code to clipboard and then select the Paste from the code on the context menu in SQL Query Editor or press shortcut key lt Ctrl Shift V gt Only SQL statement will be extracted like below lt 64 gt http www antwiz com SQLGate for MySQL User Manual SQL Query Editor root localhost SQU Lele x gt Run P Stop gt Es ls mysal os x e a Wi 2 amp 3 O KBHS OG 3 3 5 DIO JA SI USS SS PE mb gt sQi x E 00 A select user_nm passwd email p_seq ansume depth title contents html_flag reg_date view_no 2 from faq where code qna t S 4 E Data Execution plan Message History History aed 0 0 0 Specify background color of text You can change background color of table that you want to find and display it in SQL Query Editor If you select Find All when you find wanted word you can find all same words and specify background color to found words Moreover you can specify background color for each word differently A 1 If you click the button after selected a table that you want
75. riables Server Status Variable name Value Aborted dente Aborted_connects 0 Binlog_cache_disk_use 0 Binlog_cache_use 0 Bytes_received 2496 Bytes_sent 83647 Com_admin_commands 3 Com_assign_to_keycache Com_alter_db Com_alter_db_upgrade Com_alter_event Com_alter_function Com_alter_procedure Com_alter_server Com_alter_table Com_alter_tablespace L 16 1616161616161616 root amp localhost e Server Variables Check setting value of server which is connecting to current database e Server Status Check status of server which is connecting to current database Aborted clients Disconnected count because connection of client is terminated abnormally Aborted connects Failure count of connecting to MySQL Bytes received Received bite count from all clients Bytes sent Sent bite count to all clients Connections Tried count which connect to mysql server Created tmp disk tables Temporary table count which exists on created disk during sql statement execut ion Created tmp tables Temporary table count which exists on created memory during sql statement executi on Created tmp files Count of temporary files which are created by mysqld Delayed insert threads Delayed count of using insert handler threads Delayed writes Wrote rows count as INSERT DELAYED Delayed errors Count of rows which are occurred error when wrote as INSERT DELAYED clause Including d
76. rk Move to bookmark Clear All Bookmarks Delete all bookmarks 3 2 11 Goto line Move to inputted line at the Goto line dialog Select Edit gt Goto line lt Ctrl G gt on the main menu or press the shortcut key lt Ctrl G gt Goto line Enter line number OK Cancel 3 2 12 Word Wrap The text wraps around if it is longer than horizontal area of the editor Select Edit Word Wrap on the main menu 3 2 13 Show Space Tab Carriage Return Space Tab and Carriage Return will be shown among texts in editor Select Edit Show Space Tab Carriage Return on the main menu 3 2 14 Toggle Folding Set to fold editor Select Edit Toggle Folding on the main menu 3 2 15 Comment Block Make selected text in editor into comments Select Edit Comment Block on the main menu or press the shortcut key lt Ctrl gt 3 2 16 Uncomment Block Remove blocked comments of selected texts in editor 13 http www antwiz com SQLGate for MySQL User Manual Select Edit gt Uncomment Block on the main menu or press the shortcut key lt Shift Ctrl gt 3 2 17 Convert to Convert selected texts in editor into upper case lower case upper lower case or convert only first character into upper case Select a submenu of Edit Convert to on the main menu Convert K Upper Case 3 Increase Indent Lower Case Decrease Indent Shift Tab Aa Change Case se Convert SQL K
77. scape character and separator by program language SQL Conversion Options Delphi VB C ASP PHP JSP Java C Close SQL Clear SQL Add amp VarFirstRowSQL SQL Add amp VarNextRowSQL 58 SQLGate for MySQL User Manual http www antwiz com SQLGate for MySQL User Manual 3 14 Window 3 14 1 Tile Horizontally Tiles windows horizontally Select Window Tile Horizontally on the main menu 3 14 2 Tile Vertically Tiles windows vertically Select Window Tile Vertically on the main menu 3 14 3 Cascade Tiles windows in cascade Select Window Cascade on the main menu 3 14 4 Arrange Icons Arranges window icons Select Window Arrange Icons on the main menu 3 15 Help 3 15 1 Help Opens help file Select Help Help on the main menu 3 15 2 Activation Authenticates program as formal commodity Select Help Activation on the main menu Program Registration imm r Activation License Key SQLGate2010 for MySQL Developer El ei Paste Buy Now Activation Close You are connected to the Internet If you input the license key of 16 digits and click the Activation button program authentication will be finished 3 15 3 Update Check Checks latest update information Currently using version and latest version are displayed Select Help Update Check on the main menu lt 59 gt ht
78. sentence of simple contents on Canvas Open the text box edit window by double clicking then edit contents in text box Text Box Contents Double click the text box to change contents 8 7 Setup Print Print Page O All Pages Selected Pages Select File gt Print on the main menu to open the Setup Print window 82 http www antwiz com 8 8 8 9 SQLGate for MySQL User Manual Print Page All Pages Print out whole model Selected Pages Print the selected model in model Model Select only a model that you want to print out with mouse in status pressing the Ctrl key Page Setup Page setup window shows up Print Print model through printer Page Setup C3 Printer Setting ES Model p e pose a printer A4 210x297 mm 8 26x11 7 inches Vertical Landscape Pages Horizontal 4 Vertical OK Choose a printer Select a printer to print out after popping the Choose a Printer window up Page Size Select paper to print Direction Select orientation of print paper vertical or landscape Pages Landscape Select how many pages to print widthwise Vertical Select how many pages to print pale wise Width Set width to print on print paper by dragging mouse Printer Setting Back to previous window Find Table Object Find Table Table to find o
79. sesversion Ix seq Integer name String ES Seen fen bep A parent category id Integer Insert point ger Stri Delete link Property 4 n Criteria Selection Grouping criteria Sorting All of the following are met root localhost Select lt Inner J oin gt lt Outer J oin gt lt 6 gt http www antwiz com SQLGate for MySQL User Manual Link properties DS join tables tables priv and time zone Host Use leap seconds Include all from tables priv Include all from time zone Cancel e Set Where Select Group Sorting Condition You can add modify and delete Where selection group and sorting condition at the bottom of query builder e View SQL If you select the SQL tab you can check the created SQL e Run Press the shortcut key F5 or click the p button SQL is executed and you can check results lt 71 gt http www antwiz com SQLGate for MySQL User Manual ER Design You can create ERD entity relationship diagram by applying Reverse Engineering to relationship between tables in ER Design window It provides basic features which are necessary for ERD edit such as group area text box and so on also provides ERD print file saving and importing mm Select File New ER Design on the main menu or click the a button e Screen Composition 3 ER Design root 192 168 0 30 Sa EaR ER Database
80. t 1 37 LIMIT 0 1000 0 Sec 37 rows selected In case of Select statement execution results are displayed as grid type in Data tab at the bottom http www antwiz com SQLGate for MySQL User Manual tan P IC Qs bel ma i ES ae O O BHS O aB amp gD Pri we TORR BOE BHM 00 select from help_category a select from help_keyword a select from help_relation a geam o Ee ISI heb category id 4 3 n lal rm Joma 4 x e help topic id lanang t 1 2 353 2 469 ala rom T4 Tx fepe fe N Data Execution plan Message History 1 990 LIMIT 0 1000 OSec If there is no selected block all SQLs will be executed In case of executing several SQLs use semicolon lt gt to separate bss P D ser P Re IN msde ae BE EBC 4A gt 00 u 480 Z45 58C msi S 85 00 select from help_category a select from help_keyword a select from help_relation a vr LIMIT 0 E El help category id NM help keyword id LS 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 2liBlovjolvlololnlalalwinir lolo 1 990 LIMIT 0 1000 OSec If you click the E button on the above image grid will be displayed horizontally without re executing SQL lt 25 gt http www antwiz com
81. ta Import Wizard Ea Column Mapping Set field mappings to specify the correspondence between fields in the source and Import Wizard Parent category_id c 010 cora 9 Update items are activated as follows XT s Summary We ve gathered all the information the wizard needs to import your data Please click the Execute button to begin the import process Import Mode Append Add records to the destination table AE O Update Update record in destination matching with record from source 7 Append Update If record exists in destination update it Otherwise add md lt O Delete Delete records in destination that match records in source Copy Delete all records in destination table replace with source contents Append New Add records only if there is no recored in destination table Add Update Update if record exists in target table or add if not Delete Delete if record exists in target table 54 SQLGate for MySQL User Manual http www antwiz com SQLGate for MySQL User Manual Copy Delete all records in target table and adds record to original source file Append New Add records only if there is no record in target table If you set key of column in column mapping confirmation step you can select one among Update Add Update Delete mode 10 Import result will be shown The data import process has completed successfully x VY Yow Th
82. te mysal domainriskfactoritems analyze status OK OK Close ANALYZE TABLE root localhost 1 Select a Database 2 Select tables to analyze at left table list and then move them to right list by clicking 3 Add All or 12 Add 3 Click the OK button to execute analysis command 3 12 2 Check Tables 43 http www antwiz com SQLGate for MySQL User Manual This feature is to check that errors are on table If there is an error message will be printed out at Msg text field and table restore is available with Repair tables feature Select Manager Table Manager Check Tables on the main menu C3 Table Manager root localhost mm Database ES gt Tables Selected Tables ahni ahn2 analyses analysesversion analysistypes category commonconfig db analysiscells columns priv analysesversiondata mi vy domainriskfactoritems domainriskitems domains damainetatas e Quick Fast E Changed Y Medium 7 Extended Result Table Op Msg type Msg text mysa l analysiscells check status OK mysql columns priv check status OK mysal analysesversiondata check status OK CHECK TABLE root localhost 1 Select a Database 2 Select tables to check at left table list and then move them to right list by clicking 29 Add All or 12 Add 3 If you click the OK button command to check will be executed lt 44 gt
83. tp www antwiz com SQLGate for MySQL User Manual GH update Check SQLGate2010 for MySQL Developer You already have the latest version Current version 2 0 0 4 Latest version 2 0 0 4 Latest update date 2010 12 03 2 2 48 05 Automatic update expired date 2011 11 10 Registered version can update for 1 year after purchase 3 15 4 About SQLGate Inquires program information Select Help About SQLGate on the main menu SQL Gate 2010 SQLGate2010 for MySQL Developer Update Version 2 0 0 4 Activation Version This software is protected by the protection at of computer program copyright law universal copyright convention and other intellectual property rights The patent right copyright and intellectual property belong to Antwiz Inc http www antwiz com n lt 60 gt http www antwiz com SQLGate for MySQL User Manual 4 SQL QUERY EDITOR 4 1 Multi Query You can execute several SQLs simultaneously and checks results in grid Also you can compare data more easily Separator of command is prn P b Qsw EL R I ma 0 5 amp RES ae immRe O uHu 0g oetama BUSSE e mi u select from help category a select from help keyword a 0 mp 1000 Z help_category_id name parent_category_id 1 Geographic 2 Polygon properties 3 WKT 4 Numeric Functions al 5 i Gadea 17 c espe fn help keyword id name JOIN
84. un Execute the selected procedure Filter Filter and sort lists by using the Filter window SQLGate for MySQL User Manual http www antwiz com SQLGate for MySQL User Manual Query Builder You can create quires only by draging amp dropping easily and check results by using Query Builder You can join sort and filter query objects query view column and so on with simple mouse operation and check results by creating various queries Select File New Query Builder on the main menu or click the El button on the toolbar e Tables View Select Open the Object Panel by selecting View Object Panel on the main menu or clicking the El button on the toolbar Select needed table or view in object panel and drag amp drop at query builder by using mouse Check columns to display in SQL Query Builder root localhost 8 Query 1 Query 1 A help_category v x analysesversion ei x seq Integer name String versionSeq Integer parent category id Integer analysisSeq Integer url String register Integer domainSeg Integer regDate DateTime 4 n Criteria Selection Grouping criteria Sorting Allofthe following are met root amp localhost e Join Select a line between objects that join was established and then click the Property on the context menu EB Query Builder kl OR Query 1 help category KE analy
85. uplicate key 38 http www antwiz com SQLGate for MySQL User Manual Flush commands Exceeded flush command count Handler delete Deleted rows count from table Handler read first First entry count which is read from index Handler read key Request count to read row that exists key Handler read next Request count to read the right behind row in key sequence Handler read rnd Request count to read row on the basis of fixed location Handler read rnd next Requesting count to read next row in data file Handler update Requesting count to update rows in table Handler write Requesting count to insert rows to table Key blocks used Count of using blocks in key cache Key read requests Requesting count to read key block in cache Key reads Count of reading key block from disk physically Key write requests Requesting count to wirte key block in cache Key writes Count of writing key block in disk physically Max used connections Maximum concurrent connection count Not flushed key blocks Count of blocks that contents of key cache are changed but those are not saved to disk yet Not flushed delayed rows Delaying row count because of INSERT DELAY Open tables Currently opened table count Open files Currently opened file count Open streams Count of currently opened stream which is used to use at logging Opened tables Opened table count until now Select full join Joined count without key It must to be
86. w Query Creat New kA New Connection bl Disconnect Disconnect All lt 9 gt L http www antwiz com Ska 3 1 6 3 1 7 3 1 8 3 1 9 3 1 10 3 1 11 SQLGate for MySQL User Manual Reconnect Reconnects to currently connected MySQL server Select File gt Reconnect on the main menu Change Password Select File gt Change Password on the main menu You can change password of a user who is currently connected Change Password root localhost New Password Confirm Password Open If you select File gt Open lt Ctrl 0 gt on the main menu Open File dialog will be shown If you select a file the file will be opened on SQL Query Editor If SQL Query Editor doesn t exist the file will be opened after executing new SQL Query Editor Recent Files If you select File gt Recent Files on the main menu list of recently opened files is shown If you select a file the file will be opened on SQL Query Editor If SQL Editor doesn t exist the file will be opened after executing new SQL Query Editor Save If you select File gt Save lt Ctrl S gt on the main menu you can save contents on SQL Query Editor Save As If you select File gt Save As Ctrl Shift S gt on the main menu you can save contents on SQL Query Editor as new name File Encoding If you select File File Encoding on the main menu you can convert encoding ty

Product Menual - SQLGate for SQL Server

Contents

Download Pdf Manuals

Related Search

Related Contents