SQL statements reflect the language habits of English. For example, when we use select to query "Select fields from table", we first enter the field name and then the table name. This is in line with the English habit, that is, the first small location, then the Earth Point. If you use Chinese language habits to describe it, it should be "Fetch field from table: Select Table get fields ". So what are the advantages of adopting Chinese habits? Think about it first, hey!
I recently used oracel10g sqlplus, which is very uncomfortable. Fortunately, El has tens of billions of dollars. This product has been around for decades, but a sqlplus is still so primitive. I hope that the first function of sqlplus is the command history function. The preceding SQL commands can be repeated by arrows. I hope that the second feature of sqlplus is the automatic completion of commands. So I thought of the SQL syntax mentioned above. If the SQL statement is such a "Select Table get fields", after the SELECT statement is input, the SMART system should be able to automatically list all the current table names, the field name is automatically displayed after the table name is entered.