The oracle database to add data-CodePudding

There is a table first, I want to put the whole column in a list of (numerous) data is to add 1, and SQL

CodePudding user response:

Update a set a.X X=1

CodePudding user response:

reference 1st floor alex259 response:

update a set a.X X=1

Is "add 1", not is set to 1, the original poster also didn't explain this add is + 1, or add a 1 after the string

CodePudding user response:

The whole column data add 1 what mean?

CodePudding user response:

The update table name set the field name=rownum

CodePudding user response:

refer to the second floor minsic78 response:

Quote: refer to 1st floor alex259 response:

Update a set a.X X=1

Is "add 1", not is set to 1, the original poster also didn't explain this add is + 1, or after the string append a 1

Anyway, the column data, I think it is all in a 1, ha ha ha ha

CodePudding user response:

reference 5 floor yujiaxucheng reply:

Quote: refer to the second floor minsic78 response:

Quote: refer to 1st floor alex259 response:

Update a set a.X X=1

Is "add 1", not is set to 1, the original poster also didn't explain this add is + 1, or after the string append a 1

Anyway, the column data, I think it is all in a 1, ha ha ha ha

Reasonable

CodePudding user response:

Simple update will!
The update table LLXC set jine=jine + 1

CodePudding user response:

It is ok to UPDATE.
The update table
Set the table. The xx=1

CodePudding user response:

 
Create table (t 
Lie number (10) 
); 
The update table t 
Set the table. The lie=1