select statement for syslog like grouping of messages

Dear all, I do have a logging table with the fields: id, error_id, logtime and message. I am trying to create a consolidated list of log messages, syslog like, where consecutive, identical messages are combined and replaced by for example: "Last message repeated 5 times". Anyone done this? Any

Documentation on character sets for version 4.0.17

Hi, I got the 4.0.17 documentation but when it discusses character sets it discusses this topic wrt 4.1 Where can I find documentation specifically in regards to the production version on how to work with, store, and search asian character sets specifically Japanese. Thank-you David Jrt; x-a

Re: Reading MS Access tables from MySQL or Perl

Thanks for that tip. It helped me find a page which explains it properly. In case anyone else might be interested, here is the link. http://www.awilcox.com/geek_stuff/perl/proxy.html -- Nik Belajcic <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Re: Reading MS Access tables from MySQL or Perl

Nik Belajcic wrote: Hello, This is partially off-topic as I am looking at reading Access tables from either Perl (preferred) or MySQL, but if anyone has any suggestions, I will be most grateful. My first thoughts were to write a Perl script which will read 2 columns from an MS Access table and lo

RE: Integrating phpBB with an existing MySQL database

Jigal, > I know that phpBB has a few converter scripts I think the converter scripts are for a different issue. I don't have a previous BBS system that I want to convert from. All I have is user profile information stored in a simple MySQL database that I built myself. The users are subscribed to

Reading MS Access tables from MySQL or Perl

Hello, This is partially off-topic as I am looking at reading Access tables from either Perl (preferred) or MySQL, but if anyone has any suggestions, I will be most grateful. My first thoughts were to write a Perl script which will read 2 columns from an MS Access table and load them into MySQL.

Query Log

I'm pretty sure that the answer to this is "No, you cannot" but I figured I'd check anyway... As I go back through my query log, I'd like to know the user that issued the statement. If the user is still connected, I can cross reference it with the SHOW PROCESSLIST ID, but if they have signed o

Need correct 'order by' syntax where field does not contain "NULL"

Hi. I had a MySQL DB set up and recently added a field 'order' to allow for exceptions in a web site menu heirarchy. Fields should be ordered by 'order' field first where it does not contain 'NULL', and then by field 'title'. I had this previously: select * from navigation WHERE id = '".$category

Re: Need correct 'order by' syntax where field does not contain "NULL"

select * from navigation WHERE id = '".$category."' AND active='y' AND order IS NOT null ORDER BY order, title > Hi. I had a MySQL DB set up and recently added a field 'order' to allow > for > exceptions in a web site menu heirarchy. Fields should be ordered by > 'order' > field first where it do

How can one found out why a query is not cached?

I have a complex query which took 4 seconds, I set the query cache size to 512MB. BUt the query is not cached, it only returns 7 rows, so the cache size is not a problem here. Anyway I can find out why MySQL 4.1 is not caching my queries? Thanks a lot Haitao _

Re: How can one found out why a query is not cached?

At 17:02 -0700 5/3/04, Haitao Jiang wrote: I have a complex query which took 4 seconds, I set the query cache size to 512MB. BUt the query is not cached, it only returns 7 rows, so the cache size is not a problem here. Anyway I can find out why MySQL 4.1 is not caching my queries? The criteria for

RE: Need correct 'order by' syntax where field does not contain "NULL"

WHERE id = id = '"$category."' AND active ='y' AND order is not NULL ORDER by order,title > -Original Message- > From: Eve Atley [mailto:[EMAIL PROTECTED] > Sent: Monday, May 03, 2004 2:24 PM > To: [EMAIL PROTECTED] > Subject: Need correct 'order by' syntax where field does not contain > "

Re: Performance Tuning on FreeBSD

On Sat, May 01, 2004 at 09:50:14PM -0700, Max Clark wrote: > Hi all, > > I have a db that is connection heavy running on FreeBSD 4.9. The server > was compiled with Linux Threads enabled. > > I am searching for performance tuning information. Outside of enabling > Linux Threads I haven't been a

Re: float in PROCEDURE ANALYSE() / misleading CREATE TABLE error

On Mon, May 03, 2004 at 05:56:03PM +0200, Hans-Peter Grimm wrote: > Hi, > > I think there is > > 1) a problem with FLOAT recommendations in PROCEDURE ANALYSE > 2) a minor problem with CREATE TABLE(f FLOAT(,...)) I think that there is maybe: 3) a bug in PROCEDURE ANALYSE that you should report i

Re: urban myth?

Also, I'd say that it depends on what you mean by "row". If you mean the same physical data as was previously displayed, then they probably WILL come back in the same order, but there are no guarantees (a dataset is always unordered, unless something else is specified). But on the other hand, i

Re: Plz help quick - mysql/php/web server undefined function all of a sudden

"Joshua J. Kugler" <[EMAIL PROTECTED]> wrote on 05/03/2004 12:23:16 PM: > It sounds like someone upgraded your PHP libraries, and forget to include > MySQL support. Do you admin this server, or does someone else? > > j- k- Yep, I ran phpinfo.php and verified that it no longer shows su

DBD::MySQL on RH8

I am having problems with installing the DBD::MySQL Perl module. My system is: RedHat 8 (patched current) Perl 5.8.4 (installed from RPM but upgraded manually) Apache 2.0.40 Modperl 1.99 I am heading toward being able to install Best Practicals "request tracker". Currently this is a clean system

Re: Plz help quick - mysql/php/web server undefined function all of a sudden

It sounds like someone upgraded your PHP libraries, and forget to include MySQL support. Do you admin this server, or does someone else? j- k- On Monday 03 May 2004 09:20 am, Chip Wiegand said something like: > I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on > freebs

RE: urban myth?

To all who answered thank you. This answer below is the one that I can use to convince him what he proposes is not necessarily safe. Now I just need to decide how to convince him it was his idea :-) Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-22

Help with search on Japanese and version 4.015

Hi, I'm implementing a search on fields some using the latin character set and others the Japanese character set; however because its virtually hosted I'm limited to using mysql 4.015 Is the documentation for this version online. I tried to find but could only get for the latest version which

Re: urban myth?

Gerald- In my experience, I have inserted and retrieved from a decent sized db (a few million records per day), and have gotten them out in the same order. There were no other operations on the db except for cronological ones, i.e. delete the first hundred rows, insert a hundred rows. The resu

Re: urban myth?

Bob Ramsey wrote: Ah, but the ordering is not random. As your example has it, the results are in the order that the entries were inserted into the table. There is an explanation for the order of the returned data. Apparently not random, but not in the order inserted either. Consider: creat

How to get MySQL to startup at boot up for AIX 4.3.3???

Hi! I'm using AIX 4.3.3 and I'm still not able to get the MySQLDaemons to start automatically at every bootup. AIX use the inittab, not the init.d Can anyone show me the way? Thanks, FletchSOD

Re: urban myth?

On Mon, 2004-05-03 at 11:21, Bob Ramsey wrote: > Ah, but the ordering is not random. As your example has it, the results > are in the order that the entries were inserted into the table. There is > an explanation for the order of the returned data. I don't think the point of the original quest

Re: [PHP] Plz help quick - mysql/php/web server undefined function all of a sudden

"John W. Holmes" <[EMAIL PROTECTED]> wrote on 05/03/2004 10:59:15 AM: > From: "Chip Wiegand" <[EMAIL PROTECTED]> > > > I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on > > freebsd-5.1. > > It has been working fine for the past few years, now all of a sudden today > > I get an

Re: urban myth?

It's also not in the order it was entered ( as suggested ). Bob Ramsey wrote: Ah, but the ordering is not random. As your example has it, the results are in the order that the entries were inserted into the table. There is an explanation for the order of the returned data. bob At 12:55 PM 5/

Re: urban myth?

On Mon, 03 May 2004 13:21:56 -0500 Bob Ramsey <[EMAIL PROTECTED]> wrote: > Ah, but the ordering is not random. As your example has it, the > results are in the order that the entries were inserted into the > table. There is an explanation for the order of the returned data. Conceptually, row or

Re: urban myth?

Ah, but the ordering is not random. As your example has it, the results are in the order that the entries were inserted into the table. There is an explanation for the order of the returned data. bob At 12:55 PM 5/3/2004, Garth Webb wrote: On Mon, 2004-05-03 at 10:39, Boyd E. Hemphill wrote: >

Re: urban myth?

As everyone has mentioned - you should always assume the data comes back randomly - even if the table is completely static and there have been no inserts or updates, but it's even more subtle than that. When you port your application to a database than allows your queries to run multi-threaded

Re: urban myth?

On Mon, May 03, 2004 at 12:39:48PM -0500, Boyd E. Hemphill wrote: > > My boss says that if you do a select statement against a table the > result set always comes back in the same order. I say that this is a > myth and that the result is random, except when some ordering is > specified in the SQL

Re: urban myth?

On Mon, 3 May 2004 12:39:48 -0500 "Boyd E. Hemphill" <[EMAIL PROTECTED]> wrote: > My boss says that if you do a select statement against a table the > result set always comes back in the same order. I say that this is > a myth and that the result is random, except when some ordering is > specifie

Re: urban myth?

On Mon, 2004-05-03 at 10:39, Boyd E. Hemphill wrote: > My boss says that if you do a select statement against a table the > result set always comes back in the same order. I say that this is a > myth and that the result is random, except when some ordering is > specified in the SQL statement. > >

Re: urban myth?

Yes it is a myth. The records will come back in the same order IF there have been not inserts and deletes. Depends on the database product to. > My boss says that if you do a select statement against a table the > result set always comes back in the same order. I say that this is a > myth and t

RE: urban myth?

From: Boyd E. Hemphill [mailto:[EMAIL PROTECTED] > My boss says that if you do a select statement against a table the > result set always comes back in the same order. I say that this is a > myth and that the result is random, except when some ordering is > specified in the SQL statement. > > Wh

Re: urban myth?

Does the database not return it in the order that the entries are submitted? I've done some log parsing/caching in databases, and the order had always been the same whether I use an order by date or not. One thing logs to the db, the other grabs. Had no problem without an order. P "Boyd

urban myth?

My boss says that if you do a select statement against a table the result set always comes back in the same order. I say that this is a myth and that the result is random, except when some ordering is specified in the SQL statement. Who is right? Is this behavior specified by ANSI or ISO? Best

Plz help quick - mysql/php/web server undefined function all of a sudden

I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on freebsd-5.1. It has been working fine for the past few years, now all of a sudden today I get an undefined function error. This is from httpd-error.log - PHP Fatal error: Call to undefined function: mysql_connect() in /...

Re: [MYSQL] Multiple instances of server starting

Thanks, Paul. The machines are running RH 9 (one instance) and Fedora Core 1 (multiple instances). It's not really a problem, so much as a curiosity about whether the one with more processes showing was using more resources. Jim On Friday 30 April 2004 07:36 pm, Paul DuBois wrote: > At 18:02

Re: WHERE clause problem

At 11:15 -0400 5/3/04, mayuran wrote: This is my table: mysql> desc testing; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | date | date | YES | | NULL| | +---+--+--+-+-

float in PROCEDURE ANALYSE() / misleading CREATE TABLE error

Hi, I think there is 1) a problem with FLOAT recommendations in PROCEDURE ANALYSE 2) a minor problem with CREATE TABLE(f FLOAT(,...)) Please correct me if I'm wrong. With MySQL 4.0.17, the query SELECT * FROM my_table PROCEDURE ANALYSE(); gives me the following result for a DOUBLE NOT NULL col

Re: WHERE clause problem

mayuran wrote: This is my table: mysql> desc testing; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | date | date | YES | | NULL| | +---+--+--+-+-+---+ He

Re: Integrating phpBB with an existing MySQL database

Phpbb uses an md5 hash to store the passwords. You can use the mysql md5 function or php's to encrypt them. To verify md5 the supplied password and match against the table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E

RE: WHERE clause problem

From: mayuran [mailto:[EMAIL PROTECTED] > Here is my question: > > The following query returns incorrect rows and I dont understand why. > > mysql> SELECT * FROM testing WHERE MONTH(date) = (MONTH(NOW()) OR > MONTH(NOW())-1); > ++ > | date | > ++ > | 2004-01-01 | >

RE: WHERE clause problem

Hmm. Bit Odd. However, I suspect the problem is that your 'where' isn't explicit enough: Where ( month(date) = month(now()) ) or ( month(date) = month(now())-1 ) Bear in mind that if month(now()) = 1 you will be looking for records in month 0! A better way to do this might be: WHERE month(date

RE: WHERE clause problem

Try using IN(Month(Now()), Month(Now()) -1) -Original Message- From: mayuran To: [EMAIL PROTECTED] Sent: 5/3/04 10:15 AM Subject: WHERE clause problem This is my table: mysql> desc testing; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +

Re: Win & Linux

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | Another question how can see the compatibility of authentification? | I don't know. It should be written in docs... Anyway, try the next thing... Try to create a symlink for every db except for mysql. create a symlink /var/lib/mysql/db1 -> /mnt/onedis

[Stats] MySQL List: April 2004

-- Searchable archives for this list are available at -- ==

WHERE clause problem

This is my table: mysql> desc testing; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | date | date | YES | | NULL| | +---+--+--+-+-+---+ Here are the values:

innodb lock information

How can I go about getting information about lock information? I looked at the InnoDB status screen but it doesnt say a whole lot. Im getting alot of problems with lock wait timeouts. What I want to know is, what is obtaining the locks, what user is obtaining the locks and with what query/update/

Re: Problem

Sorry, it's an error - Original Message - From: mickael To: [EMAIL PROTECTED] Sent: Monday, May 03, 2004 4:07 PM Subject: Problem I have a problem with a character for example : in my databas i have a word like :" papier d'emballage" and if i try this request :

Problem

I have a problem with a character for example : in my databas i have a word like :" papier d'emballage" and if i try this request : $requete = "SELECT * FROM `produit` WHERE MATCH (nom) AGAINST ('emballage*' IN BOOLEAN MODE);"; --->it doesnt't work, because of this character :" ' " and ther

Re: Changing ibdata files on the fly

At 12:39 +0530 5/3/04, Sp.Raja wrote: Hi List, Is it possible to change data and log files (ibdata and iblogfiles copied for backup purpose) on the fly? No, you must shut down the server cleanly. Will something like this work?? 1. Close all client connections 2. Flush and disable further client

Re: problem (bug?) with LOCATE(substr,str,pos)

"Boris Mueller" <[EMAIL PROTECTED]> wrote: > > I need to do a LOCATE(substr,str,pos) request where pos must be taken from a > column. > for unknown reason (bug?) it does not work. > I made the following example to ilustrate the problem: > > select ERW, locate('xyz', A, 3000) as loc1, locate('xyz

Re: Integrating phpBB with an existing MySQL database

Hi Dave, > I thought one thing I could do is try and find the table that > stores phpBB's usernames and passwords, and extend those to include the > user data that I have already. But I know enough to know that it is > unlikely to be as simple as that. For example, I thought I read > somewhere tha

UTF-8 Collation

Hi, I recently tried MySQL 4.1.1-alpha in order to get proper UTF-8 support. I need to be able to order on a utf8 text field. Accented characters should (broadly) be treated as though they were not accented for ordering purposes. Many of the european charsets (eg German) seem to have special co

Re: date format problem

"Matt Tucker" <[EMAIL PROTECTED]> wrote: > I'm moving a JavaServlet app over from Tomcat on Win2K with a MS SQL 7 DB to Tomcat > on Red > Hat Linux with mySQL. Of course, there's about a hundred queries that use dates and > of > course, they're all in the format mm-dd-. is there a way to form

Re: SQL and Yahoo IM

yeah, isn't it cute! Cute enough to gag a maggot, maybe. You can turn that off, you know..click 'login', 'preferences', and open the 'Messages' menu. You will see a checkbox under 'misc' for 'Enable Emoticons'. Uncheck it, and it'll quit turning things like :) and * into silly graphics. ht

Integrating phpBB with an existing MySQL database

MySQL Listers, I already asked this question on phpBB's own forums, but no one seems inclined to answer me. I'm hoping there might be more charitable souls here on this list. My question is that I want use phpBB because I am satisfied with it's overall functionality and usability. H

Re: SQL and Yahoo IM

Shantanu Oak wrote: Hi, I am using phpMyAdmin for last several years. I don't like it's "framed" design. Recently I read that I can query the database using my Yahoo IM. http://www.duncanlamb.com/sdba/?Projects/SQL+Admin I wonder if this software really works. Has anyone tried it before? What type

Re: Freeing up connections

"Deepak Vishwanathan" <[EMAIL PROTECTED]> wrote: > If a user 'x' has exhausted all his connections, is there a way to free > up those connections. What command do I use for that? Do you mean that user exceeds max_connections value? http://dev.mysql.com/doc/mysql/en/User_resources.html If

Re: Accessing DBMS remotely: MySQL? FireBird?

Hi Fred, > > Some of our customers have remote offices. I was wondering if it'd be safe > to have a DBMS running at their central office, and have our client > application running on hosts in the branches connect to it through a VPN > via the Net? If the connection is reasonably stable, and you ca

SQL and Yahoo IM

Hi, I am using phpMyAdmin for last several years. I don't like it's "framed" design. Recently I read that I can query the database using my Yahoo IM. http://www.duncanlamb.com/sdba/?Projects/SQL+Admin I wonder if this software really works. Has anyone tried it before? What type of server will I nee

Probleme avec "WHERE MATCH ... AGAINST"

Bonjour, je ne sais pas si vous allez pouvoir me répondre mais j'ai un problème avec le "FULL TEXT". Comment faire pour ke la fonction de recherche des mots ne prennent pas en compte l'appostrophe? "MySQL utilise un filtre très simple pour séparer le texte en mots. Un "mot" est n'importe quell

Problems with maxdb odbc connection

Hallo ! Strange problem with maxdb odbc connections. I installed maxdb, databasemanager and sqlstudio on my local windows xp pc and did some testing. My application connects via system-dsn MAXDBLOKAL STORE SQLSTRINGCONNECT('dsn=maxdblokal;port=7210;uid=DBA;pwd=DBA;DATABASE=BWNE U') TO verbindung

Re: SQL SELECT HELP

Hi, Ok. This is good!! Thank you! Zoli Egor Egorov <[EMAIL PROTECTED]> 2004-04-30 03:30 PM To: [EMAIL PROTECTED] cc: (bcc: Zoltan Gyurasits/GYO/COMP/PHILIPS) Subject:Re: SQL SELECT HELP Classification: [EMAIL PROTECTED] wrot

Changing ibdata files on the fly

Hi List, Is it possible to change data and log files (ibdata and iblogfiles copied for backup purpose) on the fly? Will something like this work?? 1. Close all client connections 2. Flush and disable further client connections. 3. Copy ibdata and iblogfiles from backup dir 4. SIGHUP mysqld. Wha