|
¡¡
|
Chapter 7
- Other SQL sentences
|
7.1 The modification of the basic table
Insert
a field into the position of the specifical column.
Syntax: ALTER TABLE
TableName INSERT ColumnPosition
ColumnName FieldType [(nFieldWidth)]
[NULL | NOT NULL]
Interface method:
executeUpdate(String
cmd)
Explain: Return 1 if executed successfully;throw a error message if failed
7.2 The data manipulation
1.Insert a record into the position of the specifical row.
Syntax: INSERT INTO
TableName [(FieldName[,FieldName]...)] VALUES (const[,const]...) AT
RowPosition
Interface
method:
executeUpdate(String cmd)
Explain: Return
1 if executed successfully;throw a error message if failed
2.Update a specifical record.
Syntax: UPDATE
TableName
SET FieldName=expression[,FieldName=expression]... AT
RowPosition
Interface
method: executeUpdate(String cmd)
Explain: Return
1 if executed successfully;throw a error message if failed
3.Update a total table.
Syntax: UPDATE TABLE
TableName
Interface method: execute(String
cmd)
Return:
hy.base.common.TableIO
Explain: Return
hy.base.common.TableIO if executed successfully;throw a error
message if failed
4.Delete a specifical record.
Syntax: DELETE FROM
TableName
AT RowPosition
Interface method:
executeUpdate(String cmd)
Explain: Return
1 if executed successfully;throw a error message if failed
Return
|
¡¡ |