Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 7th December 2008, 16:19
satimis satimis is offline
Senior Member
 
Join Date: Oct 2006
Posts: 533
Thanks: 4
Thanked 2 Times in 2 Posts
Default Problem on editing data on MySQL table

Hi folks,


I have a table tblPerdition created on dbPerdition

Code:
mysql> SHOW tables;
+-----------------------+
| Tables_in_dbPerdition |
+-----------------------+
| tblPerdition          |
+-----------------------+
1 row in set (0.00 sec)

Code:
mysql> DESCRIBE tblPerdition;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| user       | varchar(128) | NO   | PRI |         |       |
| servername | varchar(255) | NO   |     |         |       |
| port       | varchar(8)   | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

On editing data on the table;

Code:
mysql> INSERT INTO user VALUES
    -> ('userA@domainA.com'),
    -> ('userA@domianB.com'),
    -> ('userA@domainC.com');
ERROR 1146 (42S02): Table 'dbPerdition.user' doesn't exist

Please advise how to fix the problem? Whether I need to edit;
Code:
('userA'@'domainA.com')
???


TIA


B.R.
satimis
Reply With Quote
Sponsored Links
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
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
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 02:05
Problem Installing Apache 2.2.8, MySQL 5.0 Client and PHP 5.2.5 On Fedora 8 (64-Bit) asyadiqin Installation/Configuration 5 10th April 2008 19:40
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 18:03
Site with MySQL problem?! edge Server Operation 2 13th August 2006 20:57
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37


All times are GMT +2. The time now is 11:52.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.