MySQL TEMPORARY TABLE
Тимчасові таблички зникають коли ви закінчуєте сесію або їх можна знищити традиційно-
DROP TEMPORARY TABLE table_name;
Спробуємо на тій саммій базі.
Та сама табличка Customers.
SELECT * FROM temp_customers;
DROP DATABASE base2;
CREATE DATABASE base2;
USE base2;
CREATE TABLE Customers
(
Id INT PRIMARY KEY AUTO_INCREMENT,
Age INT,
FirstName VARCHAR(20) NOT NULL,
LastName VARCHAR(20) NOT NULL,
Phone VARCHAR(20)
);
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (18,'Ganna','Velickiv','0688889977');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (19,'Ury','Medvejuy','0688889988');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (39,'Anton','Chernov','0687889988');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (22,'Anna','Ignatss','0687885988');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (32,'Olga','Hiv','0681885988');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (18,'Oksana','Velickiv','0688889971');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (14,'Victor','Medvejuy','0688889982');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (33,'Inna','Chernov','0687889983');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (27,'Elen','Ignatss','0687885984');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (31,'Olga','Helles','0681885985');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (18,'Zina','Velickiv','0688889977');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (14,'Valery','Medvejuy','0688889988');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (33,'Inna','Velickiv','0687889989');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (27,'Elen','Ignatss','0687885980');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (31,'Anna','Illyv','0681885981');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (18,'Ganna','Stas','0088889977');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (19,'Ury','Medvejuy','0088889988');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (39,'Anton','Chernov','0087889988');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (22,'Anna','Ignatss','0087885988');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (32,'Olga','Ann','0081885988');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (18,'Oksana','Velickiv','0288889971');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (14,'Victor','Medvejuy','0388889982');
INSERT Customers(Age, FirstName, LastName, Phone)
VALUES (33,'Inna','Chernov','0387889983');
Перевіримо.
TABLE Customers;
Зробимо тимчасову табличку Customers2
CREATE TEMPORARY TABLE Customers2
SELECT Age, FirstName, LastName, Phone
FROM Customers ;
Зробимо тимчасову табличку Customers2 де будуть тільки кустомерси з віком більш за 19.
CREATE TEMPORARY TABLE Customers3
SELECT Age, FirstName, LastName, Phone
FROM Customers
HAVING Age більш 19;
Створимо традиційну табличку.
CREATE TABLE Customers4
SELECT Age, FirstName, LastName, Phone
FROM Customers ;
Перевіримо існування табличок.
TABLE Customers;
TABLE Customers2;
TABLE Customers3;
TABLE Customers4;
Вийдемо з MySQL
quit
Та повернемось
sudo mysql
TABLE Customers;
TABLE Customers2;
TABLE Customers3;
TABLE Customers4;
Тимчасові таблички зникли
Створимо одненьку табличку наново
CREATE TEMPORARY TABLE Customers2
SELECT Age, FirstName, LastName, Phone
FROM Customers ;
Перевіримо
TABLE Customers2;
Знищимо
DROP TEMPORARY TABLE Customers2;
Перевіримо
TABLE Customers2;
Watch video MySQL TEMPORARY TABLE online without registration, duration hours minute second in high quality. This video was added by user spa it 26 January 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 73 once and liked it 8 people.