MySQL Forums
Forum List  »  Partitioning

Re: truncate partition not happening
Posted by: samir devaliya
Date: January 16, 2012 12:41AM

please find the O/P

mysql> SELECT SQL_NO_CACHE * FROM dist_product_clover ;
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
| sourceid | sku | isavailable | warehouseid | qtyonhand | lastmodeifiedon | activeflag | qtyonorder | pandarequestid |
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 0 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 0 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 1 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 1 | NULL | NULL |
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
4 rows in set (0.00 sec)

mysql> alter table dist_product_clover truncate partition p0;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from dist_product_clover;
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
| sourceid | sku | isavailable | warehouseid | qtyonhand | lastmodeifiedon | activeflag | qtyonorder | pandarequestid |
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 0 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 0 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 1 | NULL | NULL |
| 95 | no | 1 | 1 | 0 | 2012-01-08 00:00:00 | 1 | NULL | NULL |
+----------+------+-------------+-------------+-----------+---------------------+------------+------------+----------------+
4 rows in set (0.00 sec)


kindly suggest

regards
Samir

Options: ReplyQuote


Subject
Views
Written By
Posted
3104
January 09, 2012 08:06AM
1433
January 13, 2012 09:58AM
Re: truncate partition not happening
1558
January 16, 2012 12:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.