CoderZone.org

Category: >> mySQL >> Create monthly partitions Bookmark and Share

<< lastnext >>

Snippet Name: Create monthly partitions

Description: Create to_days(first_day), to_days(second_day) syntax that can be directly used while creating partitions based on month.

Comment: (none)

Author: CoderZone
Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 02nd, 2009

#!/bin/sh
mysql -e"drop table if exists test.mycalendar;"
mysql -e"create table test.mycalendar (id int not null auto_increment, dateval date, primary key (id));"
 
for (( i = 0 ; i < 730 ; i++ ))
do
mysql -e"insert into test.mycalendar (dateval) select '$1' + interval $i day;"
done
 
mysql -e"select group_concat(concat('to_days(', '\'',dateval,'\')') order by dateval) as '' from test.mycalendar group by extract(year_month from dateval);" | sort
 
# use the following syntax to use
# sh /root/calendar.sh '2008-01-01'
 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 17