Can"t create table

Can"t create table

am 23.03.2006 13:12:47 von somebody

Hello all,

I have the following query :

CREATE TABLE IF NOT EXISTS `pm_tusers` (
`id` INTEGER NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) TYPE=InnoDB AUTO_INCREMENT=1

And I receive the following error:

ERROR NR:1005
ERROR :Can't create table 'pm_tusers.frm' (errno: 121)

If I change the name "pm_tusers" in to something like pm_tusers2
or pm2_tusers I do not receive an error an the table is created. (???)

What is wrong?

I use Window XP, php 4.x, and MySQL 5.0

Thanks in advance Rob

Re: Can"t create table

am 23.03.2006 14:38:27 von zac.carey

errno 121 means a duplicate key error so I suspect you need to add a
line at the beginning like DROP TABLE IF EXISTS