help with index on table

Hi I tried to create an index on one of my tables. After creating this index, the queries return an empty set, instead of the expected result. I have a table user looks like this: id - int(11) username - varchar(250) address - varchar(250) more columns... After creating an index: CREATE INDEX

Using index returns an empty esult set

Hi I tried to create an index on one of my tables. After creating this index, the queries return an empty set, instead of the expected result. I have a table user looks like this: id - int(11) username - varchar(250) address - varchar(250) more columns... After creating an index:

Query multiple tables

Hi, How do I query multiple tables. For example I have TableName Accommodation Field1 AccommodationID Field2 AccommodationName I also have TableName Attractions Field1AttractionID Field2 AttractionName Field3

MS Access gives error no. -7776.

Dear Friends, I have connected MS Access to MySQL 5.0.17 with MyODBC 3.51.12 with MS Jet SP 8. It is giving error -7776 (There is no message for this error) while jumping from a form to a subform having two different tables for these tow forms as recordsource. Can any one please help me. It's

Re: MS Access gives error no. -7776.

Hi CPK, I suppose you've looked at the manual in: http://dev.mysql.com/doc/refman/5.0/en/myodbc-examples.html It you still have problems, try just the linked table, without forms. If you can view the linked MySQL tables in MS Access, then the problem has to do with the forms, and not with the

Re: Query multiple tables

What query do I need to get AccommodationName and what attractions it has from AccommodationAttractions SELECT ac.accommodationname, at.attractionname aa.AccomodationAttraction FROM accommodationattractions AS aa INNER JOIN accommodations AS ac USING (accommodationid) INNER JOIN

Re: Problems with: MySQL 5.0.21 - 64bit

Spoken too soon... Yesterday MySQL died again... there is nothing in the log files... (be it mysqld.log, .err, or /var/log/messages). The hosting provider is running an application called 'big-brother' and a lot of sef-faults appear in the logs from this. I don't know if thins is the cause...

Re: Problems with: MySQL 5.0.21 - 64bit

Hi Gabriel, Yesterday MySQL died again... there is nothing in the log files... (be it mysqld.log, .err, or /var/log/messages). The hosting provider is running an application called 'big-brother' and a lot of sef-faults appear in the logs from this. I don't know if thins is the cause... if this

PostgreSQL or mySQL

Hello List: I hope my question does not start war of the posts. This question is genuine. Please answer objectively: I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS, DNS, Apache, (mySQL PostgreeSQL), PHP, Postfix, etc. This Master Server will have all the software I we

Re: howto set mysql to readonly

Hi Jehan, OK so it seems to be a bad idea ... I was expecting that I missed a magic command like set readonly on all databases ... I think you did: SET GLOBAL read_only=1; This will keep all non-SUPER and non-replication users from writing to the database. Regards, Jeremy -- high

Re: MS Access gives error no. -7776.

C K wrote: Dear Friends, I have connected MS Access to MySQL 5.0.17 with MyODBC 3.51.12 with MS Jet SP 8. It is giving error -7776 (There is no message for this error) while jumping from a form to a subform having two different tables for these tow forms as recordsource. Can any one please

Works in SQL Manager, but not PHP?

MySQL version 5.0.16 Windows XP PHP 5. I have this query that when I run it in SQL Manager 2005, it runs beautifully, but when I stick the same query in Dreamweaver using PHP - MySQL I get an error. I did some research and most roads lead to version compatibility. Okay, that's fine, but I'm

Re: Works in SQL Manager, but not PHP?

Brian Menke wrote: MySQL version 5.0.16 Windows XP PHP 5. I have this query that when I run it in SQL Manager 2005, it runs beautifully, but when I stick the same query in Dreamweaver using PHP - MySQL I get an error. I did some research and most roads lead to version compatibility.