例如说SET FOREIGN_KEY_CHECKS=0;ALTER TABLE ims_modules ADD `template_id` int(10) unsigned NOT NULL;ALTER TABLE ims_modules ADD `item_list` text NOT NULL;ALTER TABLE ims_account_wxapp ADD `version` varchar(10) NOT NULL;ALTER TABLE ims_account_wxapp ADD `access_token` varchar(200) NOT NULL;ALTER TABLE ims_account_wxapp ADD `expirein` int(10) unsigned NOT NULL;ALTER TABLE ims_account_wxapp ADD `refresh_token` varchar(100) NOT NULL;ALTER TABLE ims_account_wxapp ADD `plugin` varchar(30) NOT NULL;ALTER TABLE ims_account_wxapp ADD `description` text NOT NULL;ALTER TABLE ims_account_wxapp ADD `status` tinyint(1) unsigned NOT NULL;ALTER TABLE ims_account_wxapp ADD `fail_reason` text NOT NULL;
1 回答
慕桂英3389331
TA贡献2036条经验 获得超8个赞
mysql如何添加数据
举例如下:
//建立一个表
create table tab_nam(
age int,
name char(10)
)
//往里插入数据
insert into tab_nam(age,name) values(11,'aaa')
insert into tab_nam(age,name) values(22,'bbb')
添加回答
举报
0/150
提交
取消