Re: Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause

Hi Dave, Unfortunately species_id is a column I am using for joining so I need the fully qualified name both in the SELECT and the ORDER BY. What does the join have to do with the ORDER BY? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS

Re: ` around object names?

Karam Chand [EMAIL PROTECTED] wrote: Can somebody tell me the exact version from when ` around object names were allowed? It was introduced in version 3.23.6. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net

Re: InnoDB Newbie Simple Question

Carlos Sunden [EMAIL PROTECTED] wrote: InnoDB is included in binary distributions by default as of MySQL 4.0. Hello Is InnoDb always used when installing MySQL whether RPM or binary is used? Yes. If you don't need InnoDB, start MySQL server with --skip-innodb option. I am not

Re[2]: Delphi 7 and MySQL

Hi, i'm looking for fast reliable driver to connect to MySQL from Delphi 7 do anyone have an answer for my PLEASE I'am using Zeoslib (www.zeoslis.net). It's fast, free, open source and powerfull. -- Greatings vanquish -- MySQL General Mailing List For list archives:

RE: Delphi 7 (6) and MySQL

You can look at this as well... http://www.fichtner.net/delphi/mysql.delphi.phtml On 15 Jun 2004 at 15:35, W. D. wrote: Thanks for the info! At 15:01 6/15/2004, Darryl Hoar wrote: I'm using the Zeoslib control to do just that. www.zeoslib.net. Works like a champ for me. And its

start slave;

I am running MySQL 2.23 and configuring replication. When I execute start slave; to start replication from slave, mysql prompts... ERROR 1064: You have an error in your SQL syntex near 'start slave' at line 1 Any idea? Thanks. Joseph -- MySQL General Mailing List For list archives:

Re: Re[2]: Delphi 7 and MySQL

i'm looking for fast reliable driver to connect to MySQL from Delphi 7 do anyone have an answer for my PLEASE I'am using Zeoslib (www.zeoslis.net). It's fast, free, open source and powerfull. Does it require MySQLlib? The Microolap components don't. With regards, Martijn Tonies

innodb_flush_file_method=O_DIRECT

Hi all! I have read about innodb_flush_file_method=O_DIRECT options as I think this will increase perfomance of my innodb database. One my friend said to me some worlds about this options and reserfs: turn on writeback journal mode and he gone away from ICQ ;-) Anyone knows some

[ANN] microOLAP Database Designer for MySQL released

microOLAP Technologies is pleased to announce the new powerful CASE tool for MySQL: microOLAP Database Designer. Product page: http://microolap.com/dba/mysql/designerm Direct download link (30 days fully-functional trial): http://microolap.com/dba/mysql/designerm/mymdd.zip MicroOLAP Database

Re: Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause

Don't follow your question - you suggested I use the column name (with no table name) as the ORDER BY. I said I can;t do this because I join on that column name - this means any references to it MUST be qualified with a table name. Anyway - reported this as a 4.1.2 bug (on the grounds that it

Re: Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause

Hi Dave, Don't follow your question - you suggested I use the column name (with no table name) as the ORDER BY. I said I can;t do this because I join on that column name - this means any references to it MUST be qualified with a table name. Actually, I suggested to use ORDER BY 1 ASC With

MySQL vs Oracle

Hi all! I'm developing a system using both MySQL and Oracle for document processing. I issue a series of queries to the database, depending on the document size. For big documents, both databases behave in the same way but, when using small documents, MySQL finishes quickly while Oracle

How to (Unique value)?

4.0.14 Its rather a general SQL question, I'll ask it as I'm using MySQL. An converted table has field of type VarChar(6), containing alphanumeric chars. Is it possible to run a query to generate a unique key so this can be used for new record? regards

RE: start slave;

Which version are you running? Try slave start; -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 6/16/04 2:53 AM Subject: start slave; I am running MySQL 2.23 and configuring replication. When I execute start slave; to start replication from slave, mysql prompts...

RE: How to (Unique value)?

You can use an AUTO_INCREMENT field to generate a numeric value that will be unique for each record. You will need to use an external process to generate an alphanumeric key though. -Original Message- From: A Z To: [EMAIL PROTECTED] Sent: 6/16/04 6:27 AM Subject: How to (Unique value)?

Re: ` around object names?

Hello, That is what Paul Dubois book says but one of my customers running 3.23.27-beta-log the following query does not work: select * from `db`.`table`; but the following query works like cheese: select * from db.table; regards karam --- Egor Egorov [EMAIL PROTECTED] wrote: Karam Chand

Re: Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause

RE: the bug was in 4.0.17, which should not have allowed this behaviour! That makes sense if you think about it in relation to UNION queries. There is a major difference between a simple query and the results of a UNION query. In a UNION, the first SELECT clause of the first simple query

Problems installing 4.0 4.1 on XP system

To start with I have tried to use mysqlbug but it doesn't work, when I go to the scripts directory in the command prompt window (c:\mysql\scripts) and type mysqlbug and hit enter it just says it is not recognized as anything. I have as a reference Welling and Thomsons book MYSQL Tutorial and

install myodbc 2.50.39

I'm installing the myodbc2.50.39win95 in a Athlon XP 2200+, but when I start the setup.exe the following error: insufficient memory or disc space. After this, it's finishing the installation. My machine have RAM 256 and +/- 30GB free disc. What is happening? Thanks Silmara

dump data based on query

Hello, I'm trying to get my brain around this problem. I have a database that stores news articles. This database grows and grows, and I need a way to archive older articles, preferably in a dump format similar to that produced mysqldump. Is there a way to do a mysqldump based on a query,

RE: MySQL vs Oracle

You didn't provide much information about your system. What version of MySQL? Oracle? With Oracle, which optimizer are you using? Oracle, compared to MySQl, is very tunable and it's easy to make it run badly. We run customer databases on both MySQL and Oracle, using a product developed on

RE: dump data based on query

Look at the output of mysqldump --help -w, --where=nameDump only selected records; -t, --no-create-info -Original Message- From: James To: Mysql List Sent: 6/16/04 8:56 AM Subject: dump data based on query Hello, I'm trying to get my brain around this problem. I have a database

Re: MySQL vs Oracle

I'm using Oracle 8.0.5 and MySQL 4.1.1a I'm not optimizing Oracle nor MySQL, because I don't want future users messing with optimizations. I access through JDBC drivers. Oracle usually needs 10 seconds in every query I execute. It is very odd. Thank you again. - Original Message -

Re: dump data based on query

If you enter the command... mysqldump --help you'll find a long listing of qualifiers that you can use with this, one of which is -w (or --where=) which allows you to specify what you want dumped. HTH, Ron James wrote: Hello, I'm trying to get my brain around this problem. I have a

myisampack / myisamchk Problem

Hello * my Problem (resolved for newer mysql Versions): A MyIsam Table is packed with myisampack A subsequent myisamchk -r or -o with index reordering erroneously marks wrong indices in the packed table for 4.0.15 (unpacking reconstructs the original table) This seems to be a known issue

Create table syntax question

Hi, Probably a very basic question. I'm trying to a create a table in mySQL 4.0.15 thus: create table VACANCIES( VACREF char(6) NOT NULL PRIMARY KEY, TITLE varchar(60), LOC varchar(9), DESC text, STARTDATE date, GROUP varchar(25), CONSTRAINT fk_grp FOREIGN KEY (GROUP) REFERENCES GROUPS(GPNAME),

Re: Dump table

On Wed, Jun 16, 2004 at 09:16:52AM +0400, Vinay wrote: Thanks Brian but i'm on Red Hat enterprise server so i wouldn't be able to use the Features of FreeBSD and restarting the server is not a solution for me as i need to be able to perform hot backup. One of my solutions was to bump the

RE: Create table syntax question

From: eifion herbert (IAH-C) [mailto:[EMAIL PROTECTED] Hi, Probably a very basic question. I'm trying to a create a table in mySQL 4.0.15 thus: create table VACANCIES( VACREF char(6) NOT NULL PRIMARY KEY, TITLE varchar(60), LOC varchar(9), DESC text, STARTDATE date, GROUP

Re: mysql backup script

Thanks to all that responded. The answer was a little different from the one below. So what it came out to was this: while [ -f $mysqlpid ] do sleep 1 /etc/rc.d/init.d/mysqld stop done For those that recommended webmin. Although I have webmin installed, because of the

Re: Query Help

Robert A. Rosenberg wrote: At 12:22 +0100 on 06/11/2004, Andrew Dixon - MSO.net wrote about Query Help: Hi Everyone. I have the following a table with a varchar column that contains a comma delimited list of id's from another table that relates the item keywords in the other table. The table

general qn

Hi folks, I'm trying to install mysql on linux and it's giving me trouble. I'm new to linux and new to databases so my downfall isn't too surprising. I've been going by the readme file in the package but I can't seem to get my head around it. Does anyone have a step by step approach they could

Re: general qn

On Wednesday 16 June 2004 16:37, [EMAIL PROTECTED] might have typed: Hi folks, I'm trying to install mysql on linux and it's giving me trouble. I'm new to linux and new to databases so my downfall isn't too surprising. I've been going by the readme file in the package but I can't seem to get

Re: Create table syntax question

eifion herbert (IAH-C) wrote: Hi, Probably a very basic question. I'm trying to a create a table in mySQL 4.0.15 thus: create table VACANCIES( VACREF char(6) NOT NULL PRIMARY KEY, TITLE varchar(60), LOC varchar(9), DESC text, STARTDATE date, GROUP varchar(25), CONSTRAINT fk_grp FOREIGN KEY (GROUP)

Re: general qn

Devshed has a good tutorial: http://www.devshed.com/c/a/MySQL/MySQL-Installation-and-Configuration/ --bmansell On Wed, 16 Jun 2004 16:37:44 +0100, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi folks, I'm trying to install mysql on linux and it's giving me trouble. I'm new to linux and

Index Building on Large Tables Stalling

binary MySQL 4.0.20-standard on Redhat 7.2/Linux Dual-proc, 4Gb ram, raid I'm trying to change an index on a 12Gb table (270 million rows). Within an hour or so the entire table is copied, and the index reaches 3.7Gb of data. Then the database appears to do nothing more, except for touching the

RE: Create table syntax question

Thanks for that. I've got it to accept it now, and also realised that mySQL will let me insert anything I like into columns that are supposedly foreign keys. Guess it's a toss up between creating InnoDB tables and the associated indeces, or doing something application side to enforce RI.

Com_show_status rapidly increasing

Hi, We are having some strange activity logged when viewing the status of a MySQL server we run. The Com_show_status value is rapidly increasing - many times a second. | Com_show_status | 3553172| mysql Ver 11.15 Distrib 3.23.47, for sun-solaris2.8 (sparc) The only

RE: MySQL vs Oracle

It's probably not odd. Does every query take 10 seconds to execute, or is that how long it takes to return data? Why don't you run tkprof on the Oracle queries to see how long they actually take to complete? --Walt -Original Message- From: Jaime [mailto:[EMAIL PROTECTED] Sent:

Re: Create table syntax question

eifion herbert (IAH-C) wrote: Thanks for that. I've got it to accept it now, and also realised that mySQL will let me insert anything I like into columns that are supposedly foreign keys. That depends on your table type. MySQL will enforce your foreign keys in tables that support them. (i.e.

Re: general qn

On Wednesday 16 June 2004 11:37 am, [EMAIL PROTECTED] wrote: Hi folks, I'm trying to install mysql on linux and it's giving me trouble. I'm new to linux and new to databases so my downfall isn't too surprising. I've been going by the readme file in the package but I can't seem to get my

Why can't I make a connection?

Hi, I am testing the following code that attempts to get a DB connection, but I keep getting the following error: database_test.DBConnector SQLException: No suitable driver SQLState: 08001 VendorError: 0 The code snippet is below. I know the DB I am trying to connect to exists and that the

Intel compiled 4.1.2

Hi, I have a 4.1.2 database installed and running on a REL 3 server. I installed the Intel compiled 4.1.2 to see how much of a performance increase I would get, but I am having trouble with it. The scripts/mysql_install_db is giving me the following error. #scripts/mysql_install_db

Re: Intel compiled 4.1.2

It's not really complaining about /etc/hosts. It's complaining that hostname command does not return anything that is in /etc/hosts. type 'hostname' at the command prompt. Add what that returns to the /etc/hosts entry for the machine. Let me know how that goes- P Darryl Rodden [EMAIL

Tough Query Problem

I am trying to write a script that can take logs from our mail server, boil down the rejections to determine the sources of distributed SMTP dictionary attacks against our mail server. Basically I have a table send_failures like this that gets fed with the raw data from the logs: host_ip

Re: MySQL vs Oracle

10 seconds !?Unless that query is huge and without indexes, it should run MUCH quicker. I'm using Oracle 8.0.5 and MySQL 4.1.1a I'm not optimizing Oracle nor MySQL, because I don't want future users messing with optimizations. I access through JDBC drivers. Oracle usually needs 10

Intel compiled 4.1.2

Hi, I have a 4.1.2 database installed and running on a REL 3 server. I installed the Intel compiled 4.1.2 to see how much of a performance increase I would get, but I am having trouble with it. The scripts/mysql_install_db is giving me the following error. #scripts/mysql_install_db

Re: Tough Query Problem

In the last episode (Jun 16), Aaron Clausen said: I am trying to write a script that can take logs from our mail server, boil down the rejections to determine the sources of distributed SMTP dictionary attacks against our mail server. Basically I have a table send_failures like this that

Re: Index Building on Large Tables Stalling

Are you running out of temp space? Tim Brody wrote: binary MySQL 4.0.20-standard on Redhat 7.2/Linux Dual-proc, 4Gb ram, raid I'm trying to change an index on a 12Gb table (270 million rows). Within an hour or so the entire table is copied, and the index reaches 3.7Gb of data. Then the database

RE: Intel compiled 4.1.2

Here is what hostname returns: devlhvm03.sdl1.secureserver.net Here is the /etc/hosts: 127.0.0.1 localhost.localdomain localhost 172.16.17.63devlhvm03.sdl1.secureserver.net devlhvm03 If I run the resolveip directly, here is what I get:

Re: query in any table

Yavuz Malak wrote: I use mysql3.53.x I wish to query as value of rows on any table Here's my table named mytable id date pictures subject 271503 2003-10-25 20031026035655_5326 9 BENY 271502 2003-10-25 20031026035628_6401 283 PLATFORMU 271501 2003-10-25

Re: general qn

Try http://www.yolinux.com/TUTORIALS/LinuxTutorialMySQL.html Oorey vie oort, Martin - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 11:37 AM Subject: general qn Hi folks, I'm trying to install mysql on linux and it's giving me trouble.

Re: Index Building on Large Tables Stalling

Nope. As far as I'm aware the only disk space being used is in the database's directory, and that file system has 200Gb spare. (/tmp has 19Gb free anyway) Regards, Tim. gerald_clark wrote: Are you running out of temp space? Tim Brody wrote: binary MySQL 4.0.20-standard on Redhat 7.2/Linux

Importing data, indexes, and analyzing tables.

We have a somewhat large database, with a snapshot of the data that we import into the database. Normally, we create a database, create the tables, import the data with LOAD DATA, add the indexes, and then the foreign keys (we are using InnoDB, 4.0.18). We call this the load-data-method.

Correcting Time

Hello, Somehow the mysql server time is set 3 hours earlier than the system time(CDT), is there a way to correct this so they both are the same ? TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work!

Learning PHP/MySQL

Hi All, Can someone recommend a good book for learning PHP/MySQL? TIA, Kay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL -- SQL syntax error.....

When I use this SQL statement, ... --snip-- UPDATE BUSINESS_CATEGORY SET (BUSINESS_CATEGORY.BUS_CAT,BUSINESS_CATEGORY.BUS_DESC) = ('JUNKKK','JUNK123KK') WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788' --snip-- I get the SQL syntax error saying, --snip-- You have an error in your SQL syntax.

string compare

Where is the syntax error in this? select name from users where name like '%' and strcmp( substr(name from 1 for 3), 'abc' )=0; Why should I use strcmp since MySQL automatically converts numbers to strings as necessary, and vice versa.? -- MySQL General Mailing List For list archives:

Re: Learning PHP/MySQL

I like the web site www.phpbuilder.com ... lots of great articles. Hi All, Can someone recommend a good book for learning PHP/MySQL? TIA, Kay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL -- SQL syntax error.....

From: Scott Fletcher [mailto:[EMAIL PROTECTED] When I use this SQL statement, ... --snip-- UPDATE BUSINESS_CATEGORY SET (BUSINESS_CATEGORY.BUS_CAT,BUSINESS_CATEGORY.BUS_DESC) = ('JUNKKK','JUNK123KK') WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788' --snip-- I get the SQL syntax error

RE: Intel compiled 4.1.2

Here is what hostname returns: devlhvm03.sdl1.secureserver.net Here is the /etc/hosts: 127.0.0.1 localhost.localdomain localhost 172.16.17.63devlhvm03.sdl1.secureserver.net devlhvm03 If I run the resolveip directly, here is what I get:

Re: MySQL -- SQL syntax error.....

Try this: UPDATE BUSINESS_CATEGORY SET BUSINESS_CATEGORY.BUS_CAT = 'JUNKKK' ,BUSINESS_CATEGORY.BUS_DESC = 'JUNK123KK' WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788'

Re: string compare

Bob Lockie wrote: Where is the syntax error in this? select name from users where name like '%' and strcmp( substr(name from 1 for 3), 'abc' )=0; substr(name,1,3) Check the manual. You don't include the 'from' and 'for'. Why should I use strcmp since MySQL automatically converts numbers to

Re: string compare

I see several problems with your statement: 1) substr should be substring (see http://dev.mysql.com/doc/mysql/en/String_functions.html) 2) where name like '%' means that name can have from 0 to any number of characters. Basically it's a match on anything other than NULL. If name is a field that

Re: Tough Query Problem

- Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Aaron Clausen [EMAIL PROTECTED] Cc: MySQL Mailing List [EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 10:20 Subject: Re: Tough Query Problem In the last episode (Jun 16), Aaron Clausen said: I am trying to write a script

Replication, max_allowed_packet and LOAD DATA INFILE

Hi, I experienced a problem when slaves stopped replicating today. A LOAD DATA INFILE was performed on the master DB. Seems the data exceeded the max_allowed_packet size which is 1M on master and slaves so all slaves stopped replicating. Question is, why did this happen and how could this have

Re: Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause

Thanks - this is now on the bugs.mysql.com site as bug 4156 - which as you say is actually a bug in the old version. Appreciate your explanation - what seems to happen is that even though the SELECT has a fully qualified column name (which it has to have as species_id occurs in both tables I am

Re: Correcting Time

This page may help: http://dev.mysql.com/doc/mysql/en/Timezone_problems.html --bmansell On Wed, 16 Jun 2004 14:32:22 -0500, Mike Blezien [EMAIL PROTECTED] wrote: Hello, Somehow the mysql server time is set 3 hours earlier than the system time(CDT), is there a way to correct this so they

Re: Why can't I make a connection?

Scott, I'm going to put this reply into the list rather than answer it offline. I hope that's okay with you. If I answer you offline, only you will know the answer but if I answer on the mailing list, everyone who monitors the list - and anyone who checks the archives in the future! - can

Where are BLOBs / TEXTs stored?

[ Please CC me ] Hi, http://dev.mysql.com/doc/mysql/en/Storage_requirements.html Page says: --- The maximum size of a row in a MyISAM table is 65,534 bytes. Each BLOB and TEXT column accounts for only five to nine bytes toward this size. --- Question: So where are BLOBs and TEXTs entries

Re: Why can't I make a connection?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rhino wrote: Scott, I'm going to put this reply into the list rather than answer it offline. I hope that's okay with you. If I answer you offline, only you will know the answer but if I answer on the mailing list, everyone who monitors the list

How to cast string to timestamp

Hi, I am trying to get the records for the activationstamp within a certain range. The activationstamp is defined as character(14) in the ddl. I don't know how to cast the activationstamp field to timestamp before doing the comparison. I tried to use date(), but it didn't work. My server

Deadlock issue

If I have two transactions and one of them is updating a set of rows and the second one is updating a different set of rows, the second transaction is forced to wait. I have an unique index on two columns of the table. I found that there is a bug associated with this problem which will be fixed

Re: using a column value in IN() in a join condition.

Do you know this mail gets to [EMAIL PROTECTED] ? it seems relevent, so I suppose you do. Trouble is it baffles my mailbox filters of course, and so creates sorting work for me, clicks and scanning. Could you all fix it please so you don't, which anyway is how lists are intended to be run.

open notify

Hi, I am developing some network application with central database. I have table of persons and two dialog windows. One window is for viewing the list of persons, when user doubleclick on some person, second window appears. On this window user can modify data about this person. Nothing unusual.