mysql中断语句_在一个MySQL语句中截断多个表

不,您只能使用TRUNCATE命令截断单个表.要截断多个表,您可以使用T-SQL并迭代表名以一次截断每个表.

DECLARE @delimiter CHAR(1),

@tableList VARCHAR(MAX),

@tableName VARCHAR(20),

@currLen INT

SET @delimiter = ','

SET @tableList = 'table1,table2,table3'

WHILE LEN(@tableList) > 0

BEGIN

SELECT @currLen =

(

CASE charindex( @delimiter, @tableList )

WHEN 0 THEN len( @tableList )

ELSE ( charindex( @delimiter, @tableList ) -1 )

END

)

SELECT @tableName = SUBSTRING (@tableList,1,@currLen )

TRUNCATE TABLE @tableName

SELECT tableList =

(

CASE ( len( @tableList ) - @currLen )

WHEN 0 THEN ''

ELSE right( @tableList, len( @tableList ) - @currLen - 1 )

END

)

END

您可以在@tableList变量中将所有表名以逗号分隔,如果是前缀,则可以截断不同模式中的多个表.