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 Beginners

string manipulation
 

Java Interview Questions

string manipulation
 

Java Interview Questions

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 

SQL Question

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

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 

Swing AWT

Image Manipulation in Swing AWT
Image Manipulation in Swing AWT  Sir, I'am new to Swing Programming. I have to create an application where an image is displayed on one Label. The same image has to be split in parts and stored in database pert wise. Later 

Java Beginners

java programmming: string manipulation
 

Java Beginners

Java String manipulation
 

Java Beginners

Trouble with array manipulation
 

Java Beginners

array manipulation - Java Beginners
 

Java Beginners

array manipulation - Java Beginners
 

Java Beginners

if/else statements
 

Java Beginners

loop statements
 

Java Interview Questions

Jdbc statements
 

Java Interview Questions

Jdbc statements
 

Java Interview Questions

Java statements
 

Java Interview Questions

Java statements
 

Java Interview Questions

Java statements
 

Java Interview Questions

java statements
 

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 

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 Beginners

DECESION MAKING STATEMENTS
DECESION MAKING STATEMENTS  The Decision Making statements may be implemented in different forms depending on the complexity of the condition to be tested. Describe various forms of decision making statements in java 

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

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 

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 

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 

Java Beginners

Avoiding ‚??!= null‚?? statements in Java?
Avoiding ‚??!= null‚?? statements in Java?  Avoiding ‚??!= null‚?? statements in Java 

DMCA.com