List:General Discussion« Previous MessageNext Message »
From:Charles Brown Date:March 22 2012 4:41am
Subject:RE: One inst has 39 columns- the other 40
View as plain text  
Look man, there has to be someone out there that can tell me why one user table has 5
extra columns. Is it version related or my sysprog person missed out on a step. Its hard
to believe that this problem is unique to my site. 

Host	char(60)	NO	PRI	
User	char(16)	NO	PRI	
Password	char(41)	NO		
Select_priv	enum('N','Y')	NO		N
Insert_priv	enum('N','Y')	NO		N
Update_priv	enum('N','Y')	NO		N
Delete_priv	enum('N','Y')	NO		N
Create_priv	enum('N','Y')	NO		N
Drop_priv	enum('N','Y')	NO		N
Reload_priv	enum('N','Y')	NO		N
Shutdown_priv	enum('N','Y')	NO		N
Process_priv	enum('N','Y')	NO		N
File_priv	enum('N','Y')	NO		N
Grant_priv	enum('N','Y')	NO		N
References_priv	enum('N','Y')	NO		N
Index_priv	enum('N','Y')	NO		N
Alter_priv	enum('N','Y')	NO		N
Show_db_priv	enum('N','Y')	NO		N
Super_priv	enum('N','Y')	NO		N
Create_tmp_table_priv	enum('N','Y')	NO		N
Lock_tables_priv	enum('N','Y')	NO		N
Execute_priv	enum('N','Y')	NO		N
Repl_slave_priv	enum('N','Y')	NO		N
Repl_client_priv	enum('N','Y')	NO		N
Create_view_priv	enum('N','Y')	NO		N
Show_view_priv	enum('N','Y')	NO		N
Create_routine_priv	enum('N','Y')	NO		N
Alter_routine_priv	enum('N','Y')	NO		N
Create_user_priv	enum('N','Y')	NO		N
Event_priv	enum('N','Y')	NO		N
Trigger_priv	enum('N','Y')	NO		N
Create_tablespace_priv	enum('N','Y')	NO		N
ssl_type	enum('','ANY','X509','SPECIFIED')	NO		
ssl_cipher	blob	NO		
x509_issuer	blob	NO		
x509_subject	blob	NO		
max_questions	int(11) unsigned	NO		0
max_updates	int(11) unsigned	NO		0
max_connections	int(11) unsigned	NO		0
max_user_connections	int(11) unsigned	NO		0
plugin	char(64)	YES		
authentication_string	text	YES		

----
	Host	char(60)	NO			
	User	char(16)	NO			
	Password	char(41)	NO			
	Select_priv	enum('N','Y')	NO		N	
	Insert_priv	enum('N','Y')	NO		N	
	Update_priv	enum('N','Y')	NO		N	
	Delete_priv	enum('N','Y')	NO		N	
	Create_priv	enum('N','Y')	NO		N	
	Drop_priv	enum('N','Y')	NO		N	
	Reload_priv	enum('N','Y')	NO		N	
	Shutdown_priv	enum('N','Y')	NO		N	
	Process_priv	enum('N','Y')	NO		N	
	File_priv	enum('N','Y')	NO		N	
	Grant_priv	enum('N','Y')	NO		N	
	References_priv	enum('N','Y')	NO		N	
	Index_priv	enum('N','Y')	NO		N	
	Alter_priv	enum('N','Y')	NO		N	
	Show_db_priv	enum('N','Y')	NO		N	
	Super_priv	enum('N','Y')	NO		N	
	Create_tmp_table_priv	enum('N','Y')	NO		N	
	Lock_tables_priv	enum('N','Y')	NO		N	
	Execute_priv	enum('N','Y')	NO		N	
	Repl_slave_priv	enum('N','Y')	NO		N	
	Repl_client_priv	enum('N','Y')	NO		N	
	Create_view_priv	enum('N','Y')	NO		N	
	Show_view_priv	enum('N','Y')	NO		N	
	Create_routine_priv	enum('N','Y')	NO		N	
	Alter_routine_priv	enum('N','Y')	NO		N	
	Create_user_priv	enum('N','Y')	NO		N	
	ssl_type	enum('','ANY','X509','SPECIFIED')	NO			
	ssl_cipher	blob	NO			
	x509_issuer	blob	NO			
	x509_subject	blob	NO			
	max_questions	int(11) unsigned	NO		0	
	max_updates	int(11) unsigned	NO		0	
	max_connections	int(11) unsigned	NO		0	
	max_user_connections	int(11) unsigned	NO		0	




-----Original Message-----
From: Rik Wasmus [mailto:rik@stripped] 
Sent: Wednesday, March 21, 2012 5:08 AM
To: mysql@stripped
Subject: Re: One inst has 39 columns- the other 40

> You keep repeating that, and I already replied to it the first time. 
> If my answer isn't acceptable, spamming the question isn't going to 
> make it better - or make people more inclined to help you, for that matter.

I concur
--
Rik Wasmus

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************
Thread
date comparison querySimon Wilkinson16 Mar
  • Re: date comparison queryBaron Schwartz16 Mar
  • Re: date comparison queryhsv17 Mar
    • One inst has 39 columns- the other 40Charles Brown18 Mar
      • Re: One inst has 39 columns- the other 40Johan De Meersman19 Mar
  • One inst has 39 columns- the other 40Charles Brown19 Mar
  • RE: One inst has 39 columns- the other 40Charles Brown21 Mar
    • Re: One inst has 39 columns- the other 40Johan De Meersman21 Mar
      • Re: One inst has 39 columns- the other 40Rik Wasmus21 Mar
        • RE: One inst has 39 columns- the other 40Charles Brown22 Mar
          • Re: One inst has 39 columns- the other 40Nuno Tavares22 Mar
            • Re: One inst has 39 columns- the other 40Michael Dykman22 Mar
          • Re: One inst has 39 columns- the other 40Reindl Harald22 Mar
            • RE: One inst has 39 columns- the other 40Charles Brown22 Mar
          • Re: One inst has 39 columns- the other 40Mark Goodge22 Mar
    • Re: One inst has 39 columns- the other 40Reindl Harald21 Mar
      • tables do not have the same number of columns. Charles Brown22 Mar
        • Re: tables do not have the same number of columns.Johan De Meersman22 Mar