SQL Database Pro - User Guide

Contents

Chapter 1: Getting Started

Opening a Database
Viewing a Table
Sorting by a Column
Performing a Query

Chapter 2: Importing CSV Text and SQL Scripts

Importing CSV Text
Importing SQL Script

Chapter 3: Exporting as CSV, PDF, or SQL

Exporting as CSV Text
Exporting as PDF Document
Exporting as SQL Script

Chapter 4: Performing SQL Queries

Selecting Rows
Grouping Rows
Filtering Groups

Getting a Count
Getting a Total

Chapter 5: Creating and Updating Tables

Creating a Table
Creating with SQL

Adding a Row
Adding with SQL
Copying a Table

Updating a Row
Updating with SQL

Chapter 6: Deleting Rows and Tables

Deleting a Row
Deleting with SQL

Deleting a Table
Dropping a Table

Chapter 7: Auto Correction and Generation of SQL

Auto Correction of SQL
Auto Generation of SQL

Appendix A: Frequently Asked Questions

How do I save a copy of a database?
Choose "File" -> "Save As", and enter a new database name for the copy.

How do I switch between opened databases?
Click on the window title bar to switch between opened databases.

How do I enter full screen mode?
Click on the green button to enter full screen mode. Click again to return to normal mode.