摘要:
1.日期中的重叠问题建表sessions:CREATE TABLE `sessions` (`id` int(11) NOT NULL AUTO_INCREMENT,`app` varchar(10) NOT NULL,`usr` varchar(10) NOT NULL,`starttime` time NOT NULL,`endtime` time NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB插入记录:insert into sessions(app,usr,starttime,endtime) values('app1','
阅读全文
posted @ 2013-12-08 16:22
Hi_Amos
阅读(761)
推荐(0)
编辑
摘要:
关于日期处理的实例:从mysql给出的 example 这个是官方源码下载以及导入,http://dev.mysql.com/doc/employee/en/employees-installation.html然后执行下面的操作:mysql> create table employees like employees.employees;Query OK, 0 rows affected (0.11 sec)mysql> desc employees;+------------+---------------+------+-----+---------+-------+| Fi
阅读全文
posted @ 2013-12-08 02:24
Hi_Amos
阅读(1211)
推荐(0)
编辑