Description: Create to_days(first_day), to_days(second_day) syntax that can be directly used while creating partitions based on month.
Language: MYSQL Highlight Mode: MYSQL Last Modified: March 02nd, 2009
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;"
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'
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.