List:General Discussion« Previous MessageNext Message »
From:Nuno Tavares Date:March 22 2012 5:03am
Subject:Re: One inst has 39 columns- the other 40
View as plain text  
Charles,

You should run "SELECT @@version" on both nodes. It looks like you have 
different version' schemas.

-NT


Em 22-03-2012 04:41, Brown, Charles escreveu:
> 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