Database beginners must read;

As a beginner, every "grammatical knowledge" in the database is something we should be proficient in, then as a technical rookie of you, below these some, you know how much!

Database additions and deletions change:

Added: 1. Add code by article:

INSERT into t_table (each column name in the table)

VALUES (each column corresponds to the value you want to add)

Commit

2.select T_table.*,t_table.rowid from T_table;

Then click on the small lock in the found table

Delete: Delete * from t_table This code means to erase all the contents of this table.

Delete * from t_table where sno=1 this code means to delete all the contents of this table sno=0

Change: Update t_table Set the content you want to change where you want to change where the content belongs

2. You can also directly use the added second method of unlocking directly in the table to change

Check: SELECT * from T_table all the contents of this form can also be restricted where a single item can be checked or converted to something you want to see

Database beginners must read;