How does mysql modify the view

This article introduces the knowledge of "how to modify the view of mysql". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Use format 1, modify the view to query all id, and then use format 2 to modify the view to query all columns.

Format 1 is

ALTER VIEW View name AS SQL statement

Format 2 is

CREATE OR REPLACE VIEW View name AS SQL statement

2. Use format 1 to modify the view and navicat to view the view.

-- method 1ALTER VIEW `0817-user `ASSELECTidFROM`user`

3. Format 2 repeat format 1 step.

-- method 2CREATEOR REPLACE VIEW `0817-user` ASSELECT* FROM`user`

This is the end of the content of "how to modify the View of mysql". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!