WUXIAOKAI的专栏

OracleSELECT 'CRM' AS SRC_CODE, -- 系统标识 自己定 A.OWNER, A.TABLE_NAME AS TABLE_NAME, A.COLUMN_NAME AS COL_NAME, D.COMMENTS AS COL_DESC, A.column_id AS COL_ID,...

常用日期函数#时间转字符串date_format(date, format)#时间转时间戳（字符串）unix_timestamp()#字符串转时间str_to_date(str, format)#时间戳（字符串）转时间from_unixtime(unix_timestamp, format)1）时间转字符串select date_format(now(), '%Y-%m-...

用SET PASSWORD命令首先登录MySQL。 格式：mysql> set password for 用户名@localhost = password('新密码'); 例子：mysql> set password for root@localhost = password('123456'); 用mysqladmin格式：mysqladmin -u用户名 -p旧...

创建分区表DROP TABLE IF EXISTS `test`；CREATE TABLE test ( id int(10) unsigned NOT NULL AUTO_INCREMENT, time datetime NOT NULL COMMENT '业务时间', PRIMARY KEY ( id , time )) ENGINE=InnoDB AUTO_...

msyql -uroot -p123456 -h127.0.0.1 +-------+------------------------------------------+ |Option | Description | +-------+--------------------------------...