Creating a super Q-pointer

Follow these steps to create a Super Q-pointer called usacustomer to retrieve data from the customers table.

Procedure

  1. Type u md customers
  2. Type q in attribute 1.
    Note: Attribute 2 is left blank, press ENTER to continue.
  3. Type mysql:odbc:customers in attribute 3.
  4. Type a table name in attribute 4, and then press CTRL+V. For example, type:
    customers
  5. (Optional) Type a where clause, and then press CTRL+V. See Creating a super Q-pointer. For example:
    city = "irvine"
  6. (Optional) Type a candidate key, and then press CTRL+V. See Creating a super Q-pointer. For example:
    customerid
  7. Type a column name(s) from the Customer table (Northwind) database, and then press CTRL+XF to save to file. For example:
    customerid
    organizationname
    address
    city
    state
    postalcode
    contactname
    cantacttitle
    phonenumber
    faxnumber
    note

    The Super Q-pointer customers displays.