Home Discussion Discuss: Data Manipulation Statements

  • 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



Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Related Articles
DMCA.com