MySQL Affected Rows

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

MySQL Affected Rows

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)