Hi folks,


I have a table tblPerdition created on dbPerdition

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

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;

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;

('userA'@'domainA.com')

???


TIA


B.R.
satimis

http://www.w3schools.com/sql/sql_insert.asp

INSERT INTO tablename (fieldlist) VALUES(columnValues) ;

Originally Posted by chrishirst

http://www.w3schools.com/sql/sql_insert.asp

INSERT INTO tablename (fieldlist) VALUES(columnValues) ;

Noted with thanks


B.R.
satimis

mysql> INSERT INTO user VALUES.

Here your table name user not found in your database. I think it should be tblPerdition.

Yeah, Jugal is right.

Also, on that note, SQL Server would fail that transaction, even if there was a table called User. You need to 'quote' the identifier, in whatever way is appropriate. That could be Insert [User] or Insert "User" etc, to let the database engine know you mean a data element that was created (ie not out of the box) instead of a reserved word.