Php文档 Php问答行业资讯 Php论坛 Php手册 Php博客

游戏榜单

软件榜单

关闭导航

热搜榜

热门下载

热门标签

php爱好者> php文档>补充dw表，by 张春光

补充dw表，by 张春光

时间：2010-10-12 来源：sxxs001

#Stage&Prod

mysql> USE dw;

DATABASE changed

mysql> ALTER TABLE `broker_dailystatistic` ADD `salenum_other` INT( 6 ) NOT NULL AFTER `broker_activity` ,

-> ADD `rentnum_other` INT( 6 ) NOT NULL AFTER `salenum_other` , ADD `shopid` INT( 13 ) NOT NULL ,

-> ADD `areaid` INT( 13 ) NOT NULL ,

-> ADD `companyid` INT( 13 ) NOT NULL ,

-> ADD `broker_shop_verify` INT( 6 ) NOT NULL ,

-> ADD `member_id_card_state` INT( 6 ) NOT NULL;

Query OK, 71400 rows affected (0.50 sec)

Records: 71400 Duplicates: 0 Warnings: 0

#QA

mysql> source /DATA/backup/mysql/1.2.8/1.2.8-zcg.sql;

DATABASE changed

Query OK, 0 rows affected (0.07 sec)

#Stage

mysql> source /DATA/bak/sql/1.2.8/1.2.8-zcg.sql;

DATABASE changed

Query OK, 0 rows affected (0.04 sec)

#Prod

mysql> source /DATA/backup/sql/1.2.8/1.2.8-zcg.sql;

DATABASE changed

Query OK, 0 rows affected (0.14 sec)

#QA
mysql> source /DATA/backup/mysql/1.2.8/1.2.8--derong--xml-alter.sql
DATABASE changed
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 12 rows affected (0.03 sec)
Records: 12 Duplicates: 0 Warnings: 0
Query OK, 12 rows affected (0.04 sec)
Records: 12 Duplicates: 0 Warnings: 0
#Stage
mysql> source /DATA/bak/sql/1.2.8/1.2.8--derong--xml.sql;
DATABASE changed
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected (0.01 sec)
mysql> source /DATA/bak/sql/1.2.8/1.2.8--derong--xml-alter.sql;
DATABASE changed
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
#Prod
mysql> source /DATA/backup/sql/1.2.8/1.2.8--derong--xml.sql;
DATABASE changed
Query OK, 0 rows affected (0.15 sec)
Query OK, 0 rows affected (0.05 sec)
mysql> source /DATA/backup/sql/1.2.8/1.2.8--derong--xml-alter.sql;
DATABASE changed
Query OK, 0 rows affected (0.11 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> USE yoohouse_alpha;
DATABASE changed
mysql> ALTER TABLE `house_estate` CHANGE `estate_newhouse_price` `estate_newhouse_price` VARCHAR( 50 ) NULL DEFAULT NULL COMMENT '新房价格';
Query OK, 17244 rows affected (1.19 sec)
Records: 17244 Duplicates: 0 Warnings: 0

## ORDER BY 張春光

#QA

mysql> USE yoohouse_alpha;

DATABASE changed

mysql> ALTER TABLE `house_estate` CHANGE `estate_newhouse_price` `estate_newhouse_price` VARCHAR( 50 ) NULL DEFAULT NULL COMMENT '新房价格';

Query OK, 17196 rows affected (1.24 sec)

Records: 17196 Duplicates: 0 Warnings: 0

#stage

mysql> USE yoohouse_alpha;

DATABASE changed

mysql> ALTER TABLE `house_estate` CHANGE `estate_newhouse_price` `estate_newhouse_price` VARCHAR( 50 ) NULL DEFAULT NULL COMMENT '新房价格';

Query OK, 17232 rows affected (1.12 sec)

Records: 17232 Duplicates: 0 Warnings: 0

相关阅读更多 +

王者荣耀哪个称号含金量最高？王者荣耀含金量最高称号游戏攻略 2024-11-22
永劫无间手游地脉仪怎么找？永劫无间手游地脉仪位置游戏攻略 2024-11-22
绝世好武功结义方法游戏攻略 2024-11-22
魔兽世界奥格瑞玛传送大厅在哪儿？魔兽世界奥格瑞玛传送大厅位置游戏攻略 2024-11-22
我的世界怎么吃东西？我的世界吃东西方法游戏攻略 2024-11-22

排行榜更多 +

辰域智控app

辰域智控app

系统工具下载

网医联盟app

网医联盟app

运动健身下载

汇丰汇选App

汇丰汇选App

金融理财下载

4
律动鼓点舞app
85.51M · 97℃

1970-01-01

下载
5
海淘免税店app
81.86M · 97℃

1970-01-01

下载
6
工银商户之家app
78.09M · 94℃

1970-01-01

下载