Follow these steps to create a Super Q-pointer called usacustomer
to retrieve data from the customers table.
Procedure
- Type u md customers
- Type q in attribute 1.
Note: Attribute 2 is left blank, press ENTER to continue.
- Type mysql:odbc:customers in attribute
3.
- Type a table name in attribute 4, and then press CTRL+V.
For example, type:
- (Optional) Type a where clause, and
then press CTRL+V. See Creating a super Q-pointer. For example:
- (Optional) Type a candidate key, and then press CTRL+V.
See Creating a super Q-pointer. For example:
- 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.