Knowledge Walls
John Peter
Pune, Maharashtra, India
Mysql
Cursor View Trigger Stored Procedure Function
JQuery
HTML-Jquery Program template
JAVA
Main method basic template Class template example
HTML
Table HTML basic template HTML UL Tag Template HTML Form with File Upload Template
View in Mysql of Code Template
3785 Views
Create View
CREATE VIEW view_name AS
SELECT rno,name FROM STUDENTS;
Run Views
SELECT * FROM view_name;
SELECT * FROM view_name WHERE rno = 1001;
Replace existing view
CREATE OR REPLACE VIEW view_name AS
SELECT rno,name FROM umt_user;
Show created views
-- Show all views names
SHOW FULL TABLES IN db_name WHERE TABLE_TYPE LIKE 'VIEW';

-- Show View source
SHOW CREATE VIEW view_name;
DROP View
DROP VIEW view_name;
DROP VIEW IF EXISTS view_name;
Previous Topics
Previous lessons of current book.
Mysql of Code Template
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details