This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- MySQL DISTINCT Tutorial | |
-- The DISTINCT clause eliminates duplicate rows from the result set | |
-- Syntax: SELECT DISTINCT column1, column2 FROM table_name; | |
-- Create and use the database | |
CREATE DATABASE EmployeeDB; | |
USE EmployeeDB; | |
-- Create employees table | |
CREATE TABLE employees ( |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- MySQL Aliases Tutorial | |
-- Aliases are temporary names assigned to database tables, columns, or expressions | |
-- to make them more readable and manageable. | |
-- Create and use the database | |
CREATE DATABASE db16; | |
USE db16; | |
-- Create employees table | |
CREATE TABLE employees ( |