MySQL Tools

 MySQL Tools

Search Database Name : Usage = OARCmemberDB
Search DB Table Name : Usage = member

--------------------------------------------------------------------------------

Edit Record :            >>> DB EDIT RECORD BY ID <<<<<<<<<<<<

Add Record :            >>> DB Add Record
Delete Record :        >>> DB Delete Record
Compare Records :  >>> DB Compare Records

List DB Records :    >>> List DB Records by ID
List DB Records :    >>> List DB Records by Last Name

--------------------------------------------------------------------------------

Wild Cards = %..., ...%, %...%

ID :  Usage = id #
Lastname : Usage = lastname
Firstname : Usage = firstname
Callsign :  Usage = callsign
License :  Usage = T,G,A,E
Address : Usage = address
City :  Usage = city
State :  Usage = state (UT)
Zip : Usage = zip code (5 digits)
eMail :  Usage = email address, %...% (wild)
ARRL :  Usage = Y, N, C (comp), space (associate)
Office :  Usage = * or space
Paid :  Usage = mm/dd/yyyy, %20xx
Expire :  Usage = renew, space (other)
Phone :  Usage = phone # (xxx-xxx-xxxx)
Flag :  Usage = $ (pobox), P (paypal), A (audit)

Query :  Usage >>> 1=All members (by ID), 2=All members (by Lastname), 3=Expired members, 4=Expires 2022, 5=Expires 20xx, 6=Flagged records


Return/Abort