mysql> help; MySQL commands: help (\h) Display this text ? (\h) Synonym for `help' clear (\c) Clear command connect (\r) Reconnect to the server. Optional arguments are db and host edit (\e) Edit command with $EDITOR exit (\q) Exit mysql. Same as quit go (\g) Send command to mysql server ego (\G) Send command to mysql server; Display result vertically print (\p) Print current command quit (\q) Quit mysql rehash (\#) Rebuild completion hash status (\s) Get status information from the server use (\u) Use another database. Takes database name as argument Connection id: 382 (Can be used with mysqladmin kill) mysql> show databases; +----------+ | Database | +----------+ | example | | gmd | | gmd10 | | gmd11 | | gmd12 | | gmd13 | | gmd14 | | gmd15 | | gmd16 | | gmd17 | | gmd18 | | gmd19 | | gmd2 | | gmd20 | | gmd21 | | gmd22 | | gmd23 | | gmd24 | | gmd25 | | gmd26 | | gmd27 | | gmd28 | | gmd3 | | gmd4 | | gmd5 | | gmd6 | | gmd7 | | gmd8 | | gmd9 | | mysql | | test | | xgmd0 | | xgmd1 | | xgmd2 | | xgmd3 | | xgmd4 | | zgmd0 | | zgmd1 | | zgmd10 | | zgmd11 | | zgmd12 | | zgmd13 | | zgmd14 | | zgmd15 | | zgmd16 | | zgmd17 | | zgmd18 | | zgmd19 | | zgmd2 | | zgmd20 | | zgmd21 | | zgmd22 | | zgmd23 | | zgmd24 | | zgmd25 | | zgmd26 | | zgmd27 | | zgmd28 | | zgmd29 | | zgmd3 | | zgmd30 | | zgmd31 | | zgmd32 | | zgmd33 | | zgmd34 | | zgmd35 | | zgmd36 | | zgmd37 | | zgmd38 | | zgmd39 | | zgmd4 | | zgmd40 | | zgmd41 | | zgmd42 | | zgmd43 | | zgmd44 | | zgmd45 | | zgmd46 | | zgmd47 | | zgmd48 | | zgmd49 | | zgmd5 | | zgmd50 | | zgmd51 | | zgmd52 | | zgmd53 | | zgmd54 | | zgmd55 | | zgmd56 | | zgmd57 | | zgmd58 | | zgmd59 | | zgmd6 | | zgmd61 | | zgmd62 | | zgmd63 | | zgmd64 | | zgmd65 | | zgmd66 | | zgmd7 | | zgmd8 | | zgmd9 | +----------+ 102 rows in set (0.30 sec) mysql> use zgmd9; Database changed mysql> show tables; +--------------------------+ | Tables in zgmd9 | +--------------------------+ | Caseerror___BEGINvalues | | Caseerror___ENDvalues | | ProgramPoints | | addstr___BEGINvalues | | addstr___ENDvalues | | amatch___BEGINvalues | | amatch___ENDvalues | | change___BEGINvalues | | change___ENDvalues | | dodash___BEGINvalues | | dodash___ENDvalues | | esc___BEGINvalues | | esc___ENDvalues | | getccl___BEGINvalues | | getccl___ENDvalues | | getline___BEGINvalues | | getline___ENDvalues | | getpat___BEGINvalues | | getpat___ENDvalues | | getsub___BEGINvalues | | getsub___ENDvalues | | in_pat_set___BEGINvalues | | in_pat_set___ENDvalues | | in_set_2___BEGINvalues | | in_set_2___ENDvalues | | locate___BEGINvalues | | locate___ENDvalues | | main___BEGINvalues | | main___ENDvalues | | makepat___BEGINvalues | | makepat___ENDvalues | | makesub___BEGINvalues | | makesub___ENDvalues | | omatch___BEGINvalues | | omatch___ENDvalues | | patsize___BEGINvalues | | patsize___ENDvalues | | putsub___BEGINvalues | | putsub___ENDvalues | | stclose___BEGINvalues | | stclose___ENDvalues | | subline___BEGINvalues | | subline___ENDvalues | +--------------------------+ 43 rows in set (0.03 sec) mysql> show columns from subline___ENDvalues; +-----------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+---------+----------------+ | timestamp | bigint(21) | | MUL | 0 | auto_increment | | count | bigint(21) | | | 0 | | | value0 | blob | YES | | NULL | | | mod0 | int(11) | YES | | NULL | | | value1 | bigint(21) | YES | | NULL | | | mod1 | int(11) | YES | | NULL | | | value2 | bigint(21) | YES | | NULL | | | mod2 | int(11) | YES | | NULL | | | value3 | bigint(21) | YES | | NULL | | | mod3 | int(11) | YES | | NULL | | | value4 | bigint(21) | YES | | NULL | | | mod4 | int(11) | YES | | NULL | | | value5 | bigint(21) | YES | | NULL | | | mod5 | int(11) | YES | | NULL | | | value6 | bigint(21) | YES | | NULL | | | mod6 | int(11) | YES | | NULL | | | value7 | bigint(21) | YES | | NULL | | | mod7 | int(11) | YES | | NULL | | | value8 | bigint(21) | YES | | NULL | | | mod8 | int(11) | YES | | NULL | | +-----------+------------+------+-----+---------+----------------+ 20 rows in set (0.01 sec) mysql> select count from subline___ENDvalues; +-------+ | count | +-------+ | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | ~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~ | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | +-------+ 500 rows in set (1.37 sec) mysql> select * from subline___ENDvalues where (count = 1); +-----------+-------+--------+------+------------+------+--------+------+------------+------+--------+------+------------+------+--------+------+--------+------+--------+------+ | timestamp | count | value0 | mod0 | value1 | mod1 | value2 | mod2 | value3 | mod3 | value4 | mod4 | value5 | mod5 | value6 | mod6 | value7 | mod7 | value8 | mod8 | +-----------+-------+--------+------+------------+------+--------+------+------------+------+--------+------+------------+------+--------+------+--------+------+--------+------+ | 15 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 77 | 1 | 4026528244 | 1 | 1 | 1 | -1 | 1 | -1 | 1 | | 31 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 100 | 1 | 4026528244 | 1 | 6 | 1 | -1 | 1 | -1 | 1 | | 54 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | -126 | 1 | 4026528244 | 1 | 5 | 1 | -1 | 1 | -1 | 1 | | 66 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 96 | 1 | 4026528244 | 1 | 10 | 1 | -1 | 1 | -1 | 1 | | 90 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 123 | 1 | 4026528244 | 1 | 13 | 1 | -1 | 1 | -1 | 1 | | 106 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 62 | 1 | 4026528244 | 1 | 18 | 1 | -1 | 1 | -1 | 1 | | 108 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | -104 | 1 | 4026528244 | 1 | 7 | 1 | -1 | 1 | -1 | 1 | | 109 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 100 | 1 | 4026528244 | 1 | 20 | 1 | -1 | 1 | -1 | 1 | | 119 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 76 | 1 | 4026528244 | 1 | 8 | 1 | -1 | 1 | -1 | 1 | | 126 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 76 | 1 | 4026528244 | 1 | 6 | 1 | -1 | 1 | -1 | 1 | | 142 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 71 | 1 | 4026528244 | 1 | 7 | 1 | -1 | 1 | -1 | 1 | | 143 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 86 | 1 | 4026528244 | 1 | 6 | 1 | -1 | 1 | -1 | 1 | | 153 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 108 | 1 | 4026528244 | 1 | 20 | 1 | -1 | 1 | -1 | 1 | | 158 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 76 | 1 | 4026528244 | 1 | 12 | 1 | -1 | 1 | -1 | 1 | | 163 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 81 | 1 | 4026528244 | 1 | 12 | 1 | -1 | 1 | -1 | 1 | | 202 | 1 | | 0 | 4026528220 | 1 | 99 | 1 | 4026528228 | 1 | 43 | 1 | 4026528236 | 1 | 15 | 1 | -1 | 1 | -1 | 1 | | 245 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 88 | 1 | 4026528244 | 1 | 15 | 1 | -1 | 1 | -1 | 1 | | 273 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | 88 | 1 | 4026528244 | 1 | 3 | 1 | -1 | 1 | -1 | 1 | | 274 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | -125 | 1 | 4026528244 | 1 | 2 | 1 | -1 | 1 | -1 | 1 | | 453 | 1 | | 0 | 4026528228 | 1 | 99 | 1 | 4026528236 | 1 | -113 | 1 | 4026528244 | 1 | 6 | 1 | -1 | 1 | -1 | 1 | +-----------+-------+--------+------+------------+------+--------+------+------------+------+--------+------+------------+------+--------+------+--------+------+--------+------+ 20 rows in set (0.23 sec) mysql> show tables; +--------------------------+ | Tables in zgmd9 | +--------------------------+ | Caseerror___BEGINvalues | | Caseerror___ENDvalues | | ProgramPoints | | addstr___BEGINvalues | | addstr___ENDvalues | | amatch___BEGINvalues | | amatch___ENDvalues | | change___BEGINvalues | | change___ENDvalues | | dodash___BEGINvalues | | dodash___ENDvalues | | esc___BEGINvalues | | esc___ENDvalues | | getccl___BEGINvalues | | getccl___ENDvalues | | getline___BEGINvalues | | getline___ENDvalues | | getpat___BEGINvalues | | getpat___ENDvalues | | getsub___BEGINvalues | | getsub___ENDvalues | | in_pat_set___BEGINvalues | | in_pat_set___ENDvalues | | in_set_2___BEGINvalues | | in_set_2___ENDvalues | | locate___BEGINvalues | | locate___ENDvalues | | main___BEGINvalues | | main___ENDvalues | | makepat___BEGINvalues | | makepat___ENDvalues | | makesub___BEGINvalues | | makesub___ENDvalues | | omatch___BEGINvalues | | omatch___ENDvalues | | patsize___BEGINvalues | | patsize___ENDvalues | | putsub___BEGINvalues | | putsub___ENDvalues | | stclose___BEGINvalues | | stclose___ENDvalues | | subline___BEGINvalues | | subline___ENDvalues | +--------------------------+ 43 rows in set (0.03 sec) mysql> select * from ProgramPoints; +--------------------+---------+---------------------------------------------------------------------------------+---------------------------------------------------------------------------------+---------------------------------------------------------+ | ppname | numargs | vnames | vtypes | vcomparables | +--------------------+---------+---------------------------------------------------------------------------------+---------------------------------------------------------------------------------+---------------------------------------------------------+ | getline___BEGIN | 3 | *s | char | 22 | | getline___END | 5 | *s | char | 22 | | addstr___BEGIN | 6 | c | char | 25 | | addstr___END | 7 | c | char | 25 | | esc___BEGIN | 4 | s[] | char[] | 30[] | | esc___END | 5 | s[] | char[] | 30[] | | dodash___BEGIN | 10 | delim | char | 36 | | dodash___END | 13 | delim | char | 36 | | getccl___BEGIN | 8 | arg[] | char[] | 45[] | | getccl___END | 10 | arg[] | char[] | 45[] | | stclose___BEGIN | 5 | pat[] | char[] | 48[] | | stclose___END | 8 | pat[] | char[] | 48[] | | in_set_2___BEGIN | 1 | c | char | 54 | | in_set_2___END | 1 | c | char | 54 | | in_pat_set___BEGIN | 1 | c | char | 55 | | in_pat_set___END | 1 | c | char | 55 | | makepat___BEGIN | 6 | arg[] | char[] | 63[] | | makepat___END | 15 | arg[] | char[] | 63[] | | getpat___BEGIN | 4 | *arg | char | 70 | | getpat___END | 5 | *arg | char | 70 | | makesub___BEGIN | 6 | arg[] | char[] | 75[] | | makesub___END | 11 | arg[] | char[] | 75[] | | getsub___BEGIN | 4 | *arg | char | 82 | | getsub___END | 5 | *arg | char | 82 | | locate___BEGIN | 4 | c | char | 85 | | locate___END | 6 | c | char | 85 | | omatch___BEGIN | 7 | lin[] | char[] | 92[] | | omatch___END | 9 | lin[] | char[] | 92[] | | patsize___BEGIN | 3 | pat[] | char[] | 96[] | | patsize___END | 4 | pat[] | char[] | 96[] | | amatch___BEGIN | 6 | lin[] | char[] | 99[] | | amatch___END | 10 | lin[] | char[] | 99[] | | putsub___BEGIN | 6 | lin[] | char[] | 107[] | | putsub___END | 8 | lin[] | char[] | 107[] | | subline___BEGIN | 6 | lin[] | char[] | 114[] | | subline___END | 9 | lin[] | char[] | 114[] | | change___BEGIN | 4 | *pat | char | 119 | | change___END | 7 | *pat | char | 119 | | main___BEGIN | 0 | | | | | main___END | 5 | pat[] | char[] | 123[] | | Caseerror___BEGIN | 1 | n | int | 95 | | Caseerror___END | 1 | n | int | 95 | +--------------------+---------+---------------------------------------------------------------------------------+---------------------------------------------------------------------------------+---------------------------------------------------------+ 42 rows in set (0.15 sec) mysql>