http://www.roseindia.net/mysql/mysql5/data-manipulation-statements.shtml
TRUNCATE:
as TRUNCATE doent return no.of rows affected it should be like here:
mysql> select * from tmp;
+------+
| name |
+------+
| ss |
| sd |
+------+
2 rows in set (0.00 sec)
mysql> truncate tmp;
Query OK, 0 rows affected (0.01 sec)
mysql> select * from tmp;
Empty set (0.00 sec)
But u said
mysql> TRUNCATE Emp1;
Query OK, 2 rows affected (0.20 sec)
please correct it... :-)
mysqlsumathi February 2, 2012 at 10:46 AM
THIS statments is very useful for me..!
mistake in querysuresh kommara August 31, 2012 at 11:34 PM
http://www.roseindia.net/mysql/mysql5/data-manipulation-statements.shtml TRUNCATE: as TRUNCATE doent return no.of rows affected it should be like here: mysql> select * from tmp; +------+ | name | +------+ | ss | | sd | +------+ 2 rows in set (0.00 sec) mysql> truncate tmp; Query OK, 0 rows affected (0.01 sec) mysql> select * from tmp; Empty set (0.00 sec) But u said mysql> TRUNCATE Emp1; Query OK, 2 rows affected (0.20 sec) please correct it... :-)
Post your Comment