MySQL question using phpMySql

[Bijan Hemati]

It was just a silly question.

[pSouper]

can you not use phpmyAdimin for this?
it's all in the GUI. nice and easy.
not really answering your question though

[DeXXus]

How does it handle this:

Code: Select all

CREATE TABLE `puusers` ( 
`id` BIGINT(20) NOT NULL auto_increment, 
`puUsername` VARCHAR(50) NOT NULL default '', 
`puPassword` VARCHAR(50) NOT NULL default '', 
`puScreenName` VARCHAR(200) NOT NULL default '', 
`puMail` VARCHAR(255) NOT NULL default '', 
`puAdmin` TINYINT(4) NOT NULL default '0', 
PRIMARY KEY  (`id`), 
KEY (`id`),
KEY (`puAdmin`), 
KEY (`puScreenName`) 
) TYPE=MyISAM AUTO_INCREMENT=2;
INSERT INTO `puusers` 
VALUES (1, 'demo', 'demo', 'Web Demo User', 'demo@demo.com' , 1);

[Bijan Hemati]

How did you get that?

I thought I deleted it!

[DeXXus]

How did you get that?

I thought I deleted it!

I had "copied" earlier and was sitting on that page, although away from machine... didn't even check for your response until too late! LOL

[Bijan Hemati]

I think earlier version of MySQL gave these result;

KEY (`id`),
KEY (`puAdmin`),
KEY (`puScreenName`)

The newer version says INDEX Instead of KEY (I'm just guessing )

INDEX (`id`),
INDEX (`puAdmin`),
INDEX (`puScreenName`)

[DeXXus]

I think earlier version of MySQL gave these result;

KEY (`id`),
KEY (`puAdmin`),
KEY (`puScreenName`)

The newer version says INDEX Instead of KEY (I'm just guessing )

INDEX (`id`),
INDEX (`puAdmin`),
INDEX (`puScreenName`)

Ahhh! Well you must have it solved if you reetracted your original. Good for you