mysql常用语法

1，查询表结构：
    desc table_name;
    show create table table_name;
2,  更改表主键
        先删除主键
        alter table table_name drop primary key;
        然后再添加主键
        alter table table_name add primary key(id);
3, 创建表
        CREATE TABLE proc (
      id int(11) NOT NULL,
      db char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
      name char(64) NOT NULL DEFAULT '',
      type enum('FUNCTION','PROCEDURE') NOT NULL,
      specific_name char(64) NOT NULL DEFAULT '',
      language enum('SQL') NOT NULL DEFAULT 'SQL',
      sql_data_access enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
      is_deterministic enum('YES','NO') NOT NULL DEFAULT 'NO',
      security_type enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
      param_list blob NOT NULL,
      returns longblob NOT NULL,
      body longblob NOT NULL,
      definer char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
      created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      modified timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
      sql_mode set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
      comment text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
      character_set_client char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
      collation_connection char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
      db_collation char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
      body_utf8 longblob,
      PRIMARY KEY (db,name,type),
      KEY id (id)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 

4, 修改表明
    alter table tableName rename to table_name;