VFP语句(国外英文资料).docVIP

VFP语句 -- words work Data manipulation SELECT - retrieves data rows and columns from the database table INSERT - add new data rows to the database table DELETE - removes the data row from the database table UPDATE - updates the data in the database table Data definition CREATE TABLE - creates a database TABLE DROP TABLE -- delete the TABLE from the database ALTER TABLE -- modify the database TABLE structure CREATE VIEW -- CREATE a VIEW DROP VIEW - removes the VIEW from the database CREATE INDEX - creates an INDEX for the database table DROP INDEX - removes the INDEX from the database CREATE PROCEDURE -- creates a stored PROCEDURE DROP PROCEDURE - removes the stored PROCEDURE from the database CREATE TRIGGER -- creates a TRIGGER DROP TRIGGER - removes the TRIGGER from the database CREATE SCHEMA -- adds a new SCHEMA to the database DROP SCHEMA - removes a SCHEMA from the database CREATE DOMAIN -- creates a data range ALTER DOMAIN -- changes the DOMAIN definition DROP DOMAIN - removes a DOMAIN from the database Data control GRANT -- grants user access DENY - denies user access REVOKE - removes user access -- transaction control COMMIT -- end the current transaction ROLLBACK - abort the current transaction SET TRANSACTION - defines the current TRANSACTION data access characteristics - procedural SQL DECLARE - sets the cursor for the query EXPLAN - describes the data access plan for the query OPEN - retrieve the query result to OPEN a cursor FETCH - retrieve a row of query results CLOSE -- CLOSE the cursor PREPARE - PREPARE the SQL statement for the dynamic execution EXECUTE - executes the SQL statement dynamically DESCRIBE - describes the ready query -local variable Declare @ id char (10) -- set @id =Select @id =Global variable - must start with @@ - IF the ELSE declare Select @x = 1, @y = 2, @z = 3 If @x @ y Print x y -- print string x y Else if @y @z Print y z Else print z y - a CASE Use pangu Update the employee The set e_wage = case When job