Home Sql Mysql-example MySQL Affected Rows



MySQL Affected Rows
Posted on: June 19, 2009 at 12:00 AM
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)

Related Tags for MySQL Affected Rows:
cdateupdatedeleteinsertexecexelikequeriesforieexampleexameliinpdamletescutxaxampsxedelatkmplrtupdutissripleplo


More Tutorials from this section

Ask Questions?    Discuss: MySQL Affected Rows  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.