Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: doddo
  • Order by date
  1. doddo

    MySQL Joins

    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...
  2. doddo

    safe_mysqld

    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
    • doddo
    • Thread
    • Replies: 0
    • Forum: MySQL
  3. doddo

    JDBC

    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
    • doddo
    • Thread
    • Replies: 1
    • Forum: MySQL
  4. doddo

    update tbl X using data from table Y

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

    'Key ' as a column name

    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
    • doddo
    • Thread
    • Replies: 1
    • Forum: MySQL
  6. doddo

    pass through query from access to Mysql

    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...
    • doddo
    • Thread
    • Replies: 1
    • Forum: MySQL
  7. doddo

    export/linking for access 95 and MySQL

    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...
  8. doddo

    linking tables/exporting in access95 to MySQL

    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...
  9. doddo

    linking tables/exporting in access95 to MySQL

    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...
  10. doddo

    select into

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

    select into

    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...
  12. doddo

    MyODBC and Access 95

    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...
    • doddo
    • Thread
    • Replies: 1
    • Forum: MySQL
  13. doddo

    select into

    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
    • doddo
    • Thread
    • Replies: 4
    • Forum: MySQL
  14. doddo

    Nested query In MYSQL

    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"
  15. doddo

    oracle, sybase,mysql?

    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...
  16. doddo

    oracle,mysql,sybase?

    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...
  17. doddo

    Sun versus windows

    Hi, I have Mysql installed on our server which is a Sun Ultra Enterprise 450 and also have it stored on my windows Dell workstation running NT with Pentium 3. Does anybody know why the same query run on the same data on both machines takes 2.5 times longer on the Sun than on my desktop machine...
    • doddo
    • Thread
    • Replies: 0
    • Forum: MySQL
  18. doddo

    select * not working

    Hi, ive exported some tables from Access into Postgresql. When i list them using select * from pg_tables they are visible however when i perform select * on the table I get the following error: Relation 'tablename' does not exist any ideas? thanks
  19. doddo

    Hi, i'm trying to run some perfor

    Hi, i'm trying to run some performance comparison tests between MySQL and PostgreSQL. I'm completely new to postgresql and have tried to move the an Access DB into it using exportSQL. When i run this module i get the error: Failure creating file Does anybody have any idea why? does this...
  20. doddo

    syntax error

    Thanks alot. i was just going to attack it with Perl, cheers Rich

Part and Inventory Search

Back
Top