做一个网站怎么做的吗,桂平seo快速优化软件,网络媒体广告公司,普集网站开发如果我理解正确,我认为你不能用一个查询来做到这一点.您可以尝试使用以下内容.添加了对代码的评论.SET schema database_name_here; -- Database nameSET table table1; -- Table nameSET startColumn column_start;SET endColumn column_end;-- First get the position of…如果我理解正确,我认为你不能用一个查询来做到这一点.您可以尝试使用以下内容.添加了对代码的评论.SET schema database_name_here; -- Database nameSET table table1; -- Table nameSET startColumn column_start;SET endColumn column_end;-- First get the position of both columnsSELECT ORDINAL_POSITION FROM information_schema.COLUMNSWHERE table_schemaschema AND table_nametable ANDcolumn_namestartColumn INTO StartPosition;SELECT ORDINAL_POSITION FROM information_schema.COLUMNSWHERE table_schemaschema AND table_nametable ANDcolumn_nameendColumn INTO endPosition;-- get the column names from the positionSELECT GROUP_CONCAT(column_name) from information_schema.COLUMNSwhere table_schemaschema AND table_nametableAND ORDINAL_POSITION StartPosition AND ORDINAL_POSITION endPositionINTO colname;-- create a sql statement prepare and executeSET query CONCAT(SELECT ,colname, FROM , table);PREPARE stmt FROM query;EXECUTE stmt;
