HYSQL  

¡¡

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


¡¡