jdbc

[qq_37171619]

stmt.executeUpdate("alter table t"
			 +"add sex char;");

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 'sex char' at line 1
控制台都行，这上面怎么不行啊。

[thatsinteresting]

用的什么数据库

[qq_37171619]

MySQL啊

[annkee058]

alter table t add sex varchar(10) not Null; 字符要指定大小，用varchar类型就可以了

[pheonix0992]

第二行么有空格导致的错误把。varchar就算不指定默认也是varchar(10)

[H_WU_]

确实是缺少空格, 两个字符串拼起来就是alter table tadd sex char;