List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 22 2012 9:46am
Subject:Re: tables do not have the same number of columns.
View as plain text  
*plonk*

----- Original Message -----
> From: "Charles Brown" <CBrown@stripped>
> To: "Reindl Harald" <h.reindl@stripped>
> Cc: "MySql" <mysql@stripped>
> Sent: Thursday, 22 March, 2012 5:37:00 AM
> Subject: tables do not have the same number of columns.
> 
> I have two mysql instances in my mysql cluster. I noticed that their
> MysSQL.user tables do not have the same number of columns. See below
> for their attributes. Is anyone out there has any idea why these
> tables are not the same? Can someone help me.
> 
> 	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
> 
> 
> 
> Another user table
> 
> 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
> 
> 
> 
> 
> ********************************************
> 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.
> ********************************************
> 

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
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