Re: Mysql and its OLEDB provider error

2003-03-05 Thread Paul DuBois
At 7:21 +0100 3/6/03, marjan mrak wrote: Hello, mysqladmin reports 'unknown settiing --default-char-set' if i set client default charset in my.cnf on suse linux. If I comment this line, there are no errors, even if if server has win1250 as default charset. There is no such option. I assume you mea

Re: Indexes

2003-03-05 Thread Paul DuBois
At 4:41 + 3/6/03, Donna Robinson wrote: Filter-fodder: mysql, query Hi, Is this a very hard question or an absurdly simple one? I posted it days ago, and no-one has responded! Please can someone help? How can I avoid "Using temporary, "Using filesort" when creating indices when my selects

Mysql and its OLEDB provider error

2003-03-05 Thread marjan mrak
Hello, mysqladmin reports 'unknown settiing --default-char-set' if i set client default charset in my.cnf on suse linux. If I comment this line, there are no errors, even if if server has win1250 as default charset. But myOLEDB quit working, if i use charset other than latin1. Can this be fixed? --

×ÏÖñÑûÇëÄúÀ´¹²´´ÎÄѧµÄÊÀ¼ÍÍøÂç

2003-03-05 Thread ×ÏÖñÎÄѧ
邮件内容与以下文字无关= 优联网络 http://www.chinamysql.com 专业提供各类虚拟主机,不满意可获退款。 强势套餐:100M主机送顶级域名,送10个10M企业油箱,加送20个二级域名,仅需318元/年! 三龙证券投资 http://3long.sayba.com 为您提供专业理财服务。现在购买只需588元,赠送价值超过1800元的礼品! 说吧网上商城 http://shop.sayba.com 全是厂商直销的新品或折上折的商品,是您网络购物

Re: Foreign keys and being FIRST index

2003-03-05 Thread Dan Nelson
In the last episode (Mar 05), Daevid Vincent said: > > I'm not sure that sentence means what you think it does. What > > they're saying is you need to index both fields, and if you decide > > to make that index a compound one with multiple keyparts, the > > foreign/referenced field must be the fir

OpenBSD

2003-03-05 Thread Chris Callender
I hope I can get some help here, I'm installing mySQL on OpenBSD and i cannot find the mysql_install_db file, all the documentation that I've read is saying its the first step after doing make and make install from the ports tree. FYI: Its not in /usr/local/bin, and there was no /usr/local/mysq

No Reply from your side!! Waiting for your reply!!!

2003-03-05 Thread Murugavel
Dear Mr. Venu & Tech Group, We are facing few problem in mysql database. Take an eg. we have table called bb_usersession0 user A is trying to delete a record which is having the billingstatus B . User A delete from bb_usersession0 where ui_sessionid='cs_venkatesh0006A46C' AND us_billings

Re: Feature request: using CURRENT_DATE as DEFAULT value

2003-03-05 Thread Paul DuBois
At 17:56 -0800 3/5/03, Daevid Vincent wrote: http://www.mysql.com/doc/en/CREATE_TABLE.html states "Default values must be constants. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE." Is this ever going to be "fix

Re: Database Questions

2003-03-05 Thread Paul DuBois
At 11:59 +0800 3/6/03, Terence wrote: Hi All, Can MySQL give some indication of how many questions are being asked to each database? Using the show variables, I can get the total questions, but was wondering if it's possible to get it broken down on a per database view? No. Rgds Terence query s

Database Questions

2003-03-05 Thread Terence
Hi All, Can MySQL give some indication of how many questions are being asked to each database? Using the show variables, I can get the total questions, but was wondering if it's possible to get it broken down on a per database view? Rgds Terence query sql -

Bug report: MySQL Embedded Server v4.0.10

2003-03-05 Thread Matt Solnit
Bug report -- MySQL Embedded Server v4.0.10, binary distribution for Windows

RE: Foreign keys and being FIRST index

2003-03-05 Thread Daevid Vincent
> In the last episode (Mar 05), Daevid Vincent said: > > http://www.mysql.com/doc/en/SEC457.html states that "there > must be an > > index where the foreign key and the referenced key are listed as the > > FIRST columns." Will this restriction be lifted soon? It is > > incredibly frustrating. I do

very slow mysql server, help please

2003-03-05 Thread William Wang
Hi All: I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load balancer. All those servers are FreeBSD. For some reason, mysql server can be easily max out without many users. Also there are many processes in slee

Re: Foreign keys and being FIRST index

2003-03-05 Thread Dan Nelson
In the last episode (Mar 05), Daevid Vincent said: > http://www.mysql.com/doc/en/SEC457.html states that "there must be an > index where the foreign key and the referenced key are listed as the > FIRST columns." Will this restriction be lifted soon? It is > incredibly frustrating. I don't see why t

very slow mysql server, help please

2003-03-05 Thread william wang
Hi All: I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load balancer. All those servers are FreeBSD. For some reason, mysql server can be easily max out without many users. Also there are many processes in sl

Foreign keys and being FIRST index

2003-03-05 Thread Daevid Vincent
http://www.mysql.com/doc/en/SEC457.html states that "there must be an index where the foreign key and the referenced key are listed as the FIRST columns." Will this restriction be lifted soon? It is incredibly frustrating. I don't see why they have to be indexes, and more importantly, I don't see w

Feature request: using CURRENT_DATE as DEFAULT value

2003-03-05 Thread Daevid Vincent
http://www.mysql.com/doc/en/CREATE_TABLE.html states "Default values must be constants. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE." Is this ever going to be "fixed"? I often find myself using this when cre

some gamma-gatcha sqlbench stats

2003-03-05 Thread Seth Brundle
I just built a P4 3.06 1GB DDR 333 15k U160 SCSI MySQL Linux server. I was dissapointed because I couldnt get the dual-channel DDR 400 MB I tried first to run stable :( dual-channel memory controllers definitely made a slight difference on the benchmarks with the same ram. alter-table 2

Can this subquery be expressed as a join?

2003-03-05 Thread Mike Hillyer
Hi All; I recieved an e-mail as part of a PHP user group mailing list, does anyone know the answer? cut here Ok, I know that you can do a ( ) in a query for working stuff but can you do another query there? ie select * from "Activity" join ( select "License Number", max("Activity Date"

Re: Syntax confusion

2003-03-05 Thread Jeff
Thanks guys, Appreciate the help. Kinda makes sense now ;-) Jeff - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Benjamin Pflugmann" <[EMAIL PROTECTED]>; "Jeff" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 9:32 AM Subject: Re: Sy

Re: Syntax confusion

2003-03-05 Thread Paul DuBois
At 0:23 +0100 3/6/03, Benjamin Pflugmann wrote: On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote: [...] BA_DATE >= '2003-02-25 00:00:00' AND BA_DATE <= '2003-02-25 23:59:59' or TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25' Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE i

RE: Insert/UpDate dates

2003-03-05 Thread Mike Hillyer
Well, if this is a one-time batch transfer then a simple UPDATE abctable SET SomethingDate IS NULL when SomethingDate = '-00-00'; should null all the fields in question. Of course, you have to have a NULLable date field. Regards, Mike Hillyer http://www.dynamergy.com/mike -Original Mes

Re: Syntax confusion

2003-03-05 Thread Benjamin Pflugmann
On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote: [...] > BA_DATE >= '2003-02-25 00:00:00' AND BA_DATE <= '2003-02-25 23:59:59' > > or > > TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25' Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE is a timestamp, not a number of days. As

Re: Syntax confusion

2003-03-05 Thread Paul DuBois
At 9:05 +1000 3/6/03, Jeff wrote: Yes Paul, that's what I meant. See, even confusing myself now ;-) The field is datetime as the time is used in other functions... Would I be better using 2 separate fields? Not necessarily, but if you want to match all times within a given date, you'll need to do s

Re: Syntax confusion

2003-03-05 Thread Jeff
Yes Paul, that's what I meant. See, even confusing myself now ;-) The field is datetime as the time is used in other functions... Would I be better using 2 separate fields? Jeff - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Jeff" <[EMAIL PROTECTED]>; "MySQL List" <[EM

Insert/UpDate dates

2003-03-05 Thread John Thorne
Working on a routine to export a Filemaker data to mySQL for php application. Using scripts I build a calculated field below: INSERT INTO abctable (JobNumber, JobTitle, AE, Client, StartDate) VALUES (9997, ' ABC ' , 'jrt' ,1234, '') or UPDATE abctable SET JobTitle='ABC',AE='jrt',Client=1234,Some

Problems Using SELECT INTO OUTFILE

2003-03-05 Thread Nick Pasich
>Description: I'm using Mysql 4.0.10-gamma with query caching: set-variable = query_cache_limit=10M set-variable = query_cache_size=10M set-variable = query_cache_startup_type=1 The Command: Select *

Re: Syntax confusion

2003-03-05 Thread Paul DuBois
At 8:40 +1000 3/6/03, Jeff wrote: Hi, perform the following query SELECT BA_ID, BA_DATE FROM BA WHERE SUBSTRING(BA_ID,1,3) = 'TSV' and get 'TSV12345-1','2003-02-25 00:00:00' 'TSV12345-2','2003-02-25 00:00:00' 'TSV14818-3','2003-02-19 00:00:00' 'TSV14836-00015','2003-02-27 00:00:00' 'T

Problems Using SELECT INTO OUTFILE

2003-03-05 Thread Nick Pasich
>Description: I'm using Mysql 4.0.10-gamma with query caching: set-variable = query_cache_limit=10M set-variable = query_cache_size=10M set-variable = query_cache_startup_type=1 The Command: Select *

Syntax confusion

2003-03-05 Thread Jeff
Hi, perform the following query SELECT BA_ID, BA_DATE FROM BA WHERE SUBSTRING(BA_ID,1,3) = 'TSV' and get 'TSV12345-1','2003-02-25 00:00:00' 'TSV12345-2','2003-02-25 00:00:00' 'TSV14818-3','2003-02-19 00:00:00' 'TSV14836-00015','2003-02-27 00:00:00' 'TSV14841-9','2003-02-28 00:00:

Re: Replication & REQUIRE SSL

2003-03-05 Thread Jeremy Zawodny
On Wed, Mar 05, 2003 at 05:12:13PM -0500, Russell D. Weiss wrote: > > I guess I'll be doing replication over an SSH tunnel. Anyone seen > any caveats with doing it that way? That will work just fine. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | ht

Re: mysql scripts

2003-03-05 Thread Paul DuBois
At 16:16 -0600 3/5/03, Terry & Cheryl Haimann wrote: Is there a webpage or something I can read about creating a script that can be ran from mysql prompt with the ./ . My script doesn't seem to work, even though it looks like legal sql to me. I am running this under win98. The command is \. and

mysql scripts

2003-03-05 Thread Terry & Cheryl Haimann
Is there a webpage or something I can read about creating a script that can be ran from mysql prompt with the ./ . My script doesn't seem to work, even though it looks like legal sql to me. I am running this under win98. Terry

Re: Replication & REQUIRE SSL

2003-03-05 Thread Paul DuBois
Oops, I guess I assumed that support for it was there since options are documented, and it even says: "Available after 4.0.0. Turn SSL on for replication. Be warned that is this is a relatively new feature. Example: master-ssl" Instead, I guess it should say "be warned, this is just a stub and does

Re: Replication & REQUIRE SSL

2003-03-05 Thread Russell D. Weiss
Oops, I guess I assumed that support for it was there since options are documented, and it even says: "Available after 4.0.0. Turn SSL on for replication. Be warned that is this is a relatively new feature. Example: master-ssl" Instead, I guess it should say "be warned, this is just a stub and do

Re: Temporary Tables

2003-03-05 Thread Mamatha Balasubramanian
Thanks! Mamatha From: Paul DuBois <[EMAIL PROTECTED]> To: "Mamatha Balasubramanian" <[EMAIL PROTECTED]>,[EMAIL PROTECTED] Subject: Re: Temporary Tables Date: Tue, 4 Mar 2003 17:31:36 -0600 At 23:19 + 3/4/03, Mamatha Balasubramanian wrote: Thank you once again. I have a web-interface t

Re: Replication & REQUIRE SSL

2003-03-05 Thread Paul DuBois
At 15:48 -0500 3/5/03, Russell D. Weiss wrote: Hi, I'm running 4.0.11a-gamma. I have replication working and I have SSL working. I can't seem to get them to work together. Based on mysql.com's documentation, it seems that this version of MySQL does in fact support secure replication. What docume

Replication & REQUIRE SSL

2003-03-05 Thread Russell D. Weiss
Hi, I'm running 4.0.11a-gamma. I have replication working and I have SSL working. I can't seem to get them to work together. Based on mysql.com's documentation, it seems that this version of MySQL does in fact support secure replication. Unfortunately, when I add "REQUIRE SSL" to the slave user

Re: Linux Filesystem Type and Performance

2003-03-05 Thread Pete Harlan
If you have that many files in a directory, I would try a filesystem that indexes directories. Reiserfs does, and there's a patch somewhere for ext2 (and probably for ext3). I don't know about the other filesystems. Otherwise the application has to do a linear search through the directory every

Re: OS X codewarrior libraries

2003-03-05 Thread ben nevile
Hi Lenz - thanks for your response. Please define "not compatible". What exactly happens when you try to use them? Is there an error? Which version of MySQL/Code Warrior do you use? I am using the most up-to-date version of CodeWarrior, v8.3, and I have tried with several different versions of

Get warning info from mysql_info()

2003-03-05 Thread Jamie Jennings
I'm trying to use a INSERT INTO table1 (column1, column2, column3) SELECT 'value', 'value2', table2.value3 FROM table2 WHERE table2.value4='name'; This query fails from C, but if I copy and paste it exactly to the mysql client, it works. If I run mysql_info(), it tells me: Records: 0 Duplicates

Re: Simple SELECT question

2003-03-05 Thread Ryan McDougall
--- [EMAIL PROTECTED] wrote: > I need a little help querying 2 tables in MySQL; > > Table User > User_Id // Id = 2 > User_Name // John > > Table History > User_Id // 2 > User_History // John has born in 58 > > SELECT User_History FROM History WHERE User_Id = 2; // return John has > born in

Re: Simple SELECT question

2003-03-05 Thread Bruce Feist
[EMAIL PROTECTED] wrote: I need a little help querying 2 tables in MySQL; Table User User_Id // Id = 2 User_Name // John Table History User_Id // 2 User_History // John has born in 58 SELECT User_History FROM History WHERE User_Id = 2; // return John has born in 58 But what my SELECT should

RE: Simple SELECT question

2003-03-05 Thread Mike Hillyer
Ok, lessee... SELECT user.user_id, user_name, user_history FROM user, history WHERE user_history LIKE "%58%" AND user.user_id = history.user_id; That should do what you need, lemme know. Mike Hillyer http://www.dynamergy.com/mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMA

RE: Mysql hangs on multi table update on innodb table.

2003-03-05 Thread Sinisa Milivojevic
Scott Wong writes: > > Hi, I havent received any response on this so i'll send this again. > I did check again with 4.0.11-gamma and the problem is still there. > > > Regards, > Scott > Hi! This will require a major re-write in multi table update's and will not come up very soon. But should co

RE: Count (*) function results needed in echo statement

2003-03-05 Thread John Berman
Renne I did a similar thing with asp, my query was like SELECT COUNT(*) AS countresult, uniqueref FROM global WHERE PROPOSEDRELEASE <= 2002 and SURNAME = '"& globsurname & "' group by uniqueref" Im my asp code I referenced countresult Hope this helps John B -Original Message- Fr

Simple SELECT question

2003-03-05 Thread nocturno
I need a little help querying 2 tables in MySQL; Table User User_Id // Id = 2 User_Name // John Table History User_Id // 2 User_History // John has born in 58 SELECT User_History FROM History WHERE User_Id = 2; // return John has born in 58 But what my SELECT should look if i don't know t

RE: Mysql hangs on multi table update on innodb table.

2003-03-05 Thread Scott Wong
Hi, I havent received any response on this so i'll send this again. I did check again with 4.0.11-gamma and the problem is still there. Regards, Scott > Version: Mysql 4.0.10-gamma > > Description: Mysql hangs and possibly can not recover from a query on an innodb > table. > > How to Re

viewing uncommited transactions (InnoDB)

2003-03-05 Thread Adam Nelson
Does anyone know how to view uncommited transactions for a session? This is more of a problem when using MySQL Manager when it asks whether or not to commit the transaction list. Is there a definitive way to know what queries have yet to be committed/rolled back? -

Newbie Install Questions: RH Linux 7.1

2003-03-05 Thread Bruce Feist
I'm having trouble getting MySQL running on a RedHat Linux 7.1 machine. The log file complains that "host.MYD" is missing; I don't see mention of this file in the documentation, and it's not on my computer anywhere. Also, the mysql.sock file is not present, and I don't know how to create it --

Re: HAVING vs. WHERE

2003-03-05 Thread Dan Nelson
In the last episode (Mar 05), Jonathan Arnold said: > In the MySQL reference, it warns against using HAVING for items that > "should" be in a WHERE clause. I'm not sure what items "should" be in > a WHERE clause. The WHERE clause is used to restrict records, and is also used by the query optimizer

Re: HAVING vs. WHERE

2003-03-05 Thread Benjamin Pflugmann
On Wed 2003-03-05 at 11:17:37 -0500, [EMAIL PROTECTED] wrote: > In the MySQL reference, it warns against using HAVING for items > that "should" be in a WHERE clause. I'm not sure what items > "should" be in a WHERE clause. Everything except stuff that only works when it's in the HAVING clause. The

Re: HAVING vs. WHERE

2003-03-05 Thread Tore Bostrup
HAVING is for qualifying result rows based on the value of aggregate functions, WHERE is for qualifying result rows based on individual (column) values. So in you case you should use WHERE. Although useful in the right situation, HAVING is used much less than a WHERE clause. One example of how t

Re: HAVING vs. WHERE

2003-03-05 Thread Paul DuBois
At 11:17 -0500 3/5/03, Jonathan Arnold wrote: In the MySQL reference, it warns against using HAVING for items that "should" be in a WHERE clause. I'm not sure what items "should" be in a WHERE clause. If a test can be in either clause, put it in the WHERE clause. The principle is that the sooner y

Re: HAVING vs. WHERE

2003-03-05 Thread Stanimir Dzharkalov
go to http://www.mysql.com/doc/en/Miscellaneous_functions.html and take a look at inet_ntoa and inet_aton you may store IP addresses as integers and the query will be SELECT inet_aton(inetAdr), * FROM Client WHERE inetAdr < inet_aton('240.0.0.0') OR inetAdr>inet_aton('239.255.255.255') the inet

HAVING vs. WHERE

2003-03-05 Thread Jonathan Arnold
In the MySQL reference, it warns against using HAVING for items that "should" be in a WHERE clause. I'm not sure what items "should" be in a WHERE clause. My exact problem is I want to select some records that have a dotted IP address as one of the fields. And I want to filter out the multicast add

re: re: Simple subtraction problem

2003-03-05 Thread Victoria Reznichenko
On Tuesday 04 March 2003 19:35, Jamie Jennings wrote: > Yes that must be it. Both columns are unsigned. Is > there any way to accomplish this with one query with > unsigned columns? Take a look at cast functions: http://www.mysql.com/doc/en/Cast_Functions.html > Otherwise I will have to

re: activate Innodb on mysql 3.23.49-3 (linux) ?

2003-03-05 Thread Victoria Reznichenko
On Tuesday 04 March 2003 22:38, François Roussel wrote: > I want to add transaction support to an > existing database running > on mysql 3.23.49-3 distributed with Red Hat 7.3. > > After browsing through the Mysql and the Innodb documentation, it appears > that > I have the following options: > >

re: Can't use more than one alias with temp-tables

2003-03-05 Thread Victoria Reznichenko
On Wednesday 05 March 2003 16:08, correll at gmx dot de wrote: > >Description: > > When using more than one alias on a temporary table I get the error > message: > ERROR 1137: Can't reopen table: 'first_alias_name' > > The only thing I found about this error is a fix in version 3.23.36

Re: Fwd: data-retrieving udf

2003-03-05 Thread Joseph Bueno
hi, There is an example (udf_example.cc) in 'sql' sub-directory of mysql sources. You can code your functions in C++ but you must declare your UDF entry points as 'extern "C"' Regards, Joseph Bueno Maurizio Oristanio wrote: hi everybody, i'm trying to add a udf to mysql that itself accesses the

RE: Count (*) function results needed in echo statement

2003-03-05 Thread Stitchin'
Just wanted to let y'all know this worked awesome! Thanks so much! Renee :) -Original Message- From: Sqlcoders.com Programming Dept [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 11:20 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Count (*) function results needed in e

Fwd: data-retrieving udf

2003-03-05 Thread Maurizio Oristanio
hi everybody, i'm trying to add a udf to mysql that itself accesses the database. anybody ever tried that? i want a function to dynamically create a database, symbolic links and tables. i thought it could be as easy as just mix up a "normal udf" with my table-creating thing. but when i try to cre

too many open files, error 24, but max-files is large

2003-03-05 Thread Johannes Ullrich
on mysql 4.0.10-gamma (rpm install, Redhat advanced server), I am running into 'too many open files' issues ( error 24 ). I am using a rather large merge table (30 distinct tables merged), which is likely the culprit. The error shows up as I have about a dozen of connections. I did increa

Re: Fwd: how to handle a 10GB index-file?

2003-03-05 Thread Johannes Ullrich
Two solutions to your problem: table full errors: check the 'AVG_ROW_LENGTH' and 'MAX_ROWS' option for create and alter table. You can change these on the fly using 'alter table', but it will take quite a time for a table your size (few hours-1 day depending on machine). The exact values for t

RE: replace string

2003-03-05 Thread "Paracková Eva, Ing"
i would use following $query_del = "UPDATE favorites set favorites='".REPLACE(favorites,'BitOfStringToReplace','NewBitOfString')."' WHERE email='$email' AND password = '$pw'"; eva -Original Message- From: Dillon, John [mailto:[EMAIL PROTECTED] Sent: 5. marca 2003 15:53 To: '[EMAIL PROTE

RE: replace string

2003-03-05 Thread Dillon, John
I want to replace part of a string with something else. I have a table called favorites. This can be done by someone who logs in on the browser with email and password. I'm using php in a web page. Do I use the following syntax: $query_del = "UPDATE favorites REPLACE(favorites,'BitOfStringToRe

Re: Table Design

2003-03-05 Thread gerald_clark
Band members should probably be in a separate table. One person may be a member of several bands, and the membership in a band changes over time. This will make modeling difficult. [EMAIL PROTECTED] wrote: Hello, I`m doing a database in MySQL to catalog cds, and i`m not sure if my table structure

Re: How to tell when mysql has frozen

2003-03-05 Thread gerald_clark
Is your temp directory running out of disk space? Seth Brundle wrote: I attempted to optimize a table last night, which usually takes about 5 minutes but I expected to take longer as I had done a slew of deletes. Well, it took over an hour, and from the last modified dates on the table and temp f

Double Select?!

2003-03-05 Thread Steve Vernon
Hiya, Any help would be appreciated! Due to various hardware requirements, on our exiting server space is a problem not speed. I store a lot of details of members, and have worked out that I will save space by storing lastname's, firstname's etc in a seperate table. e.g. lastname

Can't use more than one alias with temp-tables

2003-03-05 Thread correll
sorry for only half-using mysqlbug, Martin >Description: When using more than one alias on a temporary table I get the error message: ERROR 1137: Can't reopen table: 'first_alias_name' The only thing I found about this error is a fix in version 3.23.36 which seems to cope with the t

Fwd: how to handle a 10GB index-file?

2003-03-05 Thread Andreas Bourges
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, ...I have a quite critical problem and didn't find anything on mysql.com or via google :-( Maybe someone here has some hints for me? The data file .MYD of a certain table has a size of 7.3 Gig and the corresponding index file .MYI has a size o

Re: latin1_de with index

2003-03-05 Thread Thomas Spahni
On Tue, 4 Mar 2003, Fabian Schmidt wrote: > >Description: > A select returns uncomplete results, when querying an indexed > varchar row with latin1_de character set and strings containing umlauts > or 'ß'. > > >How-To-Repeat: > > start MySQL 4.0 with character set latin1_de. > > create table

Re: Need help about SQL sintax

2003-03-05 Thread Jamie Jennings
This should do what you want: UPDATE Table2, Table1 SET Table2.DataDestination=Table1.DataSource WHERE Table1.col1=Table2.col1 AND Table1.col2=Table2.col2 AND Table1.col3=Table2.col3; --- PandaCoop-Krasimir_Slaveykov <[EMAIL PROTECTED]> wrote: > Hello mysql, > I have 2 tables : > > Table1:

Re: Load Balanced Mysql Cluster

2003-03-05 Thread Joseph Bueno
Hi, We had a similar problem and we have taken a different approach: Instead of having dedicated slave servers, we configure a slave mysql server on each webserver. Each webserver connects only to 'localhost' slave mysql server. Each slave server only deals with local connections (200 in your ca

Re: [PATCH]: proper usage of errno in mysql 4.0.11a

2003-03-05 Thread Sergei Golubchik
Hi! On Mar 05, Arkadiusz Miskiewicz wrote: > Hi, > > This patch fixes errno usage. Often in mysql there is assumption > that errno is simple int variable while it is not in glibc (>=2.3.1). > It's a macro. Thank you. It was fixed since 4.0.11 (though, somehwhat simplified way - #include was add

External clients with MySQl 3.23 on Redhat 8.0

2003-03-05 Thread simon . windsor
Hi I am having problems setting up an ODBC client on Windows XP for a Redhat server running MySQL 3.23-54. I have seen some references to other people having this problem. Does anyone know about this, and a fix? I don't want to rebuild the server with Debian/Suse (where I have done this befo

query re: Innodb Table Locks

2003-03-05 Thread Erik DeBattista
to whom it may concern, I need some help regarding transactions using innodb tables. I am running MySQL 3.23.51-Max as database server and developing a web front-end using ASP. Many of the tables used are of innodb format since it is imperative for me to use transactions in most of my scripts. I

Ãâ·ÑËÍ800Ôª£¬ÌáÃûÒ»ÈËËÍ200Ôª£¡¿ìÀ´°¡£¡£¡

2003-03-05 Thread YiYi
过年大礼炮! http://www.richmails.com/cgi-bin/[EMAIL PROTECTED] 注册送800元发展一个下线得过200元。 也许你进来,你就已经成功啦,只要你注册,你就有100美圆的收入,如果你发展一个下线就有25美圆的收入,这样,20个下线,你就有500美圆的收入了,为什么不试试呢?如你想赚钱的话就到下面那儿注册。 http://www.richmails.com/cgi-bin/[EMAIL PROTECTED] 是到目前为至最阔气的网站。只要你加入马上就送你100美元,介绍一人给你25美元!它支持6层下线,只要你有下线加入:第1层10

Re: mysql 4.0.11-gamma: TRUNCATE bug

2003-03-05 Thread Sergei Golubchik
Hi! On Mar 05, Dr. R. Rajaraman wrote: > Hi, > > I am a new user (hardly a month old) to mysql. > > My configuration: > P4 with Windows 2000 prof, apache, PHP4.3, Mysql > 4.0.11-gamma, phpmyadmin > 2.4.0. > > Now my problem is, a user with no privilege is able to run SQL command > TRUNCATE to

Need help about SQL sintax

2003-03-05 Thread PandaCoop-Krasimir_Slaveykov
Hello mysql, I have 2 tables : Table1: col1 col2 col3 DataSource Table2: col1 col2 col3 DataDestination How to update Table2.DataDestination with value of Table1.DataSourse where table1.col1=table2.col2 and table1.col2=table2.col2 and table1.col3=table2.col3 -- Best

related tables result collected in one field…

2003-03-05 Thread Victor Spång Arthursson
Hi! I'm having this main table with references to files in it: kod: +-+-+ | id | filnamn | +-+-+ |168 |v008-12.jpg| +-+-+ Then I have this table to relate one file to one or several categories: +-++--+ |id | fromid

Re: [PATCH]: proper usage of errno in mysql 4.0.11a

2003-03-05 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 5 Mar 2003, Arkadiusz Miskiewicz wrote: > This patch fixes errno usage. Often in mysql there is assumption that > errno is simple int variable while it is not in glibc (>=2.3.1). It's a > macro. Thanks! We've fixed this differently in th

myisamchk vs repair and optimize

2003-03-05 Thread Salvesen, Jens-Petter
Hello everyone I have a question. In a MySQL 3.23 server running on Linux (RH 7.x), can I symlink the data files and index files of MyISAM tables to different disks for better performance? After RTFM, it seems that commands alter, repair and optimize will migrate the files back to the same disk au

Re: Peculiar Problem During Transactions

2003-03-05 Thread Heikki Tuuri
Raghu, - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, March 05, 2003 7:03 AM Subject: Peculiar Problem During Transactions > > Placed At : MAATDLN > > Hi, > > I have a database with

[PATCH]: proper usage of errno in mysql 4.0.11a

2003-03-05 Thread Arkadiusz Miskiewicz
Hi, This patch fixes errno usage. Often in mysql there is assumption that errno is simple int variable while it is not in glibc (>=2.3.1). It's a macro. See http://lists.debian.org/debian-glibc/2002/debian-glibc-200212/msg00364.html Patch by Artur Frysiak <[EMAIL PROTECTED]> that fixes that (and

mysql 4.0.11-gamma: TRUNCATE bug

2003-03-05 Thread Dr. R. Rajaraman
Hi, I am a new user (hardly a month old) to mysql. My configuration: P4 with Windows 2000 prof, apache, PHP4.3, Mysql 4.0.11-gamma, phpmyadmin 2.4.0. Now my problem is, a user with no privilege is able to run SQL command TRUNCATE to empty any table! First I reported it to phpmyadmin team and a

Help My Sql

2003-03-05 Thread Asif Solkar
Please Send me a link from where i can download MySql Database for windows and MySqlGui for windows i have been trying to download from the site (MySql.com) but was unable to do so please send me at earliest Awaiting for ur mail Asif __ Do you Yahoo