文章列表
作者:董存阔(本博客均为原创文章,转载请注明出处)
先把测试环境搭上(本sql测试平台为 Mysql 5.5)
create table `s` (
`sno` double ,
`sname` varchar (60)
);
insert into `s` (`sno`, `sname`) values('1','董存阔');
insert into `s` (`sno`, `sname`) values('2','董存涛');
insert into `s` (`sno`, `sname`) values('3','董存博');
---------------- ...
作者:
董存阔
(本博客均为原创文章,转载请注明出处)
create table `exam` (
`s_date` datetime ,
`order_id` varchar (765),
`product_id` varchar (765),
`amt` Decimal (11),
`id` double
);
insert into `exam` (`s_date`, `order_id`, `product_id`, `amt`, `id`) values('2012-03-01 00:00:00','1','1','100','1');
i ...