#mysqlquery 검색 결과

One poorly written SQL query can melt your machine 😅 I ran this join for a data quality check: [Query Attached] Table Rows: 1. c: 18,494 rows 2. j: 18,484 rows, No indexes in the bronze layer 👉 Expected: simple CRM ↔ ERP ID match 👉 Actual: != triggered a massive Cartesian…

thehungertocode's tweet image. One poorly written SQL query can melt your machine 😅

I ran this join for a data quality check: [Query Attached]

Table Rows:
1. c: 18,494 rows
2. j: 18,484 rows, No indexes in the bronze layer

👉 Expected: simple CRM ↔ ERP ID match
👉 Actual: != triggered a massive Cartesian…
thehungertocode's tweet image. One poorly written SQL query can melt your machine 😅

I ran this join for a data quality check: [Query Attached]

Table Rows:
1. c: 18,494 rows
2. j: 18,484 rows, No indexes in the bronze layer

👉 Expected: simple CRM ↔ ERP ID match
👉 Actual: != triggered a massive Cartesian…

𝐒𝐐𝐋 𝐄𝐱𝐞𝐜𝐮𝐭𝐢𝐨𝐧 𝐋𝐨𝐠𝐢𝐜 Save it for later✅ Follow @_Ai_Yash_ for more updates. Happy Learning and keep sharing.🙂 #sql #notes

_Ai_Yash_'s tweet image. 𝐒𝐐𝐋 𝐄𝐱𝐞𝐜𝐮𝐭𝐢𝐨𝐧 𝐋𝐨𝐠𝐢𝐜 

Save it for later✅ 
Follow @_Ai_Yash_ for more updates.  

Happy Learning and keep sharing.🙂

#sql #notes

One of the best resources to practice SQL queries.

AmanSharma_554's tweet image. One of the best resources to practice SQL queries.

Productivity Saturday > Woke up > Went to the gym > Did 3 questions on DP and BST > Completed SQL queries and practised a ton of them > Went for a walk in the evening > Did some chores and cleaning > Started going more deep dive into databases.



Complete MySQl Cheatsheet 📚📘 Save it now ✅️ #sql

tarachandverm's tweet image. Complete MySQl Cheatsheet 📚📘

Save it now ✅️

#sql

𝐒𝐐𝐋 𝐂𝐡𝐞𝐚𝐭 𝐒𝐡𝐞𝐞𝐭: Save it for later✅ Follow @_Ai_Yash_ for more updates. Happy Learning and keep sharing.😊

_Ai_Yash_'s tweet image. 𝐒𝐐𝐋 𝐂𝐡𝐞𝐚𝐭 𝐒𝐡𝐞𝐞𝐭:

Save it for later✅

Follow @_Ai_Yash_ for more updates.

Happy Learning and keep sharing.😊

🚀 Desafio iniciado: 100 dias de MySQL 📅 Dia 45/100 📚 Normalização de Dados. Organizar tabelas 1️⃣ 1FN: cada campo com valor único (nada de listas). 2️⃣ 2FN: tudo depende da chave primária inteira. 3️⃣ 3FN: nada depende de outro campo não-chave. 💡100DaysOfSQL #MySQL

jessytech23's tweet image. 🚀 Desafio iniciado: 100 dias de MySQL
📅 Dia 45/100
📚 Normalização de Dados. 

Organizar tabelas

1️⃣ 1FN: cada campo com valor único (nada de listas).
2️⃣ 2FN: tudo depende da chave primária inteira.
3️⃣ 3FN: nada depende de outro campo não-chave.

💡100DaysOfSQL #MySQL

10 SQL Queries Every Developer Should Know by Heart. Get my full SQL learning guide here → codewithdhanian.gumroad.com/l/ohisv

e_opore's tweet image. 10 SQL Queries Every Developer Should Know by Heart.

Get my full SQL learning guide here → codewithdhanian.gumroad.com/l/ohisv

Here’s a snippet from schema.js and the Visualized Query Schema.

unix_machine's tweet image. Here’s a snippet from schema.js  and the  Visualized Query Schema.
unix_machine's tweet image. Here’s a snippet from schema.js  and the  Visualized Query Schema.

Day 2 of Julius’ Product Launch Week! Today we're announcing MySQL, now on Julius! PMs, founders, and engineers can now query MySQL in plain English and get instant charts & answers from your data – all without writing SQL.


Want to crack your next SQL interview? I’m giving away FREE access to “𝗦𝗤𝗟 𝗔𝗹𝗹 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 & 𝗔𝗻𝘀𝘄𝗲𝗿𝘀 (𝟭𝟬𝟬+ 𝗤𝘀 𝗳𝗿𝗼𝗺 𝗕𝗮𝘀𝗶𝗰 → 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱)” 📘 You’ll learn 👇 ✅ Joins, Subqueries, CTEs ✅ Window Functions & Optimization…

DAIEvolutionHub's tweet image. Want to crack your next SQL interview?

I’m giving away FREE access to “𝗦𝗤𝗟 𝗔𝗹𝗹 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 & 𝗔𝗻𝘀𝘄𝗲𝗿𝘀 (𝟭𝟬𝟬+ 𝗤𝘀 𝗳𝗿𝗼𝗺 𝗕𝗮𝘀𝗶𝗰 → 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱)” 📘

You’ll learn 👇

✅ Joins, Subqueries, CTEs
✅ Window Functions & Optimization…
DAIEvolutionHub's tweet image. Want to crack your next SQL interview?

I’m giving away FREE access to “𝗦𝗤𝗟 𝗔𝗹𝗹 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 & 𝗔𝗻𝘀𝘄𝗲𝗿𝘀 (𝟭𝟬𝟬+ 𝗤𝘀 𝗳𝗿𝗼𝗺 𝗕𝗮𝘀𝗶𝗰 → 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱)” 📘

You’ll learn 👇

✅ Joins, Subqueries, CTEs
✅ Window Functions & Optimization…

Understanding execution order of SQL queries! Before you can optimize SQL queries, you must understand their order of execution! The order of execution is different from how you write it, here's the actual order: 1️⃣ FROM: Determines the tables of interest 2️⃣ JOIN: Joins the…

akshay_pachaar's tweet image. Understanding execution order of SQL queries!

Before you can optimize SQL queries, you must understand their order of execution!

The order of execution is different from how you write it, here's the actual order:

1️⃣ FROM: Determines the tables of interest

2️⃣ JOIN: Joins the…

WHY. YOU. HAVE. A. SQL. QUERY. IN. A. FUCKING. JAVASCRIPT. CODE??? WHY. YOU. MAKE. HTTP. GET. REQUEST. WITH. THIS. SQL. QUERY. INSIDE???

Michel_Gaschet's tweet image. WHY. YOU. HAVE. A. SQL. QUERY. IN. A. FUCKING. JAVASCRIPT. CODE???

WHY. YOU. MAKE. HTTP. GET. REQUEST. WITH. THIS. SQL. QUERY. INSIDE???

After months of work its finally finished: 🔥 VISUAL EXPLAINS for MySQL: mysqlexplain.com Th cryptic output of MySQL's EXPLAIN is too hard to understand for any developer - even for me! So I built a tool to generate visual flows of whats happening. And its free! 🤯

tobias_petry's tweet image. After months of work its finally finished:

🔥 VISUAL EXPLAINS for MySQL:
mysqlexplain.com

Th cryptic output of MySQL's EXPLAIN is too hard to understand for any developer - even for me!

So I built a tool to generate visual flows of whats happening. And its free! 🤯

没事学点编程小知识: SQL 和 MySQL 的不同之处 #编程小知识 #网络小知识

knowledgefxg's tweet image. 没事学点编程小知识: 
SQL 和 MySQL 的不同之处
#编程小知识 #网络小知识

In which order SQL queries run?🔎👇 In SQL, the order in which queries are processed is typically defined by the logical query processing order. The logical query processing order is different from the order in which the SQL statements are written in the query. Here is the…

maybeshalinii's tweet image. In which order SQL queries run?🔎👇

In SQL, the order in which queries are processed is typically defined by the logical query processing order. The logical query processing order is different from the order in which the SQL statements are written in the query.

Here is the…

🚀 New MySQL Basics Blog Post Alert! 🚀 Ever felt overwhelmed scrolling through endless rows in your database? 📚 Say hello to pagination magic with LIMIT & OFFSET in MySQL—a must-have skill for every SQL newbie! #MySQL #SQL #Database social.ora.cl/6011AInjJ

mysql_community's tweet image. 🚀 New MySQL Basics Blog Post Alert! 🚀
Ever felt overwhelmed scrolling through endless rows in your database? 📚 Say hello to pagination magic with LIMIT & OFFSET in MySQL—a must-have skill for every SQL newbie!

#MySQL #SQL #Database
social.ora.cl/6011AInjJ

Want to learn SQL? 🖥️ Here is a map of all the most important SQL commands & functions you should know 👇

DanKornas's tweet image. Want to learn SQL? 🖥️

Here is a map of all the most important SQL commands & functions you should know 👇

Loading...

Something went wrong.


Something went wrong.


United States Trends