Error 1347
Contents |
IDE Get Started Here Installation Minimum System Requirements Minimum Compiler Requirements Install MPLAB error 1347 mplab X IDE Linux 64-bit Dependencies Mac OSX 10.7+ Dependencies How
Windows Error 1347
to replace Java version installed with MPLABĀ® X IDE Migration from MPLAB IDE v8 Migrating
Error 1347 Hi Tech
to MPLABĀ® X IDE from v8 Major Differences Menu Comparison Menu Comparison File Menu Differences Edit Menu Differences View Menu Differences Project Menu Differences Debugger
Error 1327
Menu Differences Programmer Menu Differences Tools Menu Differences Configure Menu Differences Window Menu Differences Help Menu Differences Tool Support Differences Migration Considerations Configuration Configuration Running Multiple Instances Switching USB Drivers (Windows) Manually Install USB Drivers (Windows) JVM Configuration Options Reset to Default State Options Window Options Window General General Editor Editor error 1347 mysql General Formatting Code Completion Code Templates Hints Macros Fonts & Colors Fonts & Colors Syntax Highlighting Annotations Diff Versioning Keymap Keymap C/C++ C/C++ Highlighting Embedded Embedded Build Tools Project Options Generic Settings Suppressible Messages Diagnostics Other Miscellaneous Miscellaneous Appearance Diff Files Issue Tracking Java Script Spell Checker Tasks Terminal Versioning Make MPLAB X IDE Run Faster Project Properties Memory Usage License Manager Hardware Tool Connections Project Build Speed Debug Simulator Speed Operating Systems Plug-ins Plug-ins Plug-ins Window Plug-ins Window Updates Tab Available Plugins Downloaded Tab Installed Tab Settings Tab Microchip Plug-ins Install a Microchip Plug-in MPLAB Code Configurator (MCC) Data Monitor and Control Interface (DMCI) Data Monitor and Control Interface Modes Requirements Installation Modify Capture RTDM Mode Runtime Watch Mode Videos Code Profiler Code Profiling Capabilities Requirements Plug-in Installation Plug-in Setup Starting the Code Profiler Code Profiling Window Graphing Profile Data Code Profiling Controls PCLint PCLint Gimpel PC-LINT/MISRA In
Posts Today's Posts 1Next > Oct 31, 2013 #1 kuannygohcheetatt Thread Starter Member Oct 31, 2013 61 0 Code ( (Unknown Language)): //bimary 0b110 //hexadecimal 0xA //dec imal 110 #define XTAL_FREQ 4MHZ #include
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 the company Business Learn more about http://stackoverflow.com/questions/32665610/alter-table-error-error-1347-hy000-table-name-is-not-base-table-in-mysql hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 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 vote favorite Recently I attempted to add a column to one of the error 1347 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 of that? mysql alter-table share|improve this question asked Sep 19 '15 at 7:34 Kasramvd 55.4k63773 In order to error 1347 mplab 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 at 7:41 Adrian Lynch 3,86611325 What would be after AS SELECT? –Kasramvd Sep 19 '15 at 9:38 I think view doesn't support add command! at all! –Kasramvd Sep 19 '15 at 10:09 add a commen