View Single Post
  #1  
Old 7th December 2008, 15: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