Recent content by doddo

Hi, I read this with interest. Has anybody noticed really bad performance when trying to do such joins with Mysql? A simple example of a join below SELECT Raw.Category, Raw.Filename FROM Raw LEFT JOIN Marker ON Raw.Category = Marker.MarkerName GROUP BY Raw.Category, Raw.Filename...

Hi, I made a copy of safe_mysqld, ammended it and then replaced the old copy with the new one. Does anyone know why I am getting a 'no such file or directory' error when I try to execute it now? -rwxr-xr-x 1 mysql mysql 8396 Dec 13 15:02 safe_mysqld thanks in advance Richard

hi I am connecting to a db on the same machine as the one that I am on. I can connect to the server from the command line but can't connect via JDBC. The error claims a bad handshake. The weird thing is that the script will connect to other servers. Does anybody know what this could be? cheers Rich

Hi, did you get a response to this, i'm looking at the same problem? cheers Rich

Hi, I imported a table into my DB from Access. Unfortunately the name of a column is 'Key'. This is causing poblems with an SQL query that I run using this column. Is there a delimiter that I can use? It won't let me change the name as it claims incorrect syntax! cheers Rich

Hi, i'm trying to run a pass through query that appends a table in my SQL db from an access 95 table on a client. Please could you tell me why I get the following syntax error? insert into Ph_ABP.Member_ID select Member_ID from c:\Windows\Desktop\db1.ABP I have the MyODBC set up correctly as...

Hi, I have an access95 DB on a client that I need to link to MySQL to make the data available to a larger audience. This has a number of forms for data entry. When I remove the table and replace it with a link to one on the MySQL DB (which has the same name) the form claims that it cannot find...

thanks, is this something exclusive to 95 that i have to do because it works fine for all other machines running higher versions of Access with MyODBC drivers? It just seems to be this machine with 95 which won't let me export to MySQL. I have removed the password protection but this doesn't...

Hi, I have an access95 DB on a client that I need to link to MySQL to make the data available to a larger audience. This has a number of forms for data entry. When I remove the table and replace it with a link to one on the MySQL DB (which has the same name) the form claims that it cannot find...

yes that would do it. I didn't expect it to work as it's kind of nested cheers

thanks, but I meant for adding rows to a table from the result of a select as opposed to creating a new one. I guess I could create a new one from the old one plus the additional rows but that would mean each time i performed the update I would have to change the name i.e create table_2 from...

Hi, I have successfully used MyODBC with other versions of Access but now I am trying to use it with 95. When exporting from Access into MySQL I am being told that it can't as the table doesn't exist. When I create a table to import into it tells me it can't import as the table already exists...

Hi, I want to copy some columns from a table into another table as in: select table.column1,table.column2 into table_new from table Mysql doesn't seem to support 'select into's' other than for exporting. Does anybody have a work around? cheers

hi, nested selects aren't supported yet. you could create a temporary table with the inner select, or the following should work: select Student.NAME from Student,Citizen where Student.NAME =Citizen.NAME and Citizen.NAME="boy"

Hi, I need to persuade my boss into going with either oracle, mysql, sybase. There could be potentially tables with a few million entries in but the queries will not be overly complicated. There will be joins, sub-selects etc. There will however be less than 100 concurrent users and the data...