phpMyAdmin 3.0.0

[Guest]

David,

I'm going through PHP Solutions, am on page 295 and when I am presented with the tabel definition page, WOW is it different than the screenshot in the book. The page in v3.0.0 is missing the following settings choices:
Extra (so nowhere to stipulate 'auto increment)
Primary Key (see comment on 'Index' setting)

Null has been changed from a drop-down menu to one checkbox. I assume that by leaving the box unchecked, one assigns 'not null".

A drop-down menu is available next to a setting called 'Index' The menu has 4 choices, Primary, Unique, Index, Full Text. Do I assume correctly that by choosing Primary, this is the same as checking the Primary Key box in the earlier version of phpMyAdmin?

I did check your site and the Friends of ED site this time and didn't see any notations to this, but I did read your blog entry about the installation procedure changes in the pre-V3.0.0 version.

Should I remove V3.0.0 and get an earlier version to minimize issues such as this?

Many huge thanks, as always!

Sincerely,

Wordman

[Newsgroup_User]

Wordman-GL wrote:
> The page in v3.0.0 is missing the following settings choices:
> Extra (so nowhere to stipulate 'auto increment)
> Primary Key (see comment on 'Index' setting)

Auto_increment is now the A_I checkbox.
Primary key is in the Index drop-down - select PRIMARY.

> Null has been changed from a drop-down menu to one checkbox. I assume that by
> leaving the box unchecked, one assigns 'not null".

Yes.

> Do I assume correctly that by
> choosing Primary, this is the same as checking the Primary Key box in the
> earlier version of phpMyAdmin?

Yes.

> Should I remove V3.0.0 and get an earlier version to minimize issues such as
> this?

The changes are fairly minimal, so you should be OK with version 3.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[Guest · Accepted solution]

Crikey...this sort of thing can make one go batty. Thanks a million for that!

I see that now, although the 'extra' setting is missing on that page, it does show up once you save the settings, and indeed, after checking the AI box (damn engineers...) the 'extra' box in the query page does indeed now say 'auto_increment'

Thanks and CHEERS!!!

Wordman

[Newsgroup_User]

Wordman-GL wrote:
> Crikey...this sort of thing can make one go batty. Thanks a million for that!

Thanks for alerting me to the fact that phpMyAdmin 3.0 has now been
released. My book about Dreamweaver CS4 (due out in December) uses
phpMyAdmin 3.0, but it was only in beta when I last looked.

I have now added details of the changes to my website:

http://foundationphp.com/blog/2008/10/05/changes-in-phpmyadmin-30/

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/