SELECT IDENTITY(int, 1,1) AS ID_Num INTO NewTable `FROM p_article`

SELECT IDENTITY(int, 1,1) AS ID_Num INTO NewTable `FROM p_article` 会报You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int, 1,1) AS ID_Num INTO NewTable ... 展开
匿名
发布于2011-08-19 09:54 最佳答案
属性复制不了的把

如果想建表你可以直接使用select .. into
只是复制数据库:
create table NewTable (
ID_Num int identity(1,但是自动的类型可以复制.

流香羽

采纳率:47% 来自团队:CMS 擅长: 其他编程语言 数据库DB 生活常识 育儿 上海

为您推荐: