请问mysql支持with...as...语法么
不支持你也可以参考下面http://stackoverflow.com/questions/1382573/how-do-you-use-the-with-clause-in-mysql
http://stackoverflow.com/questions/324935/mysql-with-clause