Error 1347 Hy000
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 the company Business Learn more about hiring developers or posting
Mysql Alter View
ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join show views mysql 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
Mysql View
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 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 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 comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up us
that make connections all over the world. Join today Download & Extend Drupal Core Distributions Modules Themes DataIssues PDOException: SQLSTATE[HY000]: General error: 1347 when trying to set up index or primary key on adopted data table. ActiveProject:DataVersion:7.x-1.x-devComponent:CodePriority:NormalCategory:Bug reportAssigned:UnassignedReporter:RefineoCreated:October 24, 2012 - 11:58Updated:May 26, 2015 - 13:47 Log in or register to update this issue Jump to:Most recent comment Steps to reproduce http://stackoverflow.com/questions/32665610/alter-table-error-error-1347-hy000-table-name-is-not-base-table-in-mysql Install Drupal 7.16 Install Webform 7.x-3.18 or Webform 7.x-3.18+24-dev Install Webform MySQL Views 7.x-1.0 Install Pathauto 7.x-1.2 Install Data 7.x-1.x-dev Got to /node/add/webform Create node "test" of content type Webform Add textfield "New textfield" Save Go to /content/test and submit the webform submission Go to /admin/content/webform/mysql Select checkbox https://www.drupal.org/node/1821766 (test) and click submit Mysql view webform_views_test_1 should be available now Go to /admin/structure/data/adopt Select checkbox (webform_views_test_1 ) and click Adobt I receive the following warning message: Field webform_views_test_1.submitted: no Schema type for mysql type datetime. Go to /admin/structure/data/edit/webform_views_test_1 For field , select checkbox "index" (or "primary key") Click button "Save" Error I receive PDOException when trying to set up index on an adopted data table. PDOException: SQLSTATE[HY000]: General error: 1347 'database.webform_views_test_1' is not BASE TABLE: ALTER TABLE {webform_views_test_1} CHANGE `submitted` `submitted` INT NULL DEFAULT NULL; Array ( ) in db_change_field() (line 2988 of /***/includes/database/database.inc). The website encountered an unexpected error. Please try again later. Comments Comment #1 Refineo CreditAttribution: Refineo commented October 24, 2012 at 12:19pm Related issues: #1089598: Webform MySQL Views for Drupal 7 Modules: Webform MySQL Views Webform Log in or register to post comments Comment #2 plusproduit CreditAttribution: plusprodu
in mysql Results 1 to 1 of 1 Thread: Mysql - alter table error ERROR 1347 (HY000): 'table-name' is not BASE TABLE in mysql LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this http://queforum.com/mysql/1014495-mysql-alter-table-error-error-1347-hy000-table-name-not-base-table-mysql.html Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Email http://terukizm.hatenablog.com/entry/20111006/1317890020 this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-19-2015,08:00 AM #1 alex Senior Member Join Date Jul 2013 Posts 65,077 Mysql - alter table error ERROR 1347 (HY000): 'table-name' is not BASE TABLE in mysql Recently I attempted to add a column to one of the tables of my error 1347 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? Check Solution Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « error 1347 hy000 Previous Thread | Next Thread » Similar Threads Mysql - Alter table with enum column gives mysql error in php script By alex in forum Mysql Replies: 0 Last Post: 05-07-2014, 02:31 PM Mysql - Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'babysoft_st By alex in forum Mysql Replies: 0 Last Post: 03-08-2014, 12:40 PM Mysql - ERROR 1114 (HY000): The table 'XXX' is full By alex in forum Mysql Replies: 0 Last Post: 02-18-2014, 10:11 AM Php - Can't find table (SQLSTATE[HY000]: General error: 1 no such table: users) By bigdata in forum PHP Replies: 0 Last Post: 01-16-2014, 08:50 PM Mysql - MySQL - create table error 3 [HY000] By alex in forum Mysql Replies: 0 Last Post: 12-07-2013, 05:50 PM Bookmarks Bookmarks Digg del.icio.us StumbleUpon Google Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On [VIDEO] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules -- Default Style -- Default Mobile Style QueForum Archive Top All times are GMT. The time now is 10:54 AM. cpp tutorials | Powered by vBulletin Version 4.2.2
限定公開記事のため引用できません。 読者です 読者をやめる 読者になる 読者になる いっぽんの猟銃のむこうに (DAIZOじいさんとGun) ヌルめの技術メモとか。フリーランスやってます (http://acez.jp/) 2011-10-06 ERROR 1347 (HY000): 'DBNAME.TABLENAME' is not BASE TABLE MySQL なんでこうなるのかはわからないが、トリガ中でデータ型が違うSQLを書くと （例: SYSDATE()をvarcharカラムに叩きこむ）このエラーが出る。 にしてもMySQLは謎のエラーメッセージが多い。 tkizm 2011-10-06 17:33 ERROR 1347 (HY000): 'DBNAME.TABLENAME' is not BASE TABLE list Tweet 広告を非表示にする もっと読む (0) コメントを書く « ファイル中の特定文字列数をカウントする MySQLではDELETE文のfrom句で指定する表… » プロフィール id:tkizm ヌルめの技術メモとか。 読者です 読者をやめる 読者になる 読者になる 検索 リンク はてなブログ ブログをはじめる（無料） お知らせ はてなブログ グループ 最新記事 Solr4.4で日本語検索する場合のschema.xmlフィールド設定メモ やっつけでCentOS6.4のTomcat6でSolr4.4を動かす Debian Wheezy(7.1)へVagrantをさっくり入れる AWS無料枠を使って『艦これ』をモバイルデバイスから遊ぶ 前編 AWS無料枠を使って『艦これ』をモバイルデバイスから遊ぶ 後編 月別アーカイブ tkizm Powered by Hatena Blog