justin,
Friday, June 14, 2002, 4:52:12 AM, you wrote:
jc> This seems like a dumb question--sorry. Looking at my table it shows
jc> 'MUL' instead of 'PRI' like the other tables. Did I forget to code
jc> unit_id as primary? Thanks, Justin
jc> mysql> desc property_units;
jc> +----------------+-------------+------+-----+---------+----------------+
jc> | Field | Type | Null | Key | Default | Extra |
jc> +----------------+-------------+------+-----+---------+----------------+
jc> | unit_id | int(11) | | MUL | 0 | auto_increment |
jc> | property_id | int(11) | YES | | NULL | |
jc> | unit_detail_id | int(11) | YES | | NULL | |
jc> | unit_type_id | int(11) | YES | | NULL | |
jc> | date_available | varchar(20) | YES | | NULL | |
jc> +----------------+-------------+------+-----+---------+----------------+
Please, show me the output of following:
SHOW CREATE TABLE property_units;
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
