This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes [root@localhost:3306] ERROR 1146: Table 'xxx.1' doesn't exist Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "[root@localhost:3306] ERROR 1146: Table Watch "[root@localhost:3306] ERROR 1146: Table New topic
Author

[root@localhost:3306] ERROR 1146: Table 'xxx.1' doesn't exist

biswajit ray
Ranch Hand

Joined: Nov 30, 2005
Posts: 30
i m using mysql version(5.016,server).and mysqlcc 0.94(beta). when i m going to create a table in database(biswajit) i m getting an error like
[root@localhost:3306] ERROR 1146: Table 'biswajit.1' doesn't exist.though i m able to creat a table say(xyz) in the database(biswajit) but after insertion of datas in the table the datas remain nolonger valid.ie data becomes empty after i come out from the table.that means when for the second time i am opening the table all the columns are vacant with the above said error.
Plz help me in this regard.
biswajit
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: [root@localhost:3306] ERROR 1146: Table 'xxx.1' doesn't exist