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
MySQL

Data Manipulation Statements
Data Manipulation Statements       Data Manipulation Statement is used to retrieve, insert, update... the following Data Manipulation Statements : Select Statement Insert Statement 

Java Interview Questions

string manipulation
 

Java Interview Questions

string manipulation
 

Java Beginners

string manipulation
 

Java Beginners

Manipulation of war fie contents
Manipulation of war fie contents  How can I manipulate a specific file inside my war file without extracting it? Please help... Thanks and regards, Swapnil 

Ant Questions

string manipulation in xml
string manipulation in xml  im working on build.xml using apache ant... in one of the targets i am assigning a var file with the full path of .sql files present in a folder. while executing that .sql file in xml its giving me 

SQL Question

predicates and statements?
predicates and statements?  Explain about predicates and statements 

Java Beginners

array manipulation - Java Beginners
 

Java Beginners

array manipulation - Java Beginners
 

Java Beginners

Trouble with array manipulation
 

Java Beginners

Java String manipulation
 

Java Beginners

java programmming: string manipulation
 

Programming Tutorials

Working with CSS(CSS Manipulation)
Working with CSS(CSS Manipulation)       Working with CSS(CSS Manipulation) These methods are used to manipulate CSS specially by getting and setting 

Java Interview Questions

java statements
 

Java Interview Questions

Java statements
 

Java Interview Questions

Java statements
 

Java Interview Questions

Java statements
 

Java Interview Questions

Jdbc statements
 

Java Interview Questions

Jdbc statements
 

Java Beginners

loop statements
 

MySQL

Mysql Date Manipulation
Mysql Date Manipulation       Mysql Date Manipulation find out the difference between two values... Date Manipulation. To grasp this example, we create a table 'Person' with field 

Java Tips and Examples

Summary - Statements
Java: Summary - Statements Each control statements is one logical statement, which often encloses a block of statements in curly braces {}. The examples... statement is to choose some statements to execute depending on the integer 

SQL Question

The INSERT INTO Statements in SQL?
The INSERT INTO Statements in SQL?  The INSERT INTO Statements in SQL?   Hi, The INSERT INTO statement is used to insert a new row or multiple rows into a table. SQL INSERT INTO Syntax INSERT INTO table_name VALUES 

SQL Question

What is the Delete Statements in SQL?
What is the Delete Statements in SQL?  What is the Delete Statements... to delete partial/all data. Especially delete statement is useful in case... data from table. DELETE FROM table_name WHERE column_name = some_value Delete 

SQL Question

general syntax for a SELECT statements
general syntax for a SELECT statements  Write down the general syntax for a SELECT statements covering all the options   Hi, The general... shows how we can use different optin with the select statements. SELECT select 

Hibernate Questions

could not execute native bulk manipulation query
could not execute native bulk manipulation query  I am insert data in mysql through struts hibernate integration. But above error is coming. Please...); System.out.println("data is successfully submitted 

General

Java Control Statements
Java Control Statements       Introduction to Control Statements In this section, we are going to discuss the control statements. Different types of control statements 

General

Java Control Statements
Java Control Statements     ... the control statements. Different types of control statements: the decision making statements (if-then, if-then-else and switch), looping statements (while, do-while 

Java Beginners

loop, control statements
 

SQL Tutorial

Online Mysql Training
an important role in date manipulation language. The Online training on Mysql provides... of Relational Databases. Mysql Feature and benefits of Mysql. Use Data types... from database using SELECT statement. Delete or modify the table or row data