Re: Many to Many: Does this make sense ?

As for the RAD tool I'm open to suggestions, but I think I've read about them all. PHP - MySQL platform. Does it have to be PHP? If a java RAD is ok I would suggest http://jdbforms.sourceforge.net/ It does not allow multiple inserts from one page, BUT you can: 1) tack in some html (text area

slow select... where... order by

Hi I have a database with just over 10,000 records. with the following structure: id, compid, name, score, and about 10 other fields I have indexed id, compid, score about 10 records out of the 10,000 have a compid of 2 when i do select * from table where compid = 2 it was slow until i

Cross server selects?

Hi all. Just a quick syntax question. Is there a way to select rows from a different server database into the one currently in use? In other words, if I had two servers, is there something equivalent to saying (while using the client on server1): SELECT * FROM

Re: c api and creating looped queries

I have arranged some MySQL C API examples at http://www.geocities.com/jahan.geo/mysql_c_by_example.html Larry Brown wrote: On Sat, 2004-08-28 at 00:48, I wrote: I know this is more along the lines of a c question; however, I am trying to write a loop to iterate insertions into a mysql database and

Re: mysql c-api 1064 mysql_real_query: issue with upgrade to 4.1.3

Can you check the client version and server version from c api? you can copy paste it from (ehem) http://www.geocities.com/jahan.geo/mysql_c_by_example.html VY wrote: Hi, For some reason, all my sql queries fail with a 1064; These were all working under mysql-4.0 but had to upgrade to 4.1 so i

Access denied for root user

Hello, I've recently had my HD crash, and have reinstalled everything. Everything seems to work fine, apart from one thing. My MySQL server has decided to randomly set a root password. I have tried logging in with no password, tried it with my old password. Tried restarting the server with

Re: Many to Many: Does this make sense ?

Okay, hopefully I'm somewhat clearer today. I doubt it but the effort is going to be made regardless. First off, Rhino I read through your last post, regarding the phone number table. Yes I defintely understand it and see how each situation may warrant a different design. You gave scenarios

OT: Gmail

I have 3 invites - anyone interested? -- R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net Premium Quality Web Hosting http://hosting.xend.net [EMAIL PROTECTED] [EMAIL PROTECTED] 310-943-6498 602-288-5340 The day this country abandons God is the

InnoDB table creation

I was able to create all the tables below except ENROLLS. Can anyone please help me what is wrong in my syntax in the section that faild to create the ENROLLS table. CREATE TABLE STUDENTS (studentID SMALLINT NOT NULL, student_name char(18), address char(20), city char(10), state char(2), zip

Tables wrong or sql

I have two tables StatesTable CitiesTable StateID(char) RunningCountID (int) State (varchar) StateID (char) City (varchar) Both are innodb tables, with CitiesTable having a foreign key referencing StatesTable.StateID Basically my first step here

Re: InnoDB table creation

Mulugeta Maru wrote: I was able to create all the tables below except ENROLLS. Can anyone please help me what is wrong in my syntax in the section that faild to create the ENROLLS table. snip CREATE TABLE ENROLLS ( enrollmentID INT NOT NULL AUTO_INCREMENT, courseID SMALLINT NOT NULL,

Re: Tables wrong or sql

Stuart Felenstein wrote: I have two tables StatesTable CitiesTable StateID(char) RunningCountID (int) State (varchar) StateID (char) City (varchar) Both are innodb tables, with CitiesTable having a foreign key referencing StatesTable.StateID

Re: Access denied for root user

MueR wrote: Hello, I've recently had my HD crash, and have reinstalled everything. Everything seems to work fine, apart from one thing. My MySQL server has decided to randomly set a root password. No, it didn't. I know it seems that way, but I'm sure that's not what happened. I have tried

Re: slow select... where... order by

Critters wrote: Hi I have a database with just over 10,000 records. with the following structure: id, compid, name, score, and about 10 other fields I have indexed id, compid, score about 10 records out of the 10,000 have a compid of 2 when i do select * from table where compid = 2 it was slow

Re: Many to Many: Does this make sense ?

My replies are interspersed with Stuart's note. Rhino - Original Message - From: Stuart Felenstein [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Stuart Felenstein [EMAIL PROTECTED] Sent: Saturday, August 28, 2004 6:08 PM Subject: Re: Many to

Re: Replication eats 99% CPU

Thanks for your suggestion. I tried binary install but the problem doesn't disappear. Though mysql no longer consume 99% CPU, the load still go up till the server hangs. Wonder why. I seem to have a workaround now. My application does lots of INSERTs, and after I change them to INSERT DELAYED,