~drizzle-trunk/drizzle/development

/* Copyright (C) 2000-2008 MySQL AB

   This program is free software; you can redistribute it and/or modify

   it under the terms of the GNU General Public License as published by

   the Free Software Foundation; version 2 of the License.

   This program is distributed in the hope that it will be useful,

   but WITHOUT ANY WARRANTY; without even the implied warranty of

   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License

   along with this program; if not, write to the Free Software

   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */

/* mysql command tool

 * Commands compatible with mSQL by David J. Hughes

 *

 * Written by:

 *   Michael 'Monty' Widenius

 *   Andi Gutmans  <andi@zend.com>

 *   Zeev Suraski  <zeev@zend.com>

 *   Jani Tolonen  <jani@mysql.com>

 *   Matt Wagner   <matt@mysql.com>

 *   Jeremy Cole   <jcole@mysql.com>

 *   Tonu Samuel   <tonu@mysql.com>

 *   Harrison Fisk <harrison@mysql.com>

 *

 **/

#include "client_priv.h"

#include <m_ctype.h>

#include <stdarg.h>

#include <my_dir.h>

#ifndef __GNU_LIBRARY__

#define __GNU_LIBRARY__		      // Skip warnings in getopt.h

#endif

#include "my_readline.h"

#include <signal.h>

#include <violite.h>

#if defined(USE_LIBEDIT_INTERFACE) && defined(HAVE_LOCALE_H)

#include <locale.h>

#endif

const char *VER= "14.14";

/* Don't try to make a nice table if the data is too big */

#define MAX_COLUMN_LENGTH	     1024

/* Buffer to hold 'version' and 'version_comment' */

#define MAX_SERVER_VERSION_LENGTH     128

/* Array of options to pass to libemysqld */

#define MAX_SERVER_ARGS               64

void* sql_alloc(unsigned size);	     // Don't use mysqld alloc for these

void sql_element_free(void *ptr);

#include "sql_string.h"

extern "C" {

#if defined(HAVE_CURSES_H) && defined(HAVE_TERM_H)

#include <curses.h>

#include <term.h>

#else

#if defined(HAVE_TERMIOS_H)

#include <termios.h>

#include <unistd.h>

#elif defined(HAVE_TERMBITS_H)

#include <termbits.h>

#elif defined(HAVE_ASM_TERMBITS_H) && (!defined __GLIBC__ || !(__GLIBC__ > 2 || __GLIBC__ == 2 && __GLIBC_MINOR__ > 0))

#include <asm/termbits.h>		// Standard linux

#endif

#undef VOID

#if defined(HAVE_TERMCAP_H)

#include <termcap.h>

#else

#ifdef HAVE_CURSES_H

#include <curses.h>

#endif

#undef SYSV				// hack to avoid syntax error

#ifdef HAVE_TERM_H

#include <term.h>

#endif

#endif

#endif

#undef bcmp				// Fix problem with new readline

#include <readline/readline.h>

#define HAVE_READLINE

  //int vidattr(long unsigned int attrs);	// Was missing in sun curses

}

#if !defined(HAVE_VIDATTR)

#undef vidattr

#define vidattr(A) {}			// Can't get this to work

#endif

#ifdef FN_NO_CASE_SENCE

#define cmp_database(cs,A,B) my_strcasecmp((cs), (A), (B))

#else

#define cmp_database(cs,A,B) strcmp((A),(B))

#endif

#if !defined(THREAD)

#define USE_POPEN

#endif

#include "completion_hash.h"

#define PROMPT_CHAR '\\'

#define DEFAULT_DELIMITER ";"

typedef struct st_status

{

  int exit_status;

  ulong query_start_line;

  char *file_name;

  LINE_BUFFER *line_buff;

  bool batch,add_to_history;

} STATUS;

static HashTable ht;

static char **defaults_argv;

enum enum_info_type { INFO_INFO,INFO_ERROR,INFO_RESULT};

typedef enum enum_info_type INFO_TYPE;

static MYSQL mysql;			/* The connection */

static my_bool ignore_errors=0,wait_flag=0,quick=0,

               connected=0,opt_raw_data=0,unbuffered=0,output_tables=0,

	       opt_rehash=1,skip_updates=0,safe_updates=0,one_database=0,

	       opt_compress=0, using_opt_local_infile=0,

	       vertical=0, line_numbers=1, column_names=1,opt_html=0,

               opt_xml=0,opt_nopager=1, opt_outfile=0, named_cmds= 0,

	       tty_password= 0, opt_nobeep=0, opt_reconnect=1,

	       default_charset_used= 0, opt_secure_auth= 0,

               default_pager_set= 0, opt_sigint_ignore= 0,

               auto_vertical_output= 0,

               show_warnings= 0, executing_query= 0, interrupted_query= 0;

static my_bool debug_info_flag, debug_check_flag;

static my_bool column_types_flag;

static my_bool preserve_comments= 0;

static ulong opt_max_allowed_packet, opt_net_buffer_length;

static uint verbose=0,opt_silent=0,opt_mysql_port=0, opt_local_infile=0;

static uint my_end_arg;

static char * opt_mysql_unix_port=0;

static int connect_flag=CLIENT_INTERACTIVE;

static char *current_host,*current_db,*current_user=0,*opt_password=0,

            *current_prompt=0, *delimiter_str= 0,

            *default_charset= (char*) MYSQL_DEFAULT_CHARSET_NAME;

static char *histfile;

static char *histfile_tmp;

static String glob_buffer,old_buffer;

static String processed_prompt;

static char *full_username=0,*part_username=0,*default_prompt=0;

static int wait_time = 5;

static STATUS status;

static ulong select_limit,max_join_size,opt_connect_timeout=0;

static char mysql_charsets_dir[FN_REFLEN+1];

static const char *xmlmeta[] = {

  "&", "&",

  "<", "&lt;",

  ">", ">",

  "\"", """,

  0, 0

};

static const char *day_names[]={"Sun","Mon","Tue","Wed","Thu","Fri","Sat"};

static const char *month_names[]={"Jan","Feb","Mar","Apr","May","Jun","Jul",

			    "Aug","Sep","Oct","Nov","Dec"};

static char default_pager[FN_REFLEN];

static char pager[FN_REFLEN], outfile[FN_REFLEN];

static FILE *PAGER, *OUTFILE;

static MEM_ROOT hash_mem_root;

static uint prompt_counter;

static char delimiter[16]= DEFAULT_DELIMITER;

static uint delimiter_length= 1;

unsigned short terminal_width= 80;

#ifdef HAVE_SMEM

static char *shared_memory_base_name=0;

#endif

static uint opt_protocol= MYSQL_PROTOCOL_TCP;

static CHARSET_INFO *charset_info= &my_charset_latin1;

const char *default_dbug_option="d:t:o,/tmp/mysql.trace";

void tee_fprintf(FILE *file, const char *fmt, ...);

void tee_fputs(const char *s, FILE *file);

void tee_puts(const char *s, FILE *file);

void tee_putc(int c, FILE *file);

static void tee_print_sized_data(const char *, unsigned int, unsigned int, bool);

/* The names of functions that actually do the manipulation. */

static int get_options(int argc,char **argv);

extern "C" my_bool get_one_option(int optid, const struct my_option *opt,

                                  char *argument);

static int com_quit(String *str,char*),

	   com_go(String *str,char*), com_ego(String *str,char*),

	   com_print(String *str,char*),

	   com_help(String *str,char*), com_clear(String *str,char*),

	   com_connect(String *str,char*), com_status(String *str,char*),

	   com_use(String *str,char*), com_source(String *str, char*),

	   com_rehash(String *str, char*), com_tee(String *str, char*),

           com_notee(String *str, char*), com_charset(String *str,char*),

           com_prompt(String *str, char*), com_delimiter(String *str, char*),

     com_warnings(String *str, char*), com_nowarnings(String *str, char*);

#ifdef USE_POPEN

static int com_nopager(String *str, char*), com_pager(String *str, char*),

           com_edit(String *str,char*), com_shell(String *str, char *);

#endif

static int read_and_execute(bool interactive);

static int sql_connect(char *host,char *database,char *user,char *password,

		       uint silent);

static const char *server_version_string(MYSQL *mysql);

static int put_info(const char *str,INFO_TYPE info,uint error=0,

		    const char *sql_state=0);

static int put_error(MYSQL *mysql);

static void safe_put_field(const char *pos,ulong length);

static void xmlencode_print(const char *src, uint length);

static void init_pager();

static void end_pager();

static void init_tee(const char *);

static void end_tee();

static const char* construct_prompt();

static char *get_arg(char *line, my_bool get_next_arg);

static void init_username();

static void add_int_to_prompt(int toadd);

static int get_result_width(MYSQL_RES *res);

static int get_field_disp_length(MYSQL_FIELD * field);

/* A structure which contains information on the commands this program

   can understand. */

typedef struct {

  const char *name;		/* User printable name of the function. */

  char cmd_char;		/* msql command character */

  int (*func)(String *str,char *); /* Function to call to do the job. */

  bool takes_params;		/* Max parameters for command */

  const char *doc;		/* Documentation for this function.  */

} COMMANDS;

static COMMANDS commands[] = {

  { "?",      '?', com_help,   1, "Synonym for `help'." },

  { "clear",  'c', com_clear,  0, "Clear command."},

  { "connect",'r', com_connect,1,

    "Reconnect to the server. Optional arguments are db and host." },

  { "delimiter", 'd', com_delimiter,    1,

    "Set statement delimiter. NOTE: Takes the rest of the line as new delimiter." },

#ifdef USE_POPEN

  { "edit",   'e', com_edit,   0, "Edit command with $EDITOR."},

#endif

  { "ego",    'G', com_ego,    0,

    "Send command to mysql server, display result vertically."},

  { "exit",   'q', com_quit,   0, "Exit mysql. Same as quit."},

  { "go",     'g', com_go,     0, "Send command to mysql server." },

  { "help",   'h', com_help,   1, "Display this help." },

#ifdef USE_POPEN

  { "nopager",'n', com_nopager,0, "Disable pager, print to stdout." },

#endif

  { "notee",  't', com_notee,  0, "Don't write into outfile." },

#ifdef USE_POPEN

  { "pager",  'P', com_pager,  1, 

    "Set PAGER [to_pager]. Print the query results via PAGER." },

#endif

  { "print",  'p', com_print,  0, "Print current command." },

  { "prompt", 'R', com_prompt, 1, "Change your mysql prompt."},

  { "quit",   'q', com_quit,   0, "Quit mysql." },

  { "rehash", '#', com_rehash, 0, "Rebuild completion hash." },

  { "source", '.', com_source, 1,

    "Execute an SQL script file. Takes a file name as an argument."},

  { "status", 's', com_status, 0, "Get status information from the server."},

#ifdef USE_POPEN

  { "system", '!', com_shell,  1, "Execute a system shell command."},

#endif

  { "tee",    'T', com_tee,    1, 

    "Set outfile [to_outfile]. Append everything into given outfile." },

  { "use",    'u', com_use,    1,

    "Use another database. Takes database name as argument." },

  { "charset",    'C', com_charset,    1,

    "Switch to another charset. Might be needed for processing binlog with multi-byte charsets." },

  { "warnings", 'W', com_warnings,  0,

    "Show warnings after every statement." },

  { "nowarning", 'w', com_nowarnings, 0,

    "Don't show warnings after every statement." },

  /* Get bash-like expansion for some commands */

  { "create table",     0, 0, 0, ""},

  { "create database",  0, 0, 0, ""},

  { "show databases",   0, 0, 0, ""},

  { "show fields from", 0, 0, 0, ""},

  { "show keys from",   0, 0, 0, ""},

  { "show tables",      0, 0, 0, ""},

  { "load data from",   0, 0, 0, ""},

  { "alter table",      0, 0, 0, ""},

  { "set option",       0, 0, 0, ""},

  { "lock tables",      0, 0, 0, ""},

  { "unlock tables",    0, 0, 0, ""},

  /* generated 2006-12-28.  Refresh occasionally from lexer. */

  { "ACTION", 0, 0, 0, ""},

  { "ADD", 0, 0, 0, ""},

  { "AFTER", 0, 0, 0, ""},

  { "AGAINST", 0, 0, 0, ""},

  { "AGGREGATE", 0, 0, 0, ""},

  { "ALL", 0, 0, 0, ""},

  { "ALGORITHM", 0, 0, 0, ""},

  { "ALTER", 0, 0, 0, ""},

  { "ANALYZE", 0, 0, 0, ""},

  { "AND", 0, 0, 0, ""},

  { "ANY", 0, 0, 0, ""},

  { "AS", 0, 0, 0, ""},

  { "ASC", 0, 0, 0, ""},

  { "ASCII", 0, 0, 0, ""},

  { "ASENSITIVE", 0, 0, 0, ""},

  { "AUTO_INCREMENT", 0, 0, 0, ""},

  { "AVG", 0, 0, 0, ""},

  { "AVG_ROW_LENGTH", 0, 0, 0, ""},

  { "BACKUP", 0, 0, 0, ""},

  { "BDB", 0, 0, 0, ""},

  { "BEFORE", 0, 0, 0, ""},

  { "BEGIN", 0, 0, 0, ""},

  { "BERKELEYDB", 0, 0, 0, ""},

  { "BETWEEN", 0, 0, 0, ""},

  { "BIGINT", 0, 0, 0, ""},

  { "BINARY", 0, 0, 0, ""},

  { "BINLOG", 0, 0, 0, ""},

  { "BIT", 0, 0, 0, ""},

  { "BLOB", 0, 0, 0, ""},

  { "BOOL", 0, 0, 0, ""},

  { "BOOLEAN", 0, 0, 0, ""},

  { "BOTH", 0, 0, 0, ""},

  { "BTREE", 0, 0, 0, ""},

  { "BY", 0, 0, 0, ""},

  { "BYTE", 0, 0, 0, ""},

  { "CACHE", 0, 0, 0, ""},

  { "CALL", 0, 0, 0, ""},

  { "CASCADE", 0, 0, 0, ""},

  { "CASCADED", 0, 0, 0, ""},

  { "CASE", 0, 0, 0, ""},

  { "CHAIN", 0, 0, 0, ""},

  { "CHANGE", 0, 0, 0, ""},

  { "CHANGED", 0, 0, 0, ""},

  { "CHAR", 0, 0, 0, ""},

  { "CHARACTER", 0, 0, 0, ""},

  { "CHARSET", 0, 0, 0, ""},

  { "CHECK", 0, 0, 0, ""},

  { "CHECKSUM", 0, 0, 0, ""},

  { "CIPHER", 0, 0, 0, ""},

  { "CLIENT", 0, 0, 0, ""},

  { "CLOSE", 0, 0, 0, ""},

  { "CODE", 0, 0, 0, ""},

  { "COLLATE", 0, 0, 0, ""},

  { "COLLATION", 0, 0, 0, ""},

  { "COLUMN", 0, 0, 0, ""},

  { "COLUMNS", 0, 0, 0, ""},

  { "COMMENT", 0, 0, 0, ""},

  { "COMMIT", 0, 0, 0, ""},

  { "COMMITTED", 0, 0, 0, ""},

  { "COMPACT", 0, 0, 0, ""},

  { "COMPRESSED", 0, 0, 0, ""},

  { "CONCURRENT", 0, 0, 0, ""},

  { "CONDITION", 0, 0, 0, ""},

  { "CONNECTION", 0, 0, 0, ""},

  { "CONSISTENT", 0, 0, 0, ""},

  { "CONSTRAINT", 0, 0, 0, ""},

  { "CONTAINS", 0, 0, 0, ""},

  { "CONTINUE", 0, 0, 0, ""},

  { "CONVERT", 0, 0, 0, ""},

  { "CREATE", 0, 0, 0, ""},

  { "CROSS", 0, 0, 0, ""},

  { "CUBE", 0, 0, 0, ""},

  { "CURRENT_DATE", 0, 0, 0, ""},

  { "CURRENT_TIME", 0, 0, 0, ""},

  { "CURRENT_TIMESTAMP", 0, 0, 0, ""},

  { "CURRENT_USER", 0, 0, 0, ""},

  { "CURSOR", 0, 0, 0, ""},

  { "DATA", 0, 0, 0, ""},

  { "DATABASE", 0, 0, 0, ""},

  { "DATABASES", 0, 0, 0, ""},

  { "DATE", 0, 0, 0, ""},

  { "DATETIME", 0, 0, 0, ""},

  { "DAY", 0, 0, 0, ""},

  { "DAY_HOUR", 0, 0, 0, ""},

  { "DAY_MICROSECOND", 0, 0, 0, ""},

  { "DAY_MINUTE", 0, 0, 0, ""},

  { "DAY_SECOND", 0, 0, 0, ""},

  { "DEALLOCATE", 0, 0, 0, ""},     

  { "DEC", 0, 0, 0, ""},

  { "DECIMAL", 0, 0, 0, ""},

  { "DECLARE", 0, 0, 0, ""},

  { "DEFAULT", 0, 0, 0, ""},

  { "DEFINER", 0, 0, 0, ""},

  { "DELAYED", 0, 0, 0, ""},

  { "DELAY_KEY_WRITE", 0, 0, 0, ""},

  { "DELETE", 0, 0, 0, ""},

  { "DESC", 0, 0, 0, ""},

  { "DESCRIBE", 0, 0, 0, ""},

  { "DES_KEY_FILE", 0, 0, 0, ""},

  { "DETERMINISTIC", 0, 0, 0, ""},

  { "DIRECTORY", 0, 0, 0, ""},

  { "DISABLE", 0, 0, 0, ""},

  { "DISCARD", 0, 0, 0, ""},

  { "DISTINCT", 0, 0, 0, ""},

  { "DISTINCTROW", 0, 0, 0, ""},

  { "DIV", 0, 0, 0, ""},

  { "DO", 0, 0, 0, ""},

  { "DOUBLE", 0, 0, 0, ""},

  { "DROP", 0, 0, 0, ""},

  { "DUAL", 0, 0, 0, ""},

  { "DUMPFILE", 0, 0, 0, ""},

  { "DUPLICATE", 0, 0, 0, ""},

  { "DYNAMIC", 0, 0, 0, ""},

  { "EACH", 0, 0, 0, ""},

  { "ELSE", 0, 0, 0, ""},

  { "ELSEIF", 0, 0, 0, ""},

  { "ENABLE", 0, 0, 0, ""},

  { "ENCLOSED", 0, 0, 0, ""},

  { "END", 0, 0, 0, ""},

  { "ENGINE", 0, 0, 0, ""},

  { "ENGINES", 0, 0, 0, ""},

  { "ENUM", 0, 0, 0, ""},

  { "ERRORS", 0, 0, 0, ""},

  { "ESCAPE", 0, 0, 0, ""},

  { "ESCAPED", 0, 0, 0, ""},

  { "EVENTS", 0, 0, 0, ""},

  { "EXECUTE", 0, 0, 0, ""},

  { "EXISTS", 0, 0, 0, ""},

  { "EXIT", 0, 0, 0, ""},

  { "EXPANSION", 0, 0, 0, ""},

  { "EXPLAIN", 0, 0, 0, ""},

  { "EXTENDED", 0, 0, 0, ""},

  { "FALSE", 0, 0, 0, ""},

  { "FAST", 0, 0, 0, ""},

  { "FETCH", 0, 0, 0, ""},

  { "FIELDS", 0, 0, 0, ""},

  { "FILE", 0, 0, 0, ""},

  { "FIRST", 0, 0, 0, ""},

  { "FIXED", 0, 0, 0, ""},

  { "FLOAT", 0, 0, 0, ""},

  { "FLOAT4", 0, 0, 0, ""},

  { "FLOAT8", 0, 0, 0, ""},

  { "FLUSH", 0, 0, 0, ""},

  { "FOR", 0, 0, 0, ""},

  { "FORCE", 0, 0, 0, ""},

  { "FOREIGN", 0, 0, 0, ""},

  { "FOUND", 0, 0, 0, ""},

  { "FRAC_SECOND", 0, 0, 0, ""},

  { "FROM", 0, 0, 0, ""},

  { "FULL", 0, 0, 0, ""},

  { "FULLTEXT", 0, 0, 0, ""},

  { "FUNCTION", 0, 0, 0, ""},

  { "GEOMETRY", 0, 0, 0, ""},

  { "GEOMETRYCOLLECTION", 0, 0, 0, ""},

  { "GET_FORMAT", 0, 0, 0, ""},

  { "GLOBAL", 0, 0, 0, ""},

  { "GRANT", 0, 0, 0, ""},

  { "GRANTS", 0, 0, 0, ""},

  { "GROUP", 0, 0, 0, ""},

  { "HANDLER", 0, 0, 0, ""},

  { "HASH", 0, 0, 0, ""},

  { "HAVING", 0, 0, 0, ""},

  { "HELP", 0, 0, 0, ""},

  { "HIGH_PRIORITY", 0, 0, 0, ""},

  { "HOSTS", 0, 0, 0, ""},

  { "HOUR", 0, 0, 0, ""},

  { "HOUR_MICROSECOND", 0, 0, 0, ""},

  { "HOUR_MINUTE", 0, 0, 0, ""},

  { "HOUR_SECOND", 0, 0, 0, ""},

  { "IDENTIFIED", 0, 0, 0, ""},

  { "IF", 0, 0, 0, ""},

  { "IGNORE", 0, 0, 0, ""},

  { "IMPORT", 0, 0, 0, ""},

  { "IN", 0, 0, 0, ""},

  { "INDEX", 0, 0, 0, ""},

  { "INDEXES", 0, 0, 0, ""},

  { "INFILE", 0, 0, 0, ""},

  { "INNER", 0, 0, 0, ""},

  { "INNOBASE", 0, 0, 0, ""},

  { "INNODB", 0, 0, 0, ""},

  { "INOUT", 0, 0, 0, ""},

  { "INSENSITIVE", 0, 0, 0, ""},

  { "INSERT", 0, 0, 0, ""},

  { "INSERT_METHOD", 0, 0, 0, ""},

  { "INT", 0, 0, 0, ""},

  { "INT1", 0, 0, 0, ""},

  { "INT2", 0, 0, 0, ""},

  { "INT3", 0, 0, 0, ""},

  { "INT4", 0, 0, 0, ""},

  { "INT8", 0, 0, 0, ""},

  { "INTEGER", 0, 0, 0, ""},

  { "INTERVAL", 0, 0, 0, ""},

  { "INTO", 0, 0, 0, ""},

  { "IO_THREAD", 0, 0, 0, ""},

  { "IS", 0, 0, 0, ""},

  { "ISOLATION", 0, 0, 0, ""},

  { "ISSUER", 0, 0, 0, ""},

  { "ITERATE", 0, 0, 0, ""},

  { "INVOKER", 0, 0, 0, ""},

  { "JOIN", 0, 0, 0, ""},

  { "KEY", 0, 0, 0, ""},

  { "KEYS", 0, 0, 0, ""},

  { "KILL", 0, 0, 0, ""},

  { "LANGUAGE", 0, 0, 0, ""},

  { "LAST", 0, 0, 0, ""},

  { "LEADING", 0, 0, 0, ""},

  { "LEAVE", 0, 0, 0, ""},

  { "LEAVES", 0, 0, 0, ""},

  { "LEFT", 0, 0, 0, ""},

  { "LEVEL", 0, 0, 0, ""},

  { "LIKE", 0, 0, 0, ""},

  { "LIMIT", 0, 0, 0, ""},

  { "LINES", 0, 0, 0, ""},

  { "LINESTRING", 0, 0, 0, ""},

  { "LOAD", 0, 0, 0, ""},

  { "LOCAL", 0, 0, 0, ""},

  { "LOCALTIME", 0, 0, 0, ""},

  { "LOCALTIMESTAMP", 0, 0, 0, ""},

  { "LOCK", 0, 0, 0, ""},

  { "LOCKS", 0, 0, 0, ""},

  { "LOGS", 0, 0, 0, ""},

  { "LONG", 0, 0, 0, ""},

  { "LONGBLOB", 0, 0, 0, ""},

  { "LONGTEXT", 0, 0, 0, ""},

  { "LOOP", 0, 0, 0, ""},

  { "LOW_PRIORITY", 0, 0, 0, ""},

  { "MASTER", 0, 0, 0, ""},

  { "MASTER_CONNECT_RETRY", 0, 0, 0, ""},

  { "MASTER_HOST", 0, 0, 0, ""},

  { "MASTER_LOG_FILE", 0, 0, 0, ""},

  { "MASTER_LOG_POS", 0, 0, 0, ""},

  { "MASTER_PASSWORD", 0, 0, 0, ""},

  { "MASTER_PORT", 0, 0, 0, ""},

  { "MASTER_SERVER_ID", 0, 0, 0, ""},

  { "MASTER_SSL", 0, 0, 0, ""},

  { "MASTER_SSL_CA", 0, 0, 0, ""},

  { "MASTER_SSL_CAPATH", 0, 0, 0, ""},

  { "MASTER_SSL_CERT", 0, 0, 0, ""},

  { "MASTER_SSL_CIPHER", 0, 0, 0, ""},

  { "MASTER_SSL_KEY", 0, 0, 0, ""},

  { "MASTER_USER", 0, 0, 0, ""},

  { "MATCH", 0, 0, 0, ""},

  { "MAX_CONNECTIONS_PER_HOUR", 0, 0, 0, ""},

  { "MAX_QUERIES_PER_HOUR", 0, 0, 0, ""},

  { "MAX_ROWS", 0, 0, 0, ""},

  { "MAX_UPDATES_PER_HOUR", 0, 0, 0, ""},

  { "MAX_USER_CONNECTIONS", 0, 0, 0, ""},

  { "MEDIUM", 0, 0, 0, ""},

  { "MEDIUMBLOB", 0, 0, 0, ""},

  { "MEDIUMINT", 0, 0, 0, ""},

  { "MEDIUMTEXT", 0, 0, 0, ""},

  { "MERGE", 0, 0, 0, ""},

  { "MICROSECOND", 0, 0, 0, ""},

  { "MIDDLEINT", 0, 0, 0, ""},

  { "MIGRATE", 0, 0, 0, ""},

  { "MINUTE", 0, 0, 0, ""},

  { "MINUTE_MICROSECOND", 0, 0, 0, ""},

  { "MINUTE_SECOND", 0, 0, 0, ""},

  { "MIN_ROWS", 0, 0, 0, ""},

  { "MOD", 0, 0, 0, ""},

  { "MODE", 0, 0, 0, ""},

  { "MODIFIES", 0, 0, 0, ""},

  { "MODIFY", 0, 0, 0, ""},

  { "MONTH", 0, 0, 0, ""},

  { "MULTILINESTRING", 0, 0, 0, ""},

  { "MULTIPOINT", 0, 0, 0, ""},

  { "MULTIPOLYGON", 0, 0, 0, ""},

  { "MUTEX", 0, 0, 0, ""},

  { "NAME", 0, 0, 0, ""},