I'm not sure if this is a bug or not, but I just realized today that some of
my create table queries (on mysql 3.23.32 ) were not behaving as I would
expect.. Example:
**********************************************************
mysql> create table foo (id int not null primary key, field1 varchar(55),
unique data_index (id,field1));
Query OK, 0 rows affected (0.04 sec)
mysql> show columns from foo;
+--------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| id | int(11) | | PRI | 0 | |
| field1 | varchar(55) | YES | | NULL | |
+--------+-------------+------+-----+---------+-------+
2 rows in set (0.02 sec)
mysql> create table bar select * from foo;
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show columns from bar;
+--------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| id | int(11) | | | 0 | |
| field1 | char(55) | YES | | NULL | |
+--------+----------+------+-----+---------+-------+
2 rows in set (0.00 sec)
***********************************************************
As you can see the primary key is not a part of table bar. Nor is the
unique index as shown with mysqldump
***********************************************************
root@raid:/home/mswanson > mysqldump -d test bar
# MySQL dump 8.12
#
# Host: localhost Database: test
#--------------------------------------------------------
# Server version 3.23.32-log
#
# Table structure for table 'bar'
#
CREATE TABLE bar (
id int(11) NOT NULL default '0',
field1 char(55) default NULL
) TYPE=MyISAM;
**************************************************************
The manual doesn't say anything about this. Is this a bug or just something
I missed in the manual?
Thanks
-Marc-
#/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
#Marc Swanson | #
#MSwanson Consulting | \|||/ #
# | /o o\ #
#Phone: (603)868-1721 |-ooo----O----ooo-#
#Fax: (603)868-1730 | Solutions in: #
#Mobile: (603)512-1267 | 'PHP 'Perl #
#[EMAIL PROTECTED] | 'SQL 'C++ #
# | 'HTML 'Sh/Csh#
#http://www.mswanson.com | 'Javascript #
#/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
---------------------------------------------------------------------
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