SQL语句大全 –语 句功能 –数据操作 SELECT –从数据库表中检索数据行和列 INSERT –向数据库表添加新数据行 DELETE –从数据库表中删除数据行 UPDATE –更新数据库表中的数据 -数据定义 CREATE TABLE –创建一个数据库表 DROP TABLE –从数据库中删除表 ALTER TABLE –修改数据库表结构 CREATE VIEW –创建...
DISTINCT OF VIEW DOMAIN ON WHEN DOUBLE ONLY WHENEVER DROP OPEN WHERE ELSE OPTION WITH END OR WORK END-EXEC ORDER WRITE ESCAPE OUTER YEAR EXCEPT OUTPUT ZONE EXCEPTION 未來關鍵字 下列關鍵字可能保留給 SQL Server 實作新功能的未來版本。 請考慮避免使用這些字做為識別碼。 ABSOLUTE HOST...
(type = FieldType.Integer) @TableField private Integer sex; /** * 地址 */ @Field(type = FieldType.Keyword) @TableField private String address; /** * 创建时间 */ @Field(name = "create_time", type = FieldType.Date) @TableField private Date createTime; @Override public boolean equals...
_SHARD_UNTIL_END_OFFSET、KINESIS_RECORD_SEQ_NUMBER_ORDER_VIOLATION、MALFORMED_CHARACTER_CODING、PS_FETCH_RETRY_EXCEPTION、PS_INVALID_KEY_TYPE、PS_INVALID_UNSAFE_ROW_CONVERSION_FROM_PROTO、PS_MOVING_CHECKPOINT_FAILURE、PS_MULTIPLE_FAILED_EPOCHS、PS_OPTION_NOT_IN_BOUNDS、PS_UNABLE_TO_PARSE_PROTO、...
Only a constant value, such as a character string; a scalar function (either a system, user-defined, or CLR function); or NULL can be used as a default. To maintain compatibility with earlier versions of SQL Server, a constraint name can be assigned to a DEFAULT. constant_expression A ...
OF VIEW DOMAIN ON WHEN DOUBLE ONLY WHENEVER DROP OPEN WHERE ELSE OPTION WITH END OR WORK END-EXEC ORDER WRITE ESCAPE OUTER YEAR EXCEPT OUTPUT ZONE EXCEPTION 将来的关键字 下列关键字可能会在将来的 SQL Server 版本中保留使用,作为将来要实现的新功能。注意,不要使用这些关键字作为标识符。
private final String name; //是否有 `,’等, 比如mysql中查询中 select `id`,`name` from xxx private final QuoteCharacter quoteCharacter; //字段属于哪个表 private TableSegment owner; 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 现在明白SQLSegment怎么回事了吧,可以看下解析结果,更清晰 ...
'VARCHAR', 'VARCHARACTER', 'VARIABLES', 'VARYING', 'VIEW', 'VIRTUAL', 'WAIT', 'WARNINGS', 'WEEK', 'WEIGHT_STRING', 'WHEN', 'WHERE', 'WHILE', 'WITH', 'WITHOUT', 'WORK', 'WRAPPER', 'WRITE', 'X509', 'XA', 'XID', 'XML', 'XOR', 'YEAR', 'YEAR_MONTH', 'ZEROFILL' ] ...
Data conversion from non-unicode character to unicode character Data Pump Data Truncated using FOR XML PATH Data type equivalent in T-SQL for the CLOB data type in PL-SQL - SQL Server 2012 and superior Data Type for saving Base64 image string into SQL database Data type for unsigned integer...
STRING, STRUCTURE, STYLE, SUBCLASS_ORIGIN, SUBMULTISET, SUBSTITUTE, SUBSTRING, SUM, SYMMETRIC, SYSTEM, SYSTEM_USER, TABLE, TABLESAMPLE, TABLE_NAME, TEMPORARY, THEN, TIES, TIME, TIMESTAMP, TIMESTAMPADD, TIMESTAMPDIFF, TIMEZONE_HOUR, TIMEZONE_MINUTE, TINYINT, TO, TOP_LEVEL_COUNT, TRAILING, TRA...