1
2
|
CREATE
TABLE
date_test(
dt DATETIME
NOT
NULL
DEFAULT
'0000-00-00 00:00:00'
);
|
1
2
3
4
|
drop
table
if exists my_summary_new,my_summary_old;
create
table
my_summary_new
like
my_summay;
#导入数据
rename
table
my_summary
to
my_summary_old,my_summary_new
to
my_summary;
|
1
|
update
hit_counter
set
cnt = cnt + 1;
|
1
2
3
4
|
create
table
hit_counter(
id tinyint unsigned
not
null
primary
key
,
cnt
int
unsigned
not
null
) engine = innodb;
|
1
|
update
hit_counter
set
cnt=cnt+1
where
id= rand()*100;
|
1
|
select
sum
(cnt)
from
hit_counter;
|
1
|
insert
into
daily_hit_counter(
day
,id,cnt)
values
(
current_date
(),rand() * 100,1)
on
duplicate
key
update
cnt = cnt + 1;
|
1
|
alter
table
film
modify
column
sss tinyint(3)
not
null
default
5;
|
1
|
alter
table
film
alter
column
sss
set
default
5;
|
1
2
3
|
alter
table
test disable keys;
#
load
data
alter
table
test enable keys;
|