CREATE OR REPLACE VIEW
CREATE OR REPLACE VIEW
MySQL va Oracle-da ko‘rinish CREATE OR REPLACE VIEW buyrug‘i bilan yangilanishi mumkin.
Quyidagi SQL "City" ustunini "Brazil Customers" ko‘rinishiga qo‘shadi:
Misol
CREATE OR REPLACE VIEW [Brazil Customers] AS
SELECT CustomerName, ContactName, City
FROM Customers
WHERE Country = "Brazil";
Ko‘rinishdan (view) so‘rov qilish
Yuqoridagi ko‘rinishni quyidagicha so‘rashimiz mumkin:
Misol
SELECT * FROM [Brazil Customers];
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!