Problem myODBC 3.51.05

Configuration: - WinXP SP1 (Workstation) - Windows 2000 SP2 (Server) - MySQL 4.0.4-beta-max-ny-log - MyODBC 3.51.05 - InnoDB - Delphi 7 - ADO 2.7 Problem with simple query Delphi/MyODBC 3.51.05: - qry.SQL.Add('select * from lokalen'); - qry.open; When I open the query, the next message is

Is it a bug

Hi, I have installed mysql max 4.0.4 beta on a Suse (ver. 8.0) linux server and I have created a database with this schema: CREATE TABLE ecoras ( rsnum tinyint(4) NOT NULL, rsori tinyint(1) NOT NULL, rscod int(11) NOT NULL, rsid int(11) NOT NULL auto_increment, rsdat date NOT NULL

Peculiar Problem

Placed At : MAATDLN Govind Raghuram@SATYAM 12/31/2002 02:50 PM Hi, I am trying to do an update query - update bb_activeamtbalance set ui_orgbalance = +orgbalance+,ui_remainingbalance

user's trace

hi all, anyone knows how to get the history of a user? ... i mean ... in my database i have a lot of user with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it possible? i check the bin logs but they seems not to trace the user

load data local infile

Hi, I have just upgraded to 3.23.54 How to input bulk data into table? I have tried: LOAD DATA LOCAL INFILE lcopen1.txt INTO TABLE lcopen; but it shows: ERROR 1148: The used command is not allowed with this MySQL version What did I miss? What method can I use to input bulk data? Terence Ng

RE : Optimizing

The server is mainly a Web server (Linux RedHat 7.3, P3 1GHz, server chipset, 500M) with CPU usage 5% CPU states: 1.7% user, 0.3% system, 0.0% nice, 97.8% idle Mem: 513900K av, 502676K used, 11224K free, 0K shrd, 114640K buff Swap: 522072K av, 0K used, 522072K free

Re: An Idea

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % So (taking a deep breath !) I would be prepared to lay the foundations ... % % Thanks, I appreciate that. I've been waiting a moment before answering, % waiting for others to

RE: An Idea

Hi A faq without questions would be pretty empty! While you have the questions why not keep a note (or send them to me) Once we have some momentum we can put some answers and tutorials together. I thought I would email MySql to see if they like the idea, if not then I will build it. Peter

Re: ensuring an instructor, client, or room isn't double-booked

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Benjamin, et al -- ...and then Benjamin Pflugmann said... % % Hi David. Hi! % % On Sun 2002-12-29 at 16:21:56 -0500, [EMAIL PROTECTED] wrote: % ...and then Benjamin Pflugmann said... % [...] % No; everything is one hour. Two hours is two

Re: altering data structure

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Benjamin, et al -- ...and then Benjamin Pflugmann said... % % Hi again. And again :-) % % On Sun 2002-12-29 at 15:21:33 -0500, [EMAIL PROTECTED] wrote: % ...and then Benjamin Pflugmann said... % [...] % % Of course, that's only possible if you

Re: Mysql.Sock problem

I had this same problem... for 4 Days! Check the permission on the /var/lib/mysql directory. Check the logs /var/logs/mysql.log to make sure its not crashing or not connecting Check the permissions on the /var/run/mysql it should have rwxr-xr-x mysql mysql (this was my problem) I thought I

Re: replication

On Mon, 30 Dec 2002, Arthur Fuller wrote: Is there in *nix an implementation of GUIDs? If the MS math is to be believed, GUIDs are guaranteed unique for the next century. No matter how many monkeys are at the typewriters. Supposing a) that there is a *nix GUID implementation, what's the right

Bug? ORDER BY UPPER(alias) doesn't work.

Hi, is this a bug or not? I'm using MySQL 3.23.49! When I want to use this: SELECT CASE WHEN hmContactGroup.Id = 1 THEN CONCAT(hmContact.FullName, ' ', hmContact.CountryId) ELSE COALESCE(hmContact.DjName, hmContact.FullName) END AS ContactName FROM hmContact,

Re: manual for 3.23.53 pdf?

On Mon, 30 Dec 2002, Richard Nagle wrote: looking for a pdf manual for mysql 3.23.53 anyone? You may build it yourself: texi2dvi4a2ps -p manual.texi Thomas Spahni - Before posting, please check:

Re: Mysql.Sock problem

It appears that we both are climbing the same mountain. The best approach is to hire a consultant to come in and get you started in the right direction. If, as is our case, this is unlikely, I will attempt to relay to you some of what I have encountered so far. Typically we prefer downloading

Re: Privileges in MySQL 4.0.7 (upgrade)

Dear list, no one has answered my question up to now. Looking through the manual again today, I still can't figure out what to do. just upgraded from MySQL 4.0.3 to 4.0.7 on my Win2K box at home. The problem is, I still have the _old_ privileges in my mysql tables, not the new ones like super,

Re: Privileges in MySQL 4.0.7 (upgrade)

Stefan, you may want to take the queries from the mysql_fix_privilege_tables shell script and run them manually. All queries are nice and clean in the script and can be extracted with any editor. Thomas Spahni On Tue, 31 Dec 2002, Stefan Hinz wrote: just upgraded from MySQL 4.0.3 to 4.0.7 on

Re: Privileges in MySQL 4.0.7 (upgrade)

Dear Thomas, you may want to take the queries from the mysql_fix_privilege_tables shell script and run them manually. Thanks! If only I could find this script ... Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin

Re: An Idea

David, regarding the MySQL FAQ: Why should it have to be there? Let anyone with a site set it up and get it going and see if readers will even care about it, and *then* perhaps have it move to mysql.com later... MySQL.com would be the natural place for the FAQ. Any other place wouldn't be

Year Lists

Hiya, I have a database about projects in a company, they all have a start year and end year. If the projects have not ended then they get a end year of . I have made a SQL command, given a year, works out with projects are running in that year. The company I am doing this for, wants

Re: Year Lists

On Tue, 2002-12-31 at 14:53, Steve Vernon wrote: Hiya, I have a database about projects in a company, they all have a start year and end year. If the projects have not ended then they get a end year of . I have made a SQL command, given a year, works out with projects are running in

Re: Pattern Match on 3.23

It can perform pattern match on text field. The only draw back is the speed (especially if you are using %pattern% to do the search) when you tables are getting huge, since there is no index to help. Qunfeng --- Frank Peavy [EMAIL PROTECTED] wrote: I would like to use pattern matching as a

What does this mean? : Warning: thr_alarm queue is full

Hi! Chung == Chung Ha-nyung [EMAIL PROTECTED] writes: Chung query. Chung I happened to find out that the lots of following error messages are Chung stored Chung error log file: Chung Warning: thr_alarm queue is full Chung What's this? Is it serious problem? The above is a very strange

Re: nested transactions?

Heikki Tuuri wrote: Transaction savepoints are already implemented internally inside InnoDB. The MySQL support for the syntax might come around August 2003. If someone is willing to sponsor the implementation, they may come quicker. For the sake of those with more programming time than

Re: Year Lists

Martin, Thanks for the reply. Good plan but at the moment my query is like (had to alter it slightly as it was in PHP and multiple lines, so dont take it as working). SELECT projects.name, project.endyear, project.startyear FROM projects WHERE projects.startyear = '(INPUT THE YEAR HERE)

Re: Pattern Match on 3.23

Qunfeng, Thanks for the feedback, I surely appreciate it. I asked the pattern match question, because I am using a hosting service that hosts MySQL 3.23. Since I have a need to search on terms less than 3 characters long and I can not re-compile, I was looking for another solution. I thought

Re: Pattern Match on 3.23

If you are searching with %pattern%, your speed is depending on the speed of table-scan. The speed of tablescan depends on your my.cnf setting (increase record buffer size?) and how big your records are. I am using pattern search here with millions of records and the performance is not terriblly

Re: Year Lists

Sounds to me like you'll need to join for that -- and list all the years you are interested in in another table. Try this? SELECT y.Year, count(*) FROM Year as y LEFT JOIN projects ON project.startyear=y.Year AND project.endyear=y.Year GROUP BY y.Year; This will give you a count of 0 for any

Re: Upgrade to MySQL 4.0.x

I have a few questions about whether or not I should upgrade to MySQL 4.0.7-Gamma on my Windows XP system. I am now running MySQL 3.23.54a on my Laptop. Its used for developing/testing, and the applications needs to be transported to the final server after completion. Most of the time however

RE: Binary Data and BLOB Problem

Mike, Thank you very much for responding to my question. Haven't been able to find much out there. Your article, to which you referred in your response, was something I have already used to get me as far as I had gotten. I'd found it in my search for an answer. I found the connection string

Is the Max edition of 4.0.7 required if running on a server with RAID?

Hi, all. I've been using 4.0.5 beta-max-nt on my development PC for about a month and am getting ready to transfer the web app and install MySQL on a server which uses RAID. Is the Max edition of 4.0.7 necessary for a server with RAID. Or can the standara edition be used? Also, I'm still

Re: Pattern Match on 3.23

Qunfeng, ..millions of records.. seems like a lot... Would you be kind enough to provide me with your hardware configuration? Thanks. At 07:57 AM 12/31/02 -0800, Qunfeng Dong wrote: If you are searching with %pattern%, your speed is depending on the speed of table-scan. The speed of tablescan

Mysql - How to use more than 32 index in a table ?

Hi, How to use more than 32 index in a table ? I need to use 68 index in one same table (Mysql v 3.23.44. How to make ? Thank you, Alberto J. Alvares - Before posting, please check: http://www.mysql.com/manual.php (the

RE: HELP for mysql ended error

If you check the MySQL reference guide, you'll see that the Errorcode 13 is indicating that you don't have your permissions set up correctly for your data and log directories. Once you fix that, you should (hopefully) be okay. David Christensen Brokers International, Ltd. 1200 E Main St PO Box

HELP for mysql ended error

I am trying to upgrade the mysql database. I am installing on a Unix (SGI's IRIX) platform, upgrading to 3.23.52. I am installing a tar distribution (binary) from SGI's freeware web site. The installation goes fine - no errors - execpt when I try to start mysql it returns mysql ended and will not

Re: ensuring an instructor, client, or room isn't double-booked

David, On Tue 2002-12-31 at 06:47:38 -0500, [EMAIL PROTECTED] wrote: [...] Oh, I see... I've been thinking about that, too; I currently use a datetime field, but all I really need is a date and an hour. I figure with one combined field I can match against -YY-ZZ% but maybe two fields

Problems / Reset password / switching to decafe

I been trying to follow the instruction at mysql site to fix mysql, and get it back up and running, so i can add databases. the problem is getting into it (mysql), for some reason the mysqladmin password does not work. so, been forced to kill -9 pid and try the mysql instruction to rest

Re: GET_LOCK locks

Re: GET_LOCK locks Is there a way to show the status of locks created in this fash- ion? I'm looking for something that would list the locks current in existance, and which thread is holding it. filter: sql, mysql, mysqladmin

req. for help for installing mysql under linux

Hi all, I am a newbie(student) to mysql in linux environment. I was trying to install the mysql-3.23.51-pc-linux-gnu-i686.tar.gz on my linux - mandrake 8.2 from sourceforge.net. When I type in ./configure, it says, there is no need to configure for binary..., then the mysqld starts and

fighting with select distinct

Stuck on this join temp (MySQL ver 3.23) From one table I need: mysql_query(CREATE TEMPORARY TABLE temp TYPE=HEAP SELECT DISTINCT field1, field2 FROM $table); both field1 and field2 have various repeating data and I need to return only the first occurance of the distinct data along with the

loading a db table into a php array from mysql

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I'm so far about knee-deep in my project where I'll be using php to talk to the mysql database and spit out my web pages. I wonder if I should be making individual calls to the database or loading a table into an array so that I can walk

Re: Pattern Match on 3.23

We are running on linux redhat 7.3, RAM 4G, I am using my.huge-cnf. 1.2Ghz dual CPUs PIII. The mySQL database resides on SCSI disk. We do pattern search on varchar or text fields of a table with about 2.6 millions records and going (it also joins with other smaller tables). Hope this helps.

Re: GET_LOCK locks

On Tue, Dec 31, 2002 at 01:49:00PM -0500, 'Bob Diss' wrote: Re: GET_LOCK locks Is there a way to show the status of locks created in this fash- ion? I'm looking for something that would list the locks current in existance, and which thread is holding it. No. -- Jeremy D. Zawodny |

Re: Pattern Match on 3.23

Thanks Qunfeng, Hope you have a Happy New Year.! At 11:17 AM 12/31/02 -0800, Qunfeng Dong wrote: We are running on linux redhat 7.3, RAM 4G, I am using my.huge-cnf. 1.2Ghz dual CPUs PIII. The mySQL database resides on SCSI disk. We do pattern search on varchar or text fields of a table with

SUMMARY - Re: loading a db table into a php array from mysql

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- ...and then David T-G said... % % I'm so far about knee-deep in my project where I'll be using php to talk % to the mysql database and spit out my web pages. I wonder if I should be % making individual calls to the database or loading a

RE: Problems / Reset password / switching to decafe

Rick, What messages are you seeing in the .err file in your logging directory? I typically run my servers with the KDE up and I use the service configuration tool to restart services. Have you tried to fire up MySQLCC and connect to your server? Dave -Original Message- From: Richard

Re: Privileges in MySQL 4.0.7 (upgrade)

At 14:26 31/12/2002 +0100, Stefan Hinz, iConnect (Berlin) wrote: Hi, Dear list, no one has answered my question up to now. Looking through the manual again today, I still can't figure out what to do. Sorry but your issue is my fault. In the next release I will update the tables. In the

simple (I thought) delete question

Hi folks, I hope that dumb questions are allowed in here ... I have two MySQL tables and I would like to delete records from one based on associated values in another. For example, using the example tables below, how would I delete all the records in the TIDS table that had an associative value

Re: Replication priority / speed

Or, alternatly, is there a way to limit the slave thread to only X bin-log transactions per second? There is not. Any plan to add this feature? I would think it'd be useful... Wouldn't it be better to *solve* your problem instead of going around it? Well, as this is how our software is

Re: simple (I thought) delete question

Richard, Tuesday, December 31, 2002, 4:12:15 PM, you wrote: Hi folks, I hope that dumb questions are allowed in here ... I have two MySQL tables and I would like to delete records from one based on associated values in another. For example, using the example tables below, how would I

Re: simple (I thought) delete question

if you want to do it in one statement, you'll need to wait for subselects to be implemented in MySql. Apparently this is underway and was scheduled to appear in MySql 4.1 if subselects were supported, you'd do something like this: delete from tids where exists ( select 1 from tids_admin where

Re: simple (I thought) delete question

Didn't fully read your question. Need the extra bit in the subselect to identify air force rows only, but again, this won't work until 4.1 with subselects is released. delete from tids where exists ( select 1 from tids_admin where tids_admin.id = tids.admin_id and tids_admin.service = 'Air

Re: An Idea

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other

load data local infile

Hi, I have just upgraded to 3.23.54 How to input bulk data into table? I have tried: LOAD DATA LOCAL INFILE lcopen1.txt INTO TABLE lcopen; but it shows: ERROR 1148: The used command is not allowed with this MySQL version How come? What method can I use to input bulk data? Terence Ng

Re: simple (I thought) delete question

I guess I am a bit confused at the response below... Please see: http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html Why can't the foreign key logic be used in version 3.23?.. At 09:45 AM 1/1/03 +1100, Greg Matthews wrote: Didn't fully read your question. Need the extra bit in the

RE: An Idea

we find people just like to ask questions, and no matter how good our FAQ's and help are, many people have circumstances that make it more efficient to push the question into the queue, and wait for an answer to pop back later. lists work, and faq's work, some like to call...etc. personally, I'd

Re: An Idea

On 12/31/02 8:11 PM, JamesD [EMAIL PROTECTED] wrote: lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of

Re: load data local infile

sound like you may want to add the following to your my.cnf file for MySQL [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Tuesday, December 31, 2002, at 06:23 PM, Terence Ng wrote: Hi, I have just upgraded to 3.23.54 How to input bulk data into table? I have tried: LOAD DATA