我使用labsql + access 讀取MOLD資料表,其中有一欄位名稱為Size
當指令 SELECT * FROM MOLD 時一切正常
但使用 SELECT Size FROM MOLD 則出現如附圖的異常
請問Size 是保留字嗎? 我有爬了版主的文, 裡面的保留字沒Size
而且Size這個欄位是另一支程式產生的(別人用vb寫的),用了好幾年了都能正常讀寫
端午佳節愉快!
我找到原因了,和大家分享一下
Size 確實是保留字
ACCESS 的 SQL 保留字
摘自 Microsoft Access 2006 線上說明
下列清單包含所有 Microsoft Jet 資料庫引擎保留的字詞，以用於 SQL 陳述式。列示在清單中的非大寫字母字詞也保留在其他應用程式中。因此，這些字詞個別的說明主題，提供非針對 SQL 用法的一般性描述。
附註 末端加上星號 (*) 的字詞已保留，但目前在 Microsoft® Jet SQL 陳述式中並沒有意義 (例如 Level 和 TableID)。無底線的字詞沒有連結的解釋。
A
| ABSOLUTE | ANY |
| ADD | ARE |
| ADMINDB | AS |
| ALL | ASC |
| Alphanumeric — 參閱 TEXT | ASSERTION |
| ALTER | AUTHORIZATION |
| ALTER TABLE | AUTOINCREMENT — h0 m,4 COUNTER |
| And | Avg |
| AS |
| BEGIN | COLLATION |
| Between | COLUMN |
| BINARY | COMMIT |
| BIT | COMP, COMPRESSION |
| BIT_LENGTH | CONNECT |
| BOOLEAN — 參閱 BIT | CONNECTION |
| BOTH | CONSTRAINT, CONSTRAINTS |
| BY | CONTAINER |
| BYTE | CONTAINS |
| CASCADE | CONVERT |
| CATALOG | Count |
| CHAR, CHARACTER — 參閱 TEXT | COUNTER |
| CHAR_LENGTH | CREATE |
| CHARACTER_LENGTH | CURRENCY |
| CHECK | CURRENT_DATE |
| CLOSE | CURRENT_TIME |
| CLUSTERED | CURRENT_TIMESTAMP |
| COALESCE | CURRENT_USER |
| COLLATE | CURSOR |
| DATABASE | DISALLOW |
| DATE — 參閱 DATETIME | DISCONNECT |
| DATETIME | DISTINCT |
| DAY | DISTINCTROW |
| DEC, DECIMAL | DOMAIN |
| DECLARE | DOUBLE |
| DELETE | DROP |
| DESC |
| Eqv | FOREIGN |
| EXCLUSIVECONNECT | FROM |
| EXEC, EXECUTE | FROM 子句 |
| EXISTS | GENERAL — 參閱 LONGBINARY |
| EXTRACT | GRANT |
| FALSE | GROUP |
| FETCH | GUID |
| FIRST | HAVING |
| FLOAT, FLOAT8 — 參閱 DOUBLE | HOUR |
| FLOAT4 — 參閱 SINGLE |
| IDENTITY | INPUT |
| IEEEDOUBLE — 參閱 DOUBLE | INSENSITIVE |
| IEEESINGLE — 參閱 SINGLE | INSERT |
| IGNORE | INSERT INTO |
| IMAGE | INT, INTEGER, INTEGER4 — 參閱 LONG |
| Imp | INTEGER1 — 參閱 BYTE |
| In | INTEGER2 — 參閱 SHORT |
| IN | INTERVAL |
| INDEX | INTO |
| INDEXCREATEDB | Is |
| INNER | ISOLATION |
| JOIN | LONGTEXT |
| KEY | LOWER |
| LANGUAGE | MATCH |
| LAST | Max |
| LEFT | MEMO — 參閱 LONGTEXT |
| Level* | Min |
| Like | MINUTE |
| LOGICAL, LOGICAL1 — 參閱 BIT | Mod |
| LONG | MONEY — 參閱 CURRENCY |
| LONGBINARY | MONTH |
| LONGCHAR |
| NATIONAL | Outer* |
| NCHAR | OUTPUT |
| NONCLUSTERED | OWNERACCESS |
| Not | PAD |
| NTEXT | PARAMETERS |
| NULL | PARTIAL |
| NUMBER — 參閱 DOUBLE | PASSWORD |
| NUMERIC — 參閱 DECIMAL | PERCENT |
| NVARCHAR | PIVOT |
| OCTET_LENGTH | POSITION |
| OLEOBJECT — 參閱 LONGBINARY | PRECISION |
| ON | PREPARE |
| OPEN | PRIMARY |
| OPTION | PRIVILEGES |
| Or | PROC, PROCEDURE |
| ORDER | PUBLIC |
| REAL — 參閱 SINGLE | SMALLDATETIME |
| REFERENCES | SMALLINT — 參閱 SHORT |
| RESTRICT | SMALLMONEY |
| REVOKE | SOME |
| RIGHT | SPACE |
| ROLLBACK | SQL |
| SCHEMA | SQLCODE, SQLERROR, SQLSTATE |
| SECOND | StDev |
| SELECT | StDevP |
| SELECTSCHEMA | STRING — 參閱 TEXT |
| SELECTSECURITY | SUBSTRING |
| SET | Sum |
| SHORT | SYSNAME |
| SINGLE | SYSTEM_USER |
| SIZE |
| TABLE | UPDATEOWNER |
| TableID* | UPDATESECURITY |
| TEMPORARY | UPPER |
| TEXT | USAGE |
| TIME — 參閱 DATETIME | USER |
| TIMESTAMP | USING |
| TIMEZONE_HOUR | VALUE |
| TIMEZONE_MINUTE | VALUES |
| TINTINT | Var |
| TO | VARBINARY — 參閱 BINARY |
| Top | VARCHAR — 參閱 TEXT |
| TRAILING | VarP |
| TRANSACTION | VARYING |
| TRANSFORM | VIEW |
| TRANSLATE | WHEN |
| TRANSLATION | WHENEVER |
| TRIM | WHERE |
| TRUE | WITH |
| UNION | WORK |
| UNIQUE | Xor |
| UNIQUEIDENTIFIER | YEAR |
| UNKNOWN | YESNO — 參閱 BIT |
| UPDATE | ZONE |
| UPDATEIDENTITY |
還有欄位名稱可以用保留字喔!
只要將保留字用 [] 框起如 SELECT [Size] FROM MOLD 即可