-- alias
#An alias in MySQL is a temporary name given to a table or column in a query to make it easier to read and work with

#Use Cases:
#Shorten long column/table names.
#Improve query readability, especially when using complex queries.
#Avoid ambiguity when multiple tables have columns with the same name (useful in JOINs).

CREATE TABLE customer6(
    acc_n0 INT PRIMARY KEY AUTO_INCREMENT,   # no need to write again and again
    name VARCHAR(50) NOT NULL,
    acc_type VARCHAR(50) NOT NULL DEFAULT 'SAVINGS'
    );

INSERT INTO customer6 (name) VALUES ('SIDDHARTH TIWARI');
INSERT INTO customer6 (name) VALUES ('TIWARI');

SELECT acc_n0 AS 'Account No', name AS ' CUSTOMER NAME' FROM customer6; # if we want to change at compile time that why we use alias
select acc_n0 AS "Dhibi wala", name AS 'NAHCO' from customer6;
SELECT * FROM customer6;