SQL Views Question
Quick question on MySQL Views...
Once a view is created, is there a way to retrieve the SQL behind it at a later date in case I want to alter it?
Quick question on MySQL Views...
Once a view is created, is there a way to retrieve the SQL behind it at a later date in case I want to alter it?
teammatt3 posted this at 22:49 — 4th August 2010.
He has: 2,102 posts
Joined: Sep 2003
Yup: SHOW CREATE VIEW
SHOW CREATE VIEW `ViewName`
Never used it myself. I use the old MySQL GUI tools, but I tested the SQL and it works.
shivendra posted this at 05:21 — 23rd May 2013.
They have: 9 posts
Joined: May 2013
Well, SQL (Structured Query Language) is a way to request something from a database. It's not a programming language, but more of a requesting language.
pr0gr4mm3r posted this at 23:11 — 4th August 2010.
He has: 1,502 posts
Joined: Sep 2006
That works. I know I'm going to create a view and then forget what the heck I did later on or must tweak it slightly w/o having to recall it.
Thanks
Shivendra9411 posted this at 04:53 — 26th April 2013.
They have: 12 posts
Joined: Apr 2013
ALTER VIEW myView (id,first_name,city)
-> AS SELECT id, upper(first_name), city FROM employee;
spinxweb2 posted this at 08:35 — 26th August 2010.
They have: 3 posts
Joined: Aug 2010
hi,
I also use the old MySQL GUI tools, but I tested the SQL and it works or not.
Birkenstock posted this at 09:35 — 5th May 2011.
They have: 5 posts
Joined: Apr 2011
Of course !!
jessicaellen posted this at 01:49 — 6th May 2011.
They have: 31 posts
Joined: Nov 2010
Yes my dear you can alter view. Here is the query for alter a view.
ALTER VIEW myView (id,first_name,city)
-> AS SELECT id, upper(first_name), city FROM employee;
Query OK, 0 rows affected (0.00 sec)
zani posted this at 11:14 — 9th June 2011.
He has: 2 posts
Joined: May 2011
tell me friend
login join date show after login (sql query)
Hire Developer posted this at 05:08 — 31st July 2012.
They have: 26 posts
Joined: May 2012
Well, SQL (Structured Query Language) is a way to request something from a database. It's not a programming language, but more of a requesting language.
giffy posted this at 05:38 — 14th December 2012.
They have: 15 posts
Joined: Dec 2012
thanks for the help !!
RohanJaiswal posted this at 05:18 — 24th April 2013.
They have: 11 posts
Joined: Apr 2013
view is the virtual table which is create by admin for the different diiferent users to access the information
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.