mysql_affected_rows is DDL or DML statement ?

[mohansinfh]

Today, my senior asked me a mysql_query to get number of affected rows, I said that’s very easy “mysql_affected_rows”, but suddenly he asked by which it is done, by using DDL or by DML? I have never heard that a query is DDL or DML.

[r937]

a query is either DDL or DML

but mysql_affected_rows is neither, it is a php function

[mohansinfh]

Thank you Rudy Sir.
But the mysql query which in running in backend, and when its outputs comings that "1 row(s) affected", then to which type that backend query belong ?
Is it DDL or DML?

[r937]

Is it DDL or DML?

depends

which query are you talking about? can i see it?

[mohansinfh]

Sir, I am talking about the query which is run in phpmyadmin, when we delete some record in a table. Then it comes in the bottom, that "1 row(s) affected". Is that DDL or DML?
I think that's DML because that message came because Data is manipulated.

[r937]

I think that's DML because that message came because Data is manipulated.

you are correct -- DELETE is DML

[GireeshS]

i also think its DML (data manipulation language)

using DML commands like insert,delete data is manipulated.