Database reserved words: diferència entre les revisions
De MoodleDocs
Cap resum de modificació |
Cap resum de modificació |
||
Línia 1: | Línia 1: | ||
It would be really helpful to have a list here. In the meantime, here are some links: | It would be really helpful to have a list here. In the meantime, here are some links: | ||
* [http://www.postgresql.org/docs/ | * [http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html#KEYWORDS-TABLE Postgres] | ||
* [http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html MySQL] | * [http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html MySQL] | ||
* [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp MSSQL] | * [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp MSSQL] |
Revisió del 00:22, 21 ago 2006
It would be really helpful to have a list here. In the meantime, here are some links:
Even better: SQL Reserved Words Checker.
It would be really good if the new XMLdb functions checked column and table names against these lists and refused to created things with reserved words as names.
Or alternatively, if they guaranteed to escape all SQL so it did not matter if we used reserved words.