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;
|
Output
|
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)
|

|