Error 1146 trying add data to table in database

[mwesol]

Hi, MYSQL newbie.

Anyways I was playing around with MYSQLCC (Control Center) and when I try and add data to a table it errors out with error 1146.

error 1146. table test. doesn't exist.

It was working before but now it says the table doesn't exist. There is a database test and a table called data.

Why is it askiing for a table name that doesn't exist.

Thanks
Mike

 

[QatQat]

Reading you message you say


table TEST. DOES NOT EXIST.

MySQL refers to tables into databases by writing the database name followed by 'dot' and a table name.

You are therefore trying to access a table with no name in the test DB

test.

Try to specify the name of the table (data) properly or send us the SQL script you are working on.



Bye


Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[JustKIDn]

Just a little add-on to QatQat's reply;

By default 'TEST' DB has no tables at all.

You're better off creating a new DB and then create tables within that if you want to do testing.

You'll learn more too, if you start at the begining.
tgus

____________________________
Families can be together forever...

 

[mwesol]

Actually this is kind of weird but I have MYSQLCC installed on my WIN98 Laptop. It worked fine and now will not let me add data or query the database. I get the 1146 errors. I try MYSQLCC on Windows 2000 at work and on WINXP system at another location and it works just fine.

I uninstalled MYSQLCC on my laptop and reinstalled and still have the same problem. Its like it got corrupted on my LAPTOP. You would think If I uninstalled it from my laptop and reinstall it would fix the problem. Perhaps its a registry setting that didn't get wiped out on the uninstall. Very strange.

Any thoughts?

Thanks
Mike

 

[JustKIDn]

Go to your c:\ drive. Delete the .mysqlcc directory.
And try it again.

Also what version are you using?

There is a new version 0.9.1 I think. And they are recommending that everyone start using that one.

But delete that .mysqlcc directory first. (not needed for the new install. only to fix your problem)

tgus

____________________________
Families can be together forever...

 

[mwesol]

I was using 0.9.0. I did delete the mysqlcc directory that is why I am thinking it may be a registry setting. I will install the lastest and see what happens.

Mike

 

[JustKIDn]

I'm not talking about the 'mysqlcc' directory.

I'm talking about the '.mysqlcc' directory off the root of C:\ drive. (notice the '.' (dot) before mysqlcc)

This directory appears to keep config info for mysqlcc.

tgus

____________________________
Families can be together forever...

 

[mwesol]

Tgus

Ok I will check it when I get home from work. I noticed that windows 2000 does not create a .mysqlcc on the root of c: I guess this must be for windows 98 then?

Mike

 

[QatQat]

Hi Mwesol,

Win NT based systems create .mysqlcc directory in the user's home, so c:\documents and settings\user\.mysqlcc

I strongly suggest that you start using more of command prompt and less of control center.

We will give you all help you need in your learning process.
MySQL is a very simplified although powerful server. I don't think you can take advantage of any of the goodies in it from a GUI.

Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[JustKIDn]

Thanks for that QatQat. I knew it had to be somewhere. I didn't realize it was different on NT. (can you tell I'm not using NT right now?)

About the GUI:
You're probably very right about that. But for some of us, let us learn the basics in the GUI first. If we can learn to do it when we can see it. We may understand it better when were doing it 'blind'.

One advantage to the GUI is, you can see the query language being written for you when you make changes.
(eg. you add a new field between two other existing fields)
It's hard to know that one off the top of your head.

But I am curious; what are we missing? What can you do better with the command prompt.
tgus

____________________________
Families can be together forever...

 

[mwesol]

What is interesting is the delete the .mysqlcc uninstalled mysqlcc and rebooted and reinstalled the new version 0.9.1 and still have the problems. I access the databases and see the tables.. I can click into the table and modify it. If I try to double click on the table to insert data, it says the error 1146 and says that the data will take to long. There are only 3 records in the this test database. I do it from a AOL dialup account and access it and am able to add records. I do this also from other machines on my home network and can access it and put data in the tables just fine. It did you an experiment, I edited the connection and clicked on TEST connection. It said now connecting and just stayed there and didn't popup that it made a connection like it did for all the other pc's. Yet I can connection to the database and see the tables. Just can't add any data. Also.. I am doing this from my laptop which is on a wireless connection. I don't think that has anything to do with it as it worked before that way. Its just very strange. I wonder if it is a networking issue? Maybe I should try hooking directly up to the network with the cat5 and see if it works that way.

Appreciate the help!

Mike

 

[JustKIDn]

Mike,

That sounds like a good idea.
Try connecting with the wire and see if that works. Because maybe there's something in the protocol that's blocking you.
tgus

____________________________
Families can be together forever...

 

[PAOwen]

Mike,

I know this thread is a little out of date and you may have solved your problem but, just in case not....

If you uninstalled mysqlcc 0.9.0 it left behind your settings for the server and one of those tells how many row to return and is probably set at '1'. Change it to a larger number and you should get over your problem.