archive-com.com » COM » S » SEQUELPRO.COM

Total: 92

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Relations View | Sequel Pro
    MySQL Reference Bundles Core Bundles Contributed Bundles How to use Create your own Submit a bundle Contribute Coding Localization Get Involved Contact Us In the relations view you can view and delete any relations that are attached to a table Shortcut 3 Sequel Pro Donate Get Involved CocoaMySQL Blog Download Nightly Build Server Release Notes Release Archive Issue Tracker Documentation Developers Feature Requests Contact Us FAQs MySQL on Mac OS

    Original URL path: http://www.sequelpro.com/docs/Relations_View (2016-02-10)
    Open archived version from archive


  • Table Info View | Sequel Pro
    a bundle Contribute Coding Localization Get Involved Contact Us The Table Info view gives you an overview of important information for the currently selected table including encoding and data sizes You can also reset the Auto increment on a table that supports it and quickly copy paste an SQL query to export the table structure Shortcut 4 Sequel Pro Donate Get Involved CocoaMySQL Blog Download Nightly Build Server Release Notes

    Original URL path: http://www.sequelpro.com/docs/Table_Info_View (2016-02-10)
    Open archived version from archive

  • Navigator | Sequel Pro
    your own Submit a bundle Contribute Coding Localization Get Involved Contact Us The navigator allows you to explore the Databases Tables and Fields on the MySQL server you are connected to You can easily drag fields or table names to the Query View to compose queries quickly and without typos Shortcut N Sequel Pro Donate Get Involved CocoaMySQL Blog Download Nightly Build Server Release Notes Release Archive Issue Tracker Documentation

    Original URL path: http://www.sequelpro.com/docs/Navigator (2016-02-10)
    Open archived version from archive

  • Working with Query Favorites | Sequel Pro
    A mirrored tab snippet is not allowed inside of a x tab snippet and causes mismatches Nested tab snippets By means of tab snippets you can generalize the query favorite SELECT FROM WHERE due to the fact that the WHERE clause is optional This can be achieved by using nested tab snippets You can change the query favorite into SELECT 0 field FROM 2 1 table WHERE If you change the tab snippet 2 the tab snippet 1 will be deleted automatically Tab snippet with default value One default value It could be the case that you want use the query favorite mostly for one table but not always The tab snippet template supports the declaration of a default value The following syntax is used x default value Given that your preferred table name is table01 we can change the query favorite into SELECT 0 FROM 1 table01 WHERE After insertion of that query favorite and selecting the second tab snippet table01 will be selected entirely thus you can assume the suggested default value or you can edit it Several fixed default values as completion list It could be the case that you want use the query favorite mostly for a set of fixed table The tab snippet template supports the declaration of a list of default value The following syntax is used x a b Given that your preferred table names are table01 table02 and table03 we can change the query favorite into SELECT 0 FROM 1 table01 table02 table03 WHERE After insertion of that query favorite and selecting the second tab snippet a narrow down completion list window appears thus choose your desired item or start to type to narrow down the list or press to expand the list again Tip If you use the default list template a b the narrow down completion list switches to the fuzzy search mode which means that if you have e g the list items reference and ref base you can type simply r to narrow down the list to ref base due to the fuzzy regular expression search strategy r If you want to switch to the fuzzy search mode coming from the normal list template a b simply press Dynamic default value due to current selected table This kind of query favorite SELECT FROM WHERE could be used frequently to select something based on the current selected table for instance To insert the name of the current selected table you can make usage of the placeholder string SP SELECTED TABLE In addition there are also the placeholders for the current selected database name SP SELECTED DATABASE and as a comma separated list the names of the current selected tables SP SELECTED TABLES available Thus we change our query favorite into SELECT 0 FROM 1 SP SELECTED TABLE WHERE or to allow to invoke the completion easier in order to insert one or more field names in the first tab snippet SELECT 0 SP SELECTED TABLE FROM 1 SP SELECTED

    Original URL path: http://www.sequelpro.com/docs/Working_with_Query_Favorites (2016-02-10)
    Open archived version from archive

  • Where are MySQL's Files Kept? | Sequel Pro
    given here it could be because you changed the configuration these are only the default locations Some of the files only exist while the MySQL server is running eg the socket file If your installation has no option file my cnf you can create it in the base directory of your installation see Using Option Files section of the MySQL manual for more information If you can connect to your MySQL server you can find many of these paths by selecting Show Server Variables from the Database Menu in Sequel Pro MySQL installed with the official pkg installer Socket File tmp mysql sock Data Files usr local mysql data Error Log usr local mysql data HOSTNAME err insert your hostname Base Directory usr local mysql this is a symbolic link MySQL pre installed on Mac OS X Server Socket File var mysql mysql sock MySQL 5 installed with MacPorts Socket File opt local var run mysql5 mysqld sock Data Files opt local var db mysql5 Error Log opt local var db mysql5 HOSTNAME err insert your hostname MySQL installed with MAMP Socket File Applications MAMP tmp mysql mysql sock Data Files Applications MAMP db mysql Base Directory Applications MAMP Library

    Original URL path: http://www.sequelpro.com/docs/Where_are_MySQLs_Files (2016-02-10)
    Open archived version from archive

  • Exporting an SQL file using the mysql command line | Sequel Pro
    How to use Create your own Submit a bundle Contribute Coding Localization Get Involved Contact Us Type Password at the Prompt mysqldump h 127 0 0 1 u db user p db name import file sql Include Password in Command mysqldump h 127 0 0 1 u db user p secretpassword db name import file sql Sequel Pro Donate Get Involved CocoaMySQL Blog Download Nightly Build Server Release Notes Release

    Original URL path: http://www.sequelpro.com/docs/Exporting_SQL_File_Using_MySQL_Client (2016-02-10)
    Open archived version from archive

  • Setup MySQL on Mac OS X Server 10.6 | Sequel Pro
    Get Involved Contact Us Setup MySQL on Mac OS X Server 10 6 Open Server Admin Select the server from the list Click Settings in the toolbar Under the Services tab tick MySQL and save your changes In the list of servers click the triangle to show the list of active services Select MySQL If MySQL is running click Stop MySQL Set a Root password Click Start MySQL Sequel Pro

    Original URL path: http://www.sequelpro.com/docs/Setup_MySQL_on_Mac_OS_X_Server (2016-02-10)
    Open archived version from archive

  • Large SQL Files | Sequel Pro
    default and downloads results as fast as possible to avoid locking up the server tables If you are exporting very large tables and the connection is not the bottleneck ticking this will write results to file as they are retrieved to keep overall memory usage as low as possible This does however result in the table potentially being locked for slightly longer Using the mysql client and mysqldump If you

    Original URL path: http://www.sequelpro.com/docs/Large_SQL_Files (2016-02-10)
    Open archived version from archive



  •