MySQL 表操作

极速入门

--表更改alter table tableName drop/add/change/rename columnName xxx;--约束更改alter table [table_name] add constraint [constraint_name] [unique| primary key|foreign key] ([column_name])alter table users drop primary key;alter table users add  primary key(user_id);alter table users drop index api_key;alter table users add  unique(api_key);--表结构更改--collate 校对规则 utf8_bin 二进制排序alter table users add column  `test_url` varchar(1024) COLLATE utf8_bin DEFAULT NULL;--建表---------------------------------------DROP TABLE IF EXISTS `balance`;  /*!40101 SET @saved_cs_client     = @@character_set_client */;  /*!40101 SET character_set_client = utf8 */;  CREATE TABLE `gg_gogoing` (    `id` bigint(20) NOT NULL AUTO_INCREMENT,    `seller_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'id',    `leave` double NOT NULL DEFAULT '0' COMMENT '余额',    `fee` double DEFAULT NULL COMMENT '每次费用',    `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',    `fee_type` int(11) DEFAULT '0',    PRIMARY KEY (`id`),    KEY `id_fee_type` (`leave`,`fee_type`),    KEY `fee_type` (`fee_type`)  ) ENGINE=InnoDB AUTO_INCREMENT=110268 DEFAULT CHARSET=utf8 COLLATE=utf8_bin  /*!40101 SET character_set_client = @saved_cs_client */;