Search results for query: *

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, 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...

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

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, 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...

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

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

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

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

hi, please could someone explain the reason why the following command is throwing the following syntax error: You have an error in your SQL syntax near 'SELECT [Category] FROM [Raw] As Tmp GROUP BY [Category],[Individual_ID] HAVING C' at line 3 SELECT DISTINCTROW Raw.Category...

Hi, I want to create a new user that I can use with the DBI module and Perl CGI within a script. In the mysqlmanager I have created a new user in the 'user' table with select,update,delete, insert privileges. for some reason adding this user to this table is not giving me permission to connect...

Hi could anybody tell me how to change the type of a column? the following doesn't work: ALTER table users rename column ch_1_year to ch_1_year int I want to change to Integer from Varchar Thanks Rich

Hi, I usually use MySQL so haven't come accross this problem before. I have an integer field, and say I want to pull up all entries with values between 18 and 20, I would normally use: SELECT * FROM users where ch_4_year>=18 and ch_4_year<=20 MS SQL appears to consider the following to be...

Hi, does anybody know how to perform the following MySQL statement in MS SQL? LOAD INFILE 'TOTALregistrationss.xls' INTO TABLE users This doesn't appear to work with the MS SQL db that I have been forced to use. All I have access to is something called Qtado which is a universal querying tool...

Hi, i usually use MySQL and import data into tables that I have using the following statement: LOAD INFILE 'TOTALregistrationss.CSV' INTO TABLE users This doesn't appear to work with the MS SQL db that I have been forced to use. I was wondering whether any other MySQL users had been forced to...

Hi, I am writing a CGI script where a user searches a DB using a combination of up to 10 different criteria. However, if the user leaves a search criteria blank I don't want the program to search using it, obviously. Is there a way of saying: select all matches in field1 if the field1 param was...