mysql 存储过程写入临时表中

1. USE test
2.  
   GO
3.  
    
4.  
    
5.  
   -- 查看某個表的索引
6.  
   SELECT * FROM sys.sysindexes
7.  
   WHERE id=object_id('RelactionGraph')
8.  
    
9.  
   -- 查看整個庫的索引
10.  
    SELECT * FROM sys.sysindexes
11.  
     
12.  
    -- 查看所有庫的索引
13.  
    IF object_id('tempdb..#')IS NOT NULL
14.  
    DROP TABLE #
15.  
    SELECT * INTO # FROM sys.sysindexes WHERE 1=2
16.  
     
17.  
    INSERT INTO #
18.  
    EXEC sys.sp_MSforeachdb @command1='Select * from ?.sys.sysindexes'
19.  
     
20.