SELECT parse_cache_data.keyword, record_keyword.keyword FROM parse_cache_data,
record_keyword WHERE parse_cache_data.id = 1 AND parse_cache_data.keyword =
record_keyword.keyword; +---------+---------+ | keyword | keyword | +---------+---------+ | 689 | 689 | | 840 | 840 | | 14339 | 14339 | | 16662 | 16662 | +---------+---------+

SELECT parse_cache_data.keyword, record_keyword.keyword, record_keyword.record
FROM parse_cache_data, record_keyword WHERE parse_cache_data.id = 1 AND
parse_cache_data.keyword = record_keyword.keyword; +---------+---------+--------+ | keyword | keyword | record | +---------+---------+--------+ | 689 | 142 | 2594 | | 840 | 2750 | 8322 | | 14339 | 5083 | 20776 | | 16662 | 729 | 6192 | +---------+---------+--------+

show columns from parse_cache_data; +---------+--------------------------------------------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key |
Default | Extra | Privileges | +---------+--------------------------------------------------+------+-----+---------+-------+---------------------------------+ | id | int(10) unsigned | | MUL | 0
| | select,insert,update,references | | keyword | int(10) unsigned | | MUL | 0
| | select,insert,update,references | | value | int(10) unsigned | | | 0
| | select,insert,update,references | | status | enum('ok','new','url','phrase','ignore','alias') | | | ok
| | select,insert,update,references | +---------+--------------------------------------------------+------+-----+---------+-------+---------------------------------+ 4 rows in set (0.00 sec)

show columns from record_keyword; +---------+------------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges
| +---------+------------------+------+-----+---------+-------+---------------------------------+ | record | int(10) unsigned | | PRI | 0 | |
select,insert,update,references | | value | int(11) | | | 0 | |
select,insert,update,references | | keyword | int(10) unsigned | | PRI | 0 | |
select,insert,update,references | +---------+------------------+------+-----+---------+-------+---------------------------------+ 3 rows in set (0.00 sec)

(Tables are checked...)

Ondrej Sury: ond...@globe.cz, +420602667702 GLOBE Internet s.r.o.: http://www.globe.cz/, in...@globe.cz, +420233356502 NAJDI.TO; http://najdi.to/, in...@najdi.to

TCX Datakonsult AB, by Monty

Server version 3.23.7-alpha-log (czech encoding) Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 34 sec

Threads: 2 Questions: 3 Slow queries: 0 Opens: 8 Flush tables: 1 Open
tables: 4

System: Linux linux 2.2.13 #1 Mon Nov 22 20:42:51 CET 1999 i586 unknown Architecture: i586

Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 19991109 (Debian GNU/Linux) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='c++'
CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions
-fno-rtti' LDFLAGS='' Configure command: ./configure --enable-shared --enable-assembler
--with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock
--prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql
--datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info
--includedir=/usr/include --mandir=/usr/share/man Perl: This is perl, version 5.005_03 built for i386-linux

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail mysq...@lists.mysql.com instead.