How to operate tables with simple SQL:
For some fields with the same value such as Province, City, etc., you can use the following SQL.
UPDATE info SET Province="Guangdong Province", City="Guangzhou"
or
UPDATE info SET SchoolName="Your school name"
Enter the SQL statement into the input box to the right of the "Execute SQL" button, and then click this button. Before clicking, make sure the checkbox "Return Result Set" is turned off. If a result set is returned after execution (such as SQL starting with SELECT), you must first turn on the checkbox "Return Result Set" before executing the SQL. For example, SELECT * FROM info.
Or close the software and open it again.
v0.2 adds data import from Excel. You can directly preview all data or specify how many students' data to preview.
Similar software
Release Notes
Software address
- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
it works
it works
it works