I can't tell from a DESCRIBE output. Please post the results of SHOW
CREATE TABLE url_visit;
Thanks!
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"J S"
<vervoom@hotmail. To: SGreen@stripped
com> cc: mysql@stripped
Fax to:
06/23/2004 09:57 Subject: Re: load data into 2 tables and
set id
AM
Hi Shawn,
Here's the url_Schemes table (it's the same as the url_paths and
url_servers). This means url_scheme_ID is part of a unique constraint/key ?
mysql> desc url_schemes;
+--------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+----------------+
| ID | int(11) | | MUL | NULL | auto_increment |
| scheme | varchar(20) | | PRI | | |
+--------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> desc url_visit;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| urlid | mediumint(9) | | PRI | NULL | auto_increment |
| url_scheme_ID | int(11) | | MUL | 0 | |
| url_server_ID | int(11) | | | 0 | |
| url_path_ID | int(11) | | | 0 | |
| query | text | YES | | NULL | |
| category | varchar(50) | YES | | NULL | |
+---------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> select * from url_schemes;
+----+--------+
| ID | scheme |
+----+--------+
| 1 | http |
| 2 | tcp |
| 3 | - |
| 4 | ftp |
| 5 | https |
+----+--------+
5 rows in set (0.00 sec)
>
------ previous responses clipped for space ---------
