如何在表中的FIRST处添加列 [英] How to ADD a column at FIRST in a table
问题描述
大家好，这可能是一个简单的问题，但它让我很难弄明白。
我使用的是以下ALTER声明将列添加到表并将其移动到第一个（在Access VBA中）。
并且，我可以使用以下ALTER语句向表中添加一列第1行，但无法使用第2行的ALTER语句将列移到第一位。
Hello everyone, this is probably the simple question, but it is giving me very hard time to figure out.
I am using the following "ALTER" statements to Add a column to a table and to move it to first (in Access VBA).
And, I am able to add a column to the table with the following ALTER statement at line #1, but unable to move the column to first with the ALTER statement at line #2.
推荐答案
这看起来就像你在这里猜到的那样。
语法有一个ALTER COLUMN版本，但提供的选项很简单允许更改类型和尺寸。我不相信有任何SQL支持的方法来移动表中的字段。
如需进一步阅读，请在主Access窗口中选择帮助（Microsoft Office Access帮助F1），导航到目录中的 Microsoft Jet SQL参考。
This rather looks like you''ve just guessed at a syntax here.
There is an ALTER COLUMN version of the syntax, but the options provided simply allow changing the Type & the Size. I don''t believe there is any SQL supported way to move a field within a table.
For further reading select Help (Microsoft Office Access Help F1) in the main Access window and navigate to Microsoft Jet SQL Reference within the Table of Contents.
相当看起来你只是猜到了这里的语法。
语法有一个ALTER COLUMN版本，但提供的选项只允许更改Type&尺寸。我不相信有任何SQL支持的方法来移动表中的字段。
如需进一步阅读，请在主Access窗口中选择帮助（Microsoft Office Access帮助F1），导航到目录中的 Microsoft Jet SQL参考。
This rather looks like you''ve just guessed at a syntax here.
There is an ALTER COLUMN version of the syntax, but the options provided simply allow changing the Type & the Size. I don''t believe there is any SQL supported way to move a field within a table.
For further reading select Help (Microsoft Office Access Help F1) in the main Access window and navigate to Microsoft Jet SQL Reference within the Table of Contents.
你好NeoPa，谢谢你的回复。
请点击以下链接（MySQL参考手册）并向下滚动到用户评论部分看到上面的ALTER语句（第2行）。
http://dev.mysql.com/doc/refman/5.0/...umn-order.html
SQL支持在表中移动字段的方法，但我不确定为什么Access VBA不支持sql语句（第2行）。
我错过了什么？请让我知道。
Hello NeoPa, thanks for the reply.
Please kindly click the following link (MySQL Reference manual) and scroll down to "User Comments" section to see the above ALTER statement (line #2).
http://dev.mysql.com/doc/refman/5.0/...umn-order.html
SQL supports the way to move a field within a table, but I am not sure why Access VBA is not supporting the sql statement (line #2).
Am I missing something? Please let me know.
嗯，我想这是一个MySQL手册所说的一切。显然，这不是一个简单的猜测 - 我可以接受。对不起，我建议这样做。
但是，Access的参考资料（或网络上的Access相关资料）确实是你需要的。
是否有关于Access的具体内容？
是的！
Access不是一个完全成熟的SQL服务器。将它与Oracle进行比较; MSSQL; MySQL或任何其他功能齐全的SQL服务器，你几乎肯定会感到失望。
Access的优势在于其可编程性和易用性，特别是很容易从轻松的合格开始。
简而言之，在后端功能方面，你需要特别小心Access。你的要求缺失对我来说完全不足为奇，我怀疑还有很多其他人经常处理它。我不是说我特别高兴或留下深刻印象，但也不会太惊讶。它绝对是一个小弟弟。关于后端处理的产品我很害怕。
Well, I guess that the fact that it''s a MySQL manual says everything. Clearly it wasn''t a simple guess though - I can accept that. I''m sorry I suggested that.
However, the reference material for Access (or Access related material on the web) is really what you need for this.
Is there something specific about Access?
YES!
Access is not a fully grown-up SQL server. Compare it to Oracle; MSSQL; MySQL or any of the other fully functional SQL servers and you''ll almost certainly be disappointed.
Access''s strengths really lie in its programmability and ease of use, and particularly its ease of starting with for the lightly qualified.
In short, you do need to be especially careful with Access where it comes to back-end functionality. Your requirement being missing is entirely unsurprising to me, and I would suspect many others who deal with it a lot. I don''t say I''m particularly happy or impressed, but not too surprised either. It''s definitely a "Baby-Brother" product where it comes to back-end processing I''m afraid.
这篇关于如何在表中的FIRST处添加列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
