How to create a new view in mysql?



How to create a new view in mysql?..

Answer / Khushboo A Risalat

To create a new view in MySQL, you can use the CREATE VIEW command. Here's an example:n```sqlnCREATE VIEW view_name AS SELECT * FROM table_name WHERE condition;```

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is a simple query?

1 Answers  


Can we save images in mysql database?

1 Answers  


Is mysql still relevant?

1 Answers  


How do I transfer data from one database to another in mysql?

1 Answers  


How big is a blob mysql?

1 Answers  


What are mysql queries?

1 Answers  


What is the latest version of mysql?

1 Answers  


Is mysql free download?

1 Answers  


How do I get a list of table names in mysql?

1 Answers  


How do I show users in mysql?

1 Answers  


What are all the Common SQL Function?

1 Answers  


What are the advantages of myisam over innodb?

1 Answers  


Categories