The number of affected rows is 0

update menu set parent=null where name like 'a%'

That is, if the name of the field in your table does not have a value including a, the number of affected rows is of course 0.

The error is posted, and the type of database management tool is posted.

or""rs="")

or sql, conn, 1, 1

rs("The name of the field") = field value.

set rs=nothing""

update

menuset

parent=null

wherename

likea%'

It's the word Qing Pei Na in your table name has no value including A's Yu Min only data, and the number of affected rows is of course 0.

@@rowcount

Returns the number of rows that were affected by the previous statement.

Grammar @@rowcount

Return type. integer

Comment: Any statement that does not return a row sets this variable to 0, such as an if statement.

Example: The following example executes an update statement and uses @@rowcount to detect if there are changed rows.

update authors set au_lname = 'jones'

where au_id = '999-888-7777'

if @@rowcount = 0

print 'warning: no rows were updated'

SQL update has no return value, before the update according to the where condition of the update is queried and saved, and then output after the update.

If you specify a primary key, 0 rows are affected, which can be analyzed in the following cases:

1. No data was found that needed to be updated.

2. The data to be updated and the updated value are exactly the same.

3. There is a problem with the SQL statement written by itself.

select * from xs where name like'%Locke%'or Name like'%Camel %'

Query first to see if the data exists.

It's not a matter of spaces.

The command has been executed, but the changes have not yet been committed.

Run the commint command to commit the changes.

I see that the data in your table has a red exclamation mark in front of it, which means that the data has changed.

What is actually stored may not be the data you see.

You turn it off and turn it back on, or press F5 to refresh it.

If you look at the database table in the camel, there's a space or any other symbol in this data.

You start with select * from xs where name='Luo Ting'Determine if there is such a record.

Check if there are any spaces before and after the name.

You need to make sure you have such a record. Update again.

It should look like this: update xs set name='Luo Ting where name='Camels'

There is no information in the table that matches the WHERE condition.

The statement is fine, I don't understand what you said about "0 rows are affected, but the records in the table are not updated", 0 rows are affected, and of course the records are not updated. Is there something wrong?

This means that you don't have a name = in your table'Luo Ting'This person. You'll have to take a closer look.

This shouldn't be the case normally, see if there's a trigger.

Or if the application received it, it was fault-tolerant, but the error was not indicated.

That's what you're talking about.

rowcount

Returns the number of rows that were affected by the previous statement.

Grammar @@rowcount

Return type. integer

Comment: Any statement that does not return a row sets this variable to 0, such as an if statement.

Example: The following example executes an update statement and uses @@rowcount to detect if there are changed rows.

update authors set au_lname = 'jones'

where au_id = '999-888-7777'

select @@rowcount is the row that is affected by the update.

Can you provide a statement in which this is the case, and the version of the database? This makes it easier for you to analyze.

Is there a trigger that exists, or it won't appear that you are in this situation after you:

select *

from tb

where id='002'It's 11 lines.

Wang Yongping said: This is a miracle.

You should post the original statement, otherwise you don't know what you're talking about, and it may be that there are related fields in the table.

It adds up to 79, probably because you have an index or duplicate column in the table.