Quick Search:
 
 mySQL: Create monthly partitions Jump to:  
Category: >> mySQL >> Create monthly partitions  

<< 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)

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'
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org