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)