Tag feed

#foreign-key

14 posts0 followers

Explore Hashnode

Alternatives

Trending tags this week

KKKrishal Karnacompletesql.hashnode.devAug 14, 2025 · 8 min read

Introduction to Databases and MySQL

Imagine you’re sitting in an interview. The interviewer looks at you and asks,"What is data?" You might be tempted to say something like, “Data is anything that exists on Earth… numbers, letters, symbols, all of that right?” Then they hit you with th...

0

SUSharif Uddinsharif-web-dev.hashnode.devJul 23, 2025 · 2 min read

How to Disable Foreign Key Checks in MySQL .sql File to Fix Database Import Errors

🔐 Disabling Foreign Key Checks in MySQL: When and How to Use SET FOREIGN_KEY_CHECKS = 0 Thankfully, MySQL provides a solution: SET FOREIGN_KEY_CHECKS = 0; 💡 What is FOREIGN_KEY_CHECKS? FOREIGN_KEY_CHECKS is a MySQL system variable that controls whe...

0

GRGanesh Rama Hegdevedicschema.hashnode.devApr 5, 2025 · 4 min read

2. Tables, Entities, and RDBMS

In a database design design we are discuss these three important topics - Tables, Entities and RDBMS. You may ask why ? Aren’t you digressing from the topic ? I would like to say that we would be using these concepts as the building blocks of our des...

0

GRGanesh Rama Hegdevedicschema.hashnode.devApr 5, 2025 · 3 min read

1. Databases, Database Design and SQL

In today’s modern digital world dominated by Artificial Intelligence and Machine Learning, data is the new fuel. Data is at the core of every application - from fitness apps, healthcare and e-commerce to banking and social media. We use databases to ...

0

GRGanesh Rama Hegdevedicschema.hashnode.devApr 5, 2025 · 4 min read

3. SQL (Structured Query Language) - Part 1

What is SQL ? SQL (Structured Query Language) is the standard language used to create, read, update, and delete data in a relational database. Why is SQL important ? It allows us to communicate with the database and manage data effectively. Types of ...

0

DCDanny Crastoblog.danwald.meDec 24, 2024 · 2 min read

Foreign Key with missing indexes

Relational databases have references to other tables via 1-Many relationships using a foreign key. CREATE TABLE Bar( id int NOT NULL, name varchar(128), PRIMARY KEY (id) ); CREATE TABLE Foo ( id int NOT NULL,...

0

RRohanrohansblog.hashnode.devNov 24, 2024 · 4 min read

Django ORM: Accessing foreign key objects

One to many, many to one relationships For demonstration, let’s create a Django project and start an app call books. We will take the example of the relationship between books and reviews and create two simple models for them. As you know, one book c...

0

DDataWisokadatawisoka.comJul 3, 2024 · 7 min read

Choosing the Right Database: Data modeling in Postgres vs DynamoDB

Data modeling is the blueprint for how your data is structured, stored, and accessed. The choice between a relational database like Postgres and a NoSQL database like DynamoDB often hinges on different data modeling philosophies and application requi...

0

RRRicardo Ribeirokaitozr.hashnode.devJun 5, 2024 · 2 min read

Coletando ids do banco de dados (.NET x SQL SERVER)

Trabalhando com edição de dados no banco utilizando o .NET, encontrei a dificuldade de puxar as keys do banco de dados para o código no Visual Studio. A primeira solução que pensei para isso foi criar uma textBox que serviria como um placeholder que ...

0

JNJatu Naazneenblog.naazweb.comFeb 18, 2024 · 3 min read

Data Organization: Flattened vs. Nested Foreign Keys

Organizing your data effectively is crucial for a smooth-running platform, particularly when managing multiple tables. One key decision you'll face is choosing between nested foreign keys and flattened foreign keys to establish relationships among th...

0

#foreign-key

Search Hashnode

#foreign-key

Explore Hashnode

Trending tags this week

Introduction to Databases and MySQL

How to Disable Foreign Key Checks in MySQL .sql File to Fix Database Import Errors

2. Tables, Entities, and RDBMS

1. Databases, Database Design and SQL

3. SQL (Structured Query Language) - Part 1

Foreign Key with missing indexes

Django ORM: Accessing foreign key objects

Choosing the Right Database: Data modeling in Postgres vs DynamoDB

Coletando ids do banco de dados (.NET x SQL SERVER)

Data Organization: Flattened vs. Nested Foreign Keys