2023年7月13日发(作者：)

关键字order附近有语法错误,应为ID,QUOTED_ID,或,今天查询数据库时select sum(goods_number)from ordergroup by goods_id怎么查询都报：关键字 'order' 附近有语法错误,应为ID,QUOTED_ID,或','错最后，在⽹上百度出来order是关键字在order上加中括号，问题解决了select sum(goods_number)

from [order]group by goods_id问题虽然解决了，但是以后使⽤会很不⽅便，所以最后将order表改了⼀下名字变成了orders,为免以后再犯这样的问题这⾥将数据库⼀些常⽤的关键字列了出来以便以后创建数据表时注意：AABSOLUTE ACTION ADD ADMINDBALL ALLOCATE ALPHANUMERIC ALTERAND ANY ARE ASASC ASSERTION AT AUTHORIZATIONAUTOINCREMENT AVGBBAND BEGIN BETWEEN BINARYBIT BIT_LENGTH BNOT BORBOTH BXOR BY BYTE

CCASCADE CASCADED CASE CASTCATALOG CHAR CHARACTER CHAR_LENGTHCHARACTER_LENGTH CHECK CLOSE COALESCECOLLATE COLLATION COLUMN COMMITCOMP COMPRESSION CONNECT CONNECTIONCONSTRAINT CONSTRAINTS CONTAINER CONTINUECONVERT CORRESPONDING COUNT COUNTERCREATE CREATEDB CROSS CURRENCYCURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMPCURRENT_USER CURSOR

DDATABASE DATE DATETIME DAYDEALLOCATE DEC DECIMAL DECLAREDEFAULT DEFERRABLE DEFERRED DELETEDESC DESCRIBE DESCRIPTOR DIAGNOSTICSDISALLOW DISCONNECT DISTINCT DOMAINDOUBLE DROP

EELSE END END-EXEC ESCAPEEXCEPT EXCEPTION EXCLUSIVECONNECT EXECEXECUTE EXISTS EXTERNAL EXTRACT

FFALSE FETCH FIRST FLOATFLOAT4 FLOAT8 FOR FOREIGNFOUND FROM FULL

GGENERAL GET GLOBAL GOGOTO GRANT GROUP GUID

HHAVING HOUR

IIDENTITY IEEEDOUBLE IEEESINGLE IGNOREIMAGE IMMEDIATE IN INDEXINDICATOR INHERITABLE INITIALLY INNERINPUT INSENSITIVE INSERT INTINTEGER INTEGER1 INTEGER2 INTEGER4INTERSECT INTERVAL INTO ISISOLATION

JJOIN

KKEY

LLANGUAGE LAST LEADING LEFTLEVEL LIKE LOCAL LOGICALLOGICAL1 LONG LONGBINARY LONGCHARLONGTEXT LOWER

MMATCH MAX MEMO MINMINUTE MODULE MONEY MONTH

NNAMES NATIONAL NATURAL NCHARNEXT NO NOT NOTENULL NULLIF NUMBER NUMERIC

OOBJECT OCTET_LENGTH OF OLEOBJECTON ONLY OPEN OPTIONOR ORDER OUTER OUTPUTOVERLAPS OWNERACCESS

PPAD PARAMETERS PARTIAL PASSWORDPERCENT PIVOT POSITION PRECISIONPREPARE PRESERVE PRIMARY PRIORPRIVILEGES PROC PROCEDURE PUBLIC

QRREAD REAL REFERENCES RELATIVERESTRICT REVOKE RIGHT ROLLBACKROWS

SSCHEMA SCROLL SECOND SECTIONSELECT SELECTSCHEMA SELECTSECURITY SESSIONSESSION_USER SET SHORT SINGLESIZE SMALLINT SOME SPACESQL SQLCODE SQLERROR SQLSTATESTRING SUBSTRING SUM SYSTEM_USER

TTABLE TABLEID TEMPORARY TEXTTHEN TIME TIMESTAMP TIMEZONE_HOURTIMEZONE_MINUTE TO TOP TRAILINGTRANSACTION TRANSFORM TRANSLATE TRANSLATIONTRIM TRUE

UUNION UNIQUE UNIQUEIDENTIFIER UNKNOWNUPDATE UPDATEIDENTITY UPDATEOWNER UPDATESECURITYUPPER USAGE USER USING

VVALUE VALUES VARBINARY VARCHARVARYING VIEW

WWHEN WHENEVER WHERE WITHWORK WRITE

XYYEAR YESNO

ZZONE