Membuat USB Installer Centos 7 di Mac / OsX
Membuat USB Installer Centos 7 di Mac / OsX Reviewed by ilham.sp on October 08, 2019 Rating: 5
Menjalankan TMUX Langsung Dengan Perintah Tertentu dan menjalankanya di crontab
Menjalankan TMUX Langsung Dengan Perintah Tertentu dan menjalankanya di crontab
20 Command Line Tools to Monitor Linux Performance - Part 2
20 Command Line Tools to Monitor Linux Performance - Part 2 Reviewed by ilham.sp on September 22, 2019 Rating: 5
Setting NTP di Centos 7
Setting NTP di Centos 7
Notice
This site uses cookies from Google to deliver its services, to personalise ads and to analyse traffic. Information about your use of this site is shared with Google. By using this site, you agree to its use of cookies.Learn More
You need to prepare your host, port, username, and password to get connected. You can create a connection or just double-click on the database file to open. Noted: Your database username and password are stored
securely in your Keychain. We never sync any of your data to our server. How to connect1. Create a Connection
MySQL, SQL Server, Cockroach.
Or you can choose to import from URL, just copy and paste your URL. You can find and copy the URL from your server configuration.
For example, you can connect to our demo PostgreSQL database by importing this URL:
postgresql://kaujqvzitvygtn:8[email protected]ec2-184-72-219-186.compute-1.amazonaws.com/dbmq4p6tscea5f?statusColor=DAEBC2&enviroment=production
2. Open anything
You can open anything using ⌘ + P, including database, table, schema, view, function…
3. Edit data
From the table view, you can edit data inline by double-clicking on the data cell or using the toggle view in the right sidebar. The toggle view can be enabled using the toggle button at the top right or by pressing Space.
After editing, press Commit icon near the top left segment panel or use ⌘ + S to commit the changes to the database.
4. Save Changes to the Database
TablePlus does not send the queries that modify the database automatically to the server unless you confirm the changes. Therefore, after querying and editing your data from the app, you’ll need to commit the change to the database. That’s when your database actually gets modified. There are two ways to commit the changes:
- Using the top left segment control.
- Using the shortcut key: command + S.
Noted: All the changes will be recorded in the history tab. TablePlus supports 3 safe mode levels to prevent human mistakes. Click on the clock icon (near edit segment control) to enable it.
5. Open SQL Query Editor
You can click on the SQL Query Editor icon near the top left, or use ⌘ + Return (or ⌘ + E) to open query editor. TablePlus will open the editor with the most recent script.
6. Execute Queries
After writing your queries, press Run All button, or use ⌘ + Enter, and TablePlus will execute all the SQL code in the editor.
- You can change the default button to Run Current from the dropdown near Run All, Tableplus will only run the statement under the cursor.
- If you want to split results into tabs, click on query setting on the left, there are also many other settings (font, auto suggestion…)
7. Create Tables
When viewing the items tab in the left sidebar, right-click on the sidebar and choose New Table, or you can use + Table button near the bottom left to create a new table.
After creating, press Commit icon near the top left segment panel or use ⌘ + S to commit the changes to the database.
8. Show Data from Selected Columns
You can show data from the selected rows by the column name. Click the Column button at the bottom of the workspace window and choose which columns to show.
9. Filter Data
To open filter, press the filter button at the bottom of the window or use ⌘ + F Each filter contains there simple boxes:
- a dropdown list of the column names
- common conditions such as equal, contain, IS NULL,…
- one text box to fill the value.
You can apply multiple filters to quickly filter out the records you want to see.
Press filter button again or use shortcut key esc to turn off the filter.
10. Import Data
To import a CSV file to a current table:
- Choose File > Import CSV from the menu bar
- Right-click on the table in the left sidebar or right-click in the data content and choose Import CSV
After importing, press Command + R to reload current workspace.
11. Export Data
To export a table, right-click on the table name in the left sidebar and choose Export Table. Note that if you right-click on the data browser view, it will export only the current page of results, not the whole table.
The output file can be CSV, JSON or SQL.
Read more on 11 tips to boost your productivity with TablePlus.