用户工具

站点工具


develop:sql:start

SQL

不常用的 SQL 语句

清空数据表

TRUNCATE `TABLE_NAME`

建库语句

CREATE TABLE `queue` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `corp_uin` CHAR(20) NOT NULL,
  `open_id` CHAR(64) NOT NULL,
  `number` INT(10) UNSIGNED NOT NULL,
  `type` INT(10) UNSIGNED NOT NULL,
  `updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` INT(10) UNSIGNED DEFAULT 0,
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

时间戳

update guang_coupon set start_time = unix_timestamp('2013-11-08 10:00:00'), end_time = unix_timestamp('2013-12-20 22:00:00') where coupon_id < 4;
develop/sql/start.txt · 最后更改: 2017/07/20 17:24 (外部编辑)

页面工具