Home Sql Mysql-example MySQL Affected Rows
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

MySQL Affected Rows

Advertisement
When we execute Sql query, it may affect some rows of the table.

MySQL Affected Rows

     

When we execute Sql query, it may affect some rows of the table. For example, executing queries like update, insert, delete. These queries displays the successful message with the number of rows affected by the query.

In this example we create table "price" with 'assetid', 'date', 'open', 'high', 'low', 'close' and 'volume' field.

Query
 CREATE TABLE `price` (
   `assetid` int(11) NOT NULL default '0',
   `date` date NOT NULL default '0000-00-00',
   `open` double default NULL,
   `high` double default NULL,
   `low` double default NULL,
   `close` double default NULL,
   `volume` bigint(20) default NULL,
   PRIMARY KEY  (`assetid`,`date`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Output
Query OK, 0 rows affected (0.08 sec)

Update a table "price":

Query
update price set open=3 where assetid=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Insert a row in "price" table:

Query

insert price(assetid, open, high, low, close,volume) values(3,1,2,3,2,3); 

Output

Query OK, 1 row affected (0.09 sec)

Delete row from table "price" where assetid=3:

Query

 delete from price where assetid=3;

Output

Query OK, 1 row affected (0.05 sec)
Advertisement

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: June 19, 2009

Ask Questions?    Discuss: MySQL Affected Rows  

Post your Comment


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