更新时间:2022-01-22 02:55:37
只需选择您想要的字段:
Just select the fields you want:
SELECT [event], [date] FROM myTable
而不是
instead of
SELECT * FROM myTable
您应该始终避免使用通配符字段说明符 - 它们会增加带宽,并且如果数据库被更改,可能会更改或崩溃您的应用程序。
P.S.我只在列名周围使用''[''和'']'',因为date是SQL中的保留字,可以在用作列名时停止查询。***避免使用也是保留字的列名!
You should avoid using wildcard field specifiers at all times - they increase bandwidth and can change or crash your application if the database is altered.
P.S. I only used the ''['' and '']'' around the column names because "date" is a reserved word in SQL and can stop your queries working when used as a column name. It''s best to avoid using column names which are also reserved words!