Error 1347 Mysql
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow error 1347 (hy000): is not base table the company Business Learn more about hiring developers or posting ads with us Stack
Mysql Error 1347 (hy000): Is Not Base Table
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of mysql error code 1347 is not view 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up alter table error ERROR 1347 (HY000): 'table-name' is not BASE TABLE in mysql up vote 0 down is not base table mysql vote favorite Recently I attempted to add a column to one of the tables of my database which has 316 table but after the following command: mysql> ALTER TABLE view_Server ADD rsh_protocol VARCHAR(60); I get the following error : ERROR 1347 (HY000): 'itop.view_Server' is not BASE TABLE all my searches was unsuccessful like using '``'. So the question is that what's the reason of this error? and how can I git ride
View Is Not Base Table
of that? mysql alter-table share|improve this question asked Sep 19 '15 at 7:34 Kasramvd 55.4k63773 In order to change a view, you need to change the query definition of the view. You may need to alter the base table that the view is relying on, –ESG Sep 19 '15 at 17:22 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted From your "table" name, are you trying to add a column to a view? Run through each of these: CREATE TABLE x (id INT, name VARCHAR(255)); INSERT INTO x VALUES (1, 'One'); INSERT INTO x VALUES (2, 'Two'); -- A view with no change of column names CREATE VIEW y AS SELECT id FROM x; SELECT * FROM y; -- Change the view, again using the base table column names ALTER VIEW y AS SELECT name FROM x; SELECT * FROM y; -- Change the view, switching column name from `name` to `theName` ALTER VIEW y (theName) AS SELECT name FROM x; SELECT * FROM y; -- Change the view, switching column name to `anotherName` by aliasing in the SELECT ALTER VIEW y AS SELECT name anotherName FROM x; SELECT * FROM y; share|improve this answer edited Sep 19 '15 at 17:19 answered Sep 19 '15
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Views :: Help: [Err] 1347 - sales.v_products' is not VIEW New Topic Advanced mysql alter view Search Help: [Err] 1347 - sales.v_products' is not VIEW Posted by: show views mysql Asad Raza () Date: October 16, 2011 01:58AM Dear All, I am stuck with a very strange
Create Trigger Mysql
issue. Let me provide its detail. I was using MySQL 5.1.47 in production since more than a year. Few days back I upgraded MySQL to Mysql 5.5.516 version http://stackoverflow.com/questions/32665610/alter-table-error-error-1347-hy000-table-name-is-not-base-table-in-mysql and found that I can't deploy VIEWS which was not giving any issues before. Whenever I deploy views it says "[Err] 1347 - sales.v_products' is not VIEW" Can anybody please suggest me its fix as I am almost at the dead end. Any help would be greatly appreciated. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Views Written By Posted http://forums.mysql.com/read.php?100,472891,472891 Help: [Err] 1347 - sales.v_products' is not VIEW 4856 Asad Raza 10/16/2011 01:58AM Re: Help: [Err] 1347 - sales.v_products' is not VIEW 2571 Devart Team 10/16/2011 11:42PM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Partners Job Opportunities Site Map Documentation MySQL Reference Manuals MySQL Workbench Expe
2005 23:44 Reporter: Disha Email Updates: Status: Closed Impact on me: None Category:MySQL Server Severity:S2 (Serious) Version:5.0.2 OS:Microsoft Windows (Windows Server 2003) Assigned to: Sergey https://bugs.mysql.com/bug.php?id=8921 Petrunya View Add Comment Files Developer Edit Submission View Progress Log Contributions [3 Mar 2005 14:18] Disha Description: We are permitted to create a View and a temporary table with the same name whereas, creating a temporary table with the same name as that of an existing view should not be allowed as it creates conflicts while referencing the view/table. How to is not repeat: Repro Steps: 1. Delimiter // 2. Create database test1// 3. Use test1 // 4. Create table T1 (f1 char(20), f2 TEXT(25), f3 DATE, f4 int)// 5. Insert into T1 ('ABC','XYZ','1990-05-07',100)// 6. Create Temporary Table VTAB (f1 char(4),Tempf2 char(8)) // 7. Insert into VTAB values ('AAA','BBB') // 8. Select * from VTAB// 9. Create View VTAB AS select * from T1// 10.Select * is not base from vtab// Expected Results : Creation of a temporary table and view with the same name should not be allowed Actual Results : Temporary Table and View with the same name can be created Additional Info: If we try to create a normal table and view with the same name, table/view creation fails with an appropriate error. [3 Mar 2005 14:21] Disha Changed synopsis and Severity [3 Mar 2005 15:11] Jorge del Conde Verified using 5.0.3 from bk THanks for your bug report [16 Mar 2005 16:11] Paul Dubois Additional information: If there is a temporary table with the same name as a view, SHOW CREATE VIEW gets confused as long as the temporary table exists: mysql> create temporary table tmp (i int); Query OK, 0 rows affected (0.00 sec) mysql> create view tmp as select * from t; Query OK, 0 rows affected (0.00 sec) mysql> show create view tmp; ERROR 1347 (HY000): 'test.tmp' is not VIEW mysql> drop table tmp; Query OK, 0 rows affected (0.00 sec) mysql> show create view tmp; +------+----------------------------------------------------------------------------------------------+ | View | Create View | +------+----------------------------------------------------------------------------------------------+ | tmp | CREATE ALGORITHM=UNDEFI