1. Modify the data queried by SELECT ... 1) SELECT T. ROWID, T. * From TableName T // Remove the data physical ROWID and display, you can modify it .... 2) SELECT * From tablename for update // Remove data display, you can edit it .... The above two modifications, must be commissioned after the modification, otherwise locking Table ... 2, Update usage ... Example: Update TableName Set Table Field = 'I set the field' where table field = 'Condition 1' and Table field = 'Condition 2' and ....... 3, INSERT INTO usage .... Example: 1) INSERT INTO TABLENAME ('Field 1', 'Field 2', 'Field 3', ....., 'field n') VALUES ('content 1', 'content 2', 'content 3' , ..., 'content n') Example: 2) Insert INTO TABLENAME Select * from tablename1 // The structure of all data in Table1 into TableName // TableName1 must be exactly the same as the TableName.. .4, delete.com ... delete from tablename where field = condition and ........................ 5, GRANT usage. // Authorization to the specified user .. GR Ant SELECT, INSERT, UPDATE, DELETE ON TABLENAME TO User Download Adobe Reader Truncate empties a Table ... Truncate Table TableName;
