Рубрика: Data Bases

Comparison of relational and non-relational //coming soon Normal forms When working with databases, you should keep in mind the general approaches defined in so-called normal forms. These approaches allow you to create databases that are minimal in size, easily readable, and scalable. Usually it is used no higher than 3 normal forces (NF) with an […]

Basic commands for interacting with MySQL Show all available databases SHOW DATABASES; Create a new database CREATE DATABASE BD_Name; Delete database DROP DATABASE BD_Name; Select a database to use USE BD_Name; View available tables SHOW TABLES; Create table CREATE TABLE TB_Name1( id INT AUTO_INCREMENT PRIMARY KEY, field VARCHAR(255) NOT NULL); Table with associated foreign key […]