SQL field update, SQL update statement to update multiple fields at a time should be written

Add the field status to varchar(10) in the database table

update database table name set status = from database table name inner join temporary table name b on database table name. qh = and database table name. tel =

You mean add a field, just add it.

alter table_name add (column_name varchar2(10));

Then just put the value carefully.

update table_name set column_name=value where qh=010;

Only oracle, don't laugh.

SQL uses the update statement to update multiple fields at once, and the statement format is as follows:

update table name set Column name 1 = value, column name 2 = value 2 ,..where condition].

Multiple fields can be separated by commas, each fieldname=value is to assign a value to the field, and the following where conditional statement can be used or not.

update Table name set(Field 1, Field 2, Field 3,..Select 1, 2, 3,..where condition].

Multiple fields can be separated by commas, each fieldname=value is the assignment, and the following where conditional statement can be added or not.

Extended Material: Structured Query Language (SQL) (pronounced: es kju el"s-q-l"), a special-purpose programming language, is a database query and programming language for accessing data and querying, updating, and managing relational database systems; It is also an extension for database script files.

Structured Query Language is a high-level, non-procedural programming language that allows users to work on high-level data structures. It does not require the user to specify the storage method of the data, nor does it require the user to understand the specific data storage method, so different database systems with completely different underlying structures can use the same structured query language as the interface for data input and management. Structured Query Language statements can be nested, which makes it extremely flexible and powerful.

Here's how:

It is to add commas between different fields, and there is no limit to the number of fields.

For example, a, b, and c are the three fields in table t, and you can use condition 1 and condition 2 to locate a record.

select a,b,c from t where condition 1

select a,b,c from t where condition 2

Now I want to change the records corresponding to condition 2 to the records corresponding to bit condition 1.

update t set a =(select a from t where condition 1), b = (select b from t where condition 1), c=(select c from t where condition 1) where condition.

** Writing specifications.

1.There should be comments for the main functional functions. The content includes: functions, entry and exit parameters, and if necessary, there can be comments or supplementary instructions, and there should also be comments for the main functions in the function. The annotations are mainly in English.

2.The recommended length of each row** is 80 columns, and the longest column should not exceed 120 columns; The broken lines are aligned.

update table name set column name 1='value1', column name 2='value2', column name 3='value3'where condition].

The following example is executed:

Extended information: FieldsWe call each row in the table a "record", and each record contains all the information in this row, just like all the information of a person in the address book database, but the record does not have a special record name in the database, and often uses the number of rows it is in to indicate that it is the first number of records. A field is a smaller unit than a record, and a collection of fields makes up a record, each of which describes a certain feature of a document, i.e., a data item, and has a unique field identifier that can be recognized by a computer.

In a database, most of the time, the "columns" of a table are called "fields", and each field contains information about a topic. Just like in the Contacts database, "Name" and "Contact**" are attributes that are common to all rows in the table, so these columns are called "Name" and "Contact**" fields.

For example, update the second entry of table @a to update the data of the @b of the table with id=6 @a

set c1= ,c2=,c3=

from @a a,@b b where and

For example, update the second entry of table @a to update the data of the @b of the table with id=6 @a

set c1= ,c2=,c3=

from @a a,@b b where and

update Tablename set Field1='Updated Value1', Field2='Updated Value2' where your condition.