RE: MySQL statements

Hi there Can someone tell me what process MySQL follows to process SQL statements/queries? Is it top down or bottom up? Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel:

Unexpected subquery behaviour

Hi all! I'm using subqueries in MySQL 4.1.1 alpha. I use three subqueries and then want to get those combinations matching a given constraints. It is a very simple task, but I get less results than I expected. In fact, I tried to execute the same query in ORACLE and I get 23 results (in MySQL

Re: concurrent users sessions? !!!!!!

Alaios [EMAIL PROTECTED] wrote: Do u know how many users the MySQL server v4 can't support? I am talking about the users that are currently online. I want to know the maximum number for the MyISAM tables and InnoDB Do u know any links for continue reading? Number of connections is

Re: Unexpected subquery behaviour

Jaime [EMAIL PROTECTED] wrote: I'm using subqueries in MySQL 4.1.1 alpha. I use three subqueries and then want to get those combinations matching a given constraints. It is a very simple task, but I get less results than I expected. In fact, I tried to execute the same query in ORACLE and

MySQL update 4.0.20 w/RPM's

Hello, got this error when upgrading our MySQL: rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm Preparing...### [100%] file /usr/lib/libmysqlclient.so.12.0.0 from install of MySQL-shared-4.0.20-0 conflicts with file from package

Questions on index and 'order by'

I try to understand index usage for 'order by' but that's seemn hard to me. Here is what I have tried : 1_ About documentation I have read carefully related documentation (7.2.9 How MySQL Optimizes ORDER BY) but I don't understand it. - What is the difference betwween 'key1' and 'key_part1' ?

merge tables for big log files ?

Hello *, goal: using merge tables for annual / monthly storage of syslog information using php-syslog-ng and syslog-ng problem: -one actual table must be available for inserts -the merge table needs to be the target for reports and queries -static parts of the merge table should be

Re: MySQL Benchmark. OT and beyond...

On Thu, May 27, 2004 at 02:20:46PM -0400, RV Tec wrote: Eric, I am sure all FreeBSD users are sick and tired of saying this. USE 4.10 Lots of people blindly follow version numbers but 5.x is a lot different than 4.x in ways I don't yet feel comfortable with using on production

Re: merge tables for big log files ?

On Mon, May 31, 2004 at 02:03:09PM +0200, Michael Arndt wrote: Problem for this variant: merge table has to be dropped and recreated periodically. during the short lag interval the log merge table does not exist

Re: Unexpected subquery behaviour

Monday, May 31, 2004, 12:28:20 PM, you wrote: J I'm sorry, but I'm using Windows. There is no 4.1.2 version available yet Ok. Could you create a repeatable test case? You can upload structure of tables and data for testing to ftp://ftp.mysql.com/pub/mysql/upload/ and let me know a file name. J

Re: MySQL Benchmark. OT and beyond...

Folks, FreeBSD 5.x does a lot of things really well, and it can be very fast too, but there's no stable release of 5.x yet, and the 5.x code is clearly hampered speedwise by the presence of loads of debugging code. From the 5.x documentation: --- NOTE TO PEOPLE WHO THINK THAT FreeBSD 5.x

redhat9 multiple instances walkthrough

Hey, I have RedHat 9, with the default MySQL RPM pre-installed. I'd like to set up multiple instances of MySQL. That is, have multiple data directories(all with separate mysql database and tables) on different ports.(I have a few projects which share user names but different privileges). What I

update synopsis error

hi, mysql update table1 set c = (select c2 from table2 where c2 = 'value') where id = 123; give me an ERROR 1064. i.e. create table t1 ( id int primary key, name varchar(20) ); create table t2 ( id int primary key, name varchar(20) ); insert into t1 values(1, 'not right') insert into t2

Trigger and StoreProc Examples

Hello ALL, I need a examples of stored procedures and triggers in mysql 5.0. Please send me all sintaxes of this regards Carlos J Souza [EMAIL PROTECTED] 2004-05-31 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Trigger and StoreProc Examples

Carlos J Souza [EMAIL PROTECTED] wrote: Hello ALL, I need a examples of stored procedures and triggers in mysql 5.0. Please send me all sintaxes of this Triggers are not supported in v5.0. Example of stored procedure you can find in the manual at:

Re: update synopsis error

saiph [EMAIL PROTECTED] wrote: mysql update table1 set c = (select c2 from table2 where c2 = 'value') where id = 123; give me an ERROR 1064. i.e. create table t1 ( id int primary key, name varchar(20) ); create table t2 ( id int primary key, name varchar(20) ); insert into t1

Re: merge tables for big log files ?

Hi Michael, Problem for this variant: merge table has to be dropped and recreated periodically. during the short lag interval the log merge table does not exist You don't have to drop and re-create the table. Please

MySQL sharing data over NFS ??

Hello List: I want to setup two servers (later more servers added) sharing mysql data as a NFS Server Client relationship; Server-A: -- RH9, mysql-4.0.20, NFS Master This server is a DATA server. All data for the entire site is kept on this server in /usr/local/mysql/var which is

independent database

Hi all! I would like that my users can read/write/execute just them database and that they can not read/write/execute other users's database. How shoul I set up? This is because I have to host some web site and I want to give independent access to features. Tnks! marco -- MySQL General

RE: independent database

Hi Marco, You can create one database for each user, and grant access to this database only for this user. Laercio. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: segunda-feira, 31 de maio de 2004 14:40 To: [EMAIL PROTECTED] Subject: independent database Hi

Re: MySQL sharing data over NFS ??

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 31 May 2004 12:08 pm, Kirti S. Bajwa wrote: Hello List: I want to setup two servers (later more servers added) sharing mysql data as a NFS Server Client relationship; There is a document on the mysql web site that cleary states that

Stop Scrolling

Ultimately simple, but I don't find the answer: how to stop a list from scrolling to the bottom when the command SHOW TABLES is entered. Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

rework this

I need help with this SQL. I want to delete all records from the 'audit_log_records' table that have 'tracker_id' columns that are the same as those from the audit_log table that have 'A' for the operation type. delete from audit_log_records where tracker_id=(select tracker_id from audit_log

RE: rework this

It depends on which version of MySQL you are using. Since you are using a subquery, I assume you are using a fairly new version. Delete audit_log_records from audit_log_records, audit_log where audit_log_records.tracker_id = audit_log.tracker_id and audit_log.operation='A' That should be it.

Re: rework this

On 05/31/04 15:42 Donny Simonton spoke: It depends on which version of MySQL you are using. Since you are using a subquery, I assume you are using a fairly new version. Delete audit_log_records from audit_log_records, audit_log where audit_log_records.tracker_id = audit_log.tracker_id and

Re: Feature Request: UPDATE 'error codes' or mysql_affected_rows() to be more accurate

Daevid Vincent wrote: Well, my hack (which is sort of like what you suggest) is to change my primary key from just an auto_increment 'id' field to a combination of two other fields (mac/scanner_id) that I know must be unique. Then I rely upon the fact that mySQL will not allow a duplicate PK. (I

compile mysql cluster

Hi, I am trying to compile MySQL cluster source code on linux RedHat 9. The software required are all installed with the right versions. And I use the file BUILD/compile-pentium-max as suggested in Introduction documents. But the compilation fails, and I got some output about errors as

Re: Questions on index and 'order by'

Bernard Chambon wrote: I try to understand index usage for 'order by' but that's seemn hard to me. Here is what I have tried : 1_ About documentation I have read carefully related documentation (7.2.9 How MySQL Optimizes ORDER BY) but I don't understand it. - What is the difference betwween

Re: update synopsis error

What version of MySQL are you using? Subqueries aren't available until 4.1.x. saiph wrote: hi, mysql update table1 set c = (select c2 from table2 where c2 = 'value') where id = 123; give me an ERROR 1064. i.e. create table t1 ( id int primary key, name varchar(20) ); create table t2 ( id int

Select data from two different databases

Hi, two questions: Is it possible to select data from different Databases on the same server? Is it possible to select data from different Databases on Different servers across the network? I searched for information on how to do it, but i haven't found any. Best Regards Alejandro

Re: Stop Scrolling

- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 31, 2004 2:20 PM Subject: Stop Scrolling Ultimately simple, but I don't find the answer: how to stop a list from scrolling to the bottom when the command SHOW TABLES is entered. I was wondering

Re: [MySQL] Re: Stop Scrolling

Rhino wrote: Ultimately simple, but I don't find the answer: how to stop a list from scrolling to the bottom when the command SHOW TABLES is entered. I was wondering that myself so I took a look in the manual and found something promising: pager. See

Re: Stop Scrolling

Rhino wrote: - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 31, 2004 2:20 PM Subject: Stop Scrolling Ultimately simple, but I don't find the answer: how to stop a list from scrolling to the bottom when the command SHOW TABLES is entered. I

Re: Select data from two different databases

Oropeza Querejeta, Alejandro wrote: Hi, two questions: Is it possible to select data from different Databases on the same server? Is it possible to select data from different Databases on Different servers across the network? I searched for information on how to do it, but i haven't found any.

syntax error

I want to do something like this: delete from records where records.id in (select audit_log_records.id from audit_log_records, audit_log where audit_log.tracker_id=audit_log_records.tracker_id and audit_log.operation='D'); -- MySQL General Mailing List For list archives:

Using IF clause

Hi my table have an field when users can enter any chars If users dont send any content for that field(phone), mysql store ( ) - without quotes in that What im looking for: Display IF phone field is ( ) - NOT ENTER Otherwise display the phone of user. It's

optimize table - OK to abort?

I've been running OPTIMIZE TABLE on a MyISAM table with an index on two varchar type columns. The process status shows as Repair with keycache. The table has 73 million rows. OPTIMIZE TABLE has been running for several days with constant disk activity but low cpu usage and no way to estimate

Root users permissions not working

Hi Guys, I have been using mysql for a year now without any problems. Recently, I just noticed that my root user is not able to create any databases when I login. I have tried to change my root password and try but it does not work: -- #mysql -u root -psomepassword Welcome to the MySQL

RE: Root users permissions not working

hi this may be the problem or it may just be a typo! you are showing #mysql -u root -psomepassword which should be #mysql -u root -p somepassword (note the space after -p) the first will not pass the password, which would explain the lack of privileges. Otherwise start with

RE: Root users permissions not working

Peter, Actually, Mysql -uUSERNAME -pPASSWORD works just fine. Donny -Original Message- From: Sunmaia [mailto:[EMAIL PROTECTED] Sent: Monday, May 31, 2004 7:44 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Root users permissions not working hi this may be the

4.1 Beta

Hi Guys, I'm just wondering if anyone could tell me when 4.1 will be moving to Beta? I was told by a MySQL guy at Linux Conf AU 2004 (January) that 4.1 would be in Beta by March!! As such, we have been developing applications on 4.1, but are hesitant to roll them into production on Alpha

Perl arrays into MySQL

This may be a silly question, but I am wondering if there is something opposite to: @row = $sth-fetchrow_array In other words, instead of fetching rows from MySQL and loading them into an array that can be accessed from Perl, I want to do the opposite - take a Perl (associative) array and load

RE: 4.1 Beta

Jonathan, I have no idea, but I can tell you about the stability of the 4.1 tree from my experience. If you are using MySQL for anything besides prepared statements, I would say don't worry if it's beta or not. It works and works great! The only reason I mention anything about prepared

error

I've installed mysql on my windows 2000 system, with the windows installer. When it's done and I double click on winmysql admin I get this error - The dynamic link library LIBMYSQL.dll could not be found in the specified path C:\mysql\bin;.;C:\WINNET\system32;C:\WINNT\system etc

Re: error

sure that isn't c:\winnt\system32? see if you can find the libmysql.dll file on your computer and copy it into c:\winnt\system. It's not the most elegant solution...but it'll work. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 31, 2004 7:38 PM

Re: error

i had the same problem, for me it was here: c:\mysql\lib\opt and I copied it to c:\mysql\bin\ that got me up and running. maybe it'll work for you. cheers - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 10:38 AM Subject: error I've

Re: Perl arrays into MySQL

Nik Belajcic wrote: This may be a silly question, but I am wondering if there is something opposite to: @row = $sth-fetchrow_array In other words, instead of fetching rows from MySQL and loading them into an array that can be accessed from Perl, I want to do the opposite - take a Perl

Re: Stop Scrolling

[EMAIL PROTECTED] wrote: Ultimately simple, but I don't find the answer: how to stop a list from scrolling to the bottom when the command SHOW TABLES is entered. I assume you are referring to the command line of the mysql client? I use: mysql\P more or mysql\P less depending on my mood. Other

RE: Feature Request: UPDATE 'error codes' or mysql_affected_rows() to be more accurate

At 12:38 -0700 on 05/27/2004, Daevid Vincent wrote about Re: Feature Request: UPDATE 'error codes' or mysql_affected: REPLACE INTO won't work, as I need the previous record (hence the update). I store the first and last time I saw a node, amongst other info. REPLACE would delete that data.

Re: Root users permissions not working

Peter, Actually, Mysql -uUSERNAME -pPASSWORD works just fine. Donny And `mysql -u root -p somepassword` will not work. With the space between -p and somepassword, mysql will attempt to interpret somepassword as the name of a database. As to the original question, the problem appears to

Re: Using IF clause

ColdFusion Lists wrote: Hi my table have an field when users can enter any chars If users dont send any content for that field(phone), mysql store ( ) - without quotes in that What im looking for: Display IF phone field is ( ) - NOT ENTER Otherwise display the phone of user.