Forum Moderators: coopster

Message Too Old, No Replies

Purplish color in phpMyAdmin

         

ramoneguru

8:17 am on Mar 26, 2005 (gmt 0)

10+ Year Member



My first post...ok, so I ran a simple create table in the SQL window of phpMyAdmin ver. 2.6.0-pl3

CREATE TABLE some
(Password VARCHAR(50),
Status VARCHAR(2) );

It runs fine and creates the table with those fields, but the Password and Status fields are highlighted the same color as CREATE and TABLE.

Then I ran this query:

CREATE TABLE someThing
(Pword VARCHAR(50),
Stat VARCHAR(2) );

The fields were no longer highlighted the same color as CREATE and TABLE

Password and Status aren't reserved words, but is this something to be concerned about or am I just being paranoid? I haven't seen anything in the documentation about this....

dreamcatcher

11:03 am on Mar 26, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi ramoneguru, welcome to WebmasterWorld. :)

Status and Password are indeed MySQL reserved words, so nothing to worry about.

dc

ramoneguru

8:46 pm on Mar 26, 2005 (gmt 0)

10+ Year Member



Dang it, oh well I guess they can always be Pword and Stat....

Thanks for the info