Re: MySQL user privilages

Alright I have tried to do the grant like the following: GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; With no luck I keep getting an error

Sub-Select query

Dear all, I have the following query. When executed in MySQL I get an error on the first sub-select, and I can't find why: select slbc.stockcode, s.description, slp.qtyinstock, smax.pluqty, (slp.qtyinstock / smax.pluqty) from stocklevelbc slbc, stock s, stocklevel slp, stock smax,

Re: Sub-Select query

I have the following query. When executed in MySQL I get an error on the first sub-select, and I can't find why: http://www.mysql.com/doc/en/News-4.1.x.html You'll see that sub-select query will be in future 4.1.xx release ... David

Re: MySQL4 on Linux with Intel Hyperthreading CPUs?

Hi Group, I have a new dedicated mysql 4.0.5 server running redhat 8.0 that we are testing. The new server is a dual Intel Xeon 2.4GHZ with hyperthreading enabled, so Linux thinks there are 4 cpu's rather than the 2 real CPU's. I have a similar hardware running mysql 3.23.52 on linux. In

READ-COMMITTED does not behave as expected

If I use the transaction isolation level of READ-COMMITTED, I have the problems that I do not see changes to the table made within another connection (and commited) until I call commit in my connection.   As of my understanding this behaviour is correct for the REPEATABLE-READ and SERIALIZABLE

Re: MySQL3.23.52 with snort-1.9.0

Hi there , I am problems with snort logging to Mysql and I am wondering if this is a permissions problem . If any of you have worked on the snort IDS technology could you please help because I having severe difficulty with the product. The permissions I have given the User snort are GRANT

How to enter data in MySQLCC

Hi, I've installed MySQLCC as a client on Windows 2000, it connects via the net to a linux server running the mysql server and it's working ok to the point where I try to enter data into any cell of my tables other than one expecting a numerical value. I know MySQLCC is only in beta test mode

Inconsistent behavior when populating table?

Hi, I've written a Perl script to populate my MySQL table. It grabs values from my old database and uses the following for each to form a comma separated list of single quoted items... Each of the @values items is passed through: $value = $db-quote($original_value) first. $st =

pbm on install 3.23.54

Hi everyone... I have a problem, but maybe not related to mysql itself, for i have installed a RPM first, then deleted it, then tried the 4.0.5, then tried the 3.23.54, and still have the same problem... So here's the story Regarding the 3.23.54 install. I downloaded the source tar.gz... Put

locking issues

Hi All, I may be confused here but it would appear that when you issue a LOCK TABLES tbl_name { READ|WRITE }; You cannot read from another unlocked table in the same connection eg: mysql LOCK TABLES users read; Query OK, 0 rows affected (0.00 sec) mysql select * from Logger limit 1; ERROR

re: READ-COMMITTED does not behave as expected

On Thursday 12 December 2002 11:23, Horst Scheruga wrote: If I use the transaction isolation level of READ-COMMITTED, I have the problems that I do not see changes to the table made within another connection (and commited) until I call commit in my connection. As of my understanding this

re: Can't find file: './mysql/host.frm'

On Wednesday 11 December 2002 22:41, SLefevre at i-m-i-international dot com wrote: OK, I'm making progess on my MySQL problem. The log file says this: 021211 15:32:05 mysqld started 021211 15:32:05 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021211 15:32:05

re: Newbie - auto_increment multiple table insert help

On Thursday 12 December 2002 07:23, Max Clark wrote: I would like to run an insert query across two tables at the same time. The first table has a primary key that is auto_increment, the second table needs to insert the primary key from the first table as a reference? How do I auto-populate

re: Re: Mysql Hogging ram?

On Wednesday 11 December 2002 18:45, Benjamin Pflugmann wrote: These problems are causing me serious pain as whenever a large process starts my load avg jumps throught the roof. I run radius off of this database, and when the load jumps users fail to authenticate. Any help/sugestions with

add multiple records as a result from an if statement

Hi, I have a form with two sections on it. The user either completes one or both sections. (The validation is controlled by JavaScript) at the moment no matter how many sections they complete all the information is added to one record(through asp). But what I want to happen, is if the

Compiling 3.23.54-1

Hi ! I`m trying to compile 3.23.54-1 from src.rpm with error: ... + mv Docs/manual.ps.save Docs/manual.ps + automake aclocal.m4: 1272: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' aclocal.m4: 1273: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' aclocal.m4: 1379: `AM_PROG_INSTALL'

Field type conversion question

I need to create a table that will store employees that attended certain events. I have two tables set up for this purpose. One (EmpTable) stores employee demographic information. The other (Events) stores information about the events (date, time, location, etc.) In EmpTable, the employee

RE: MySQL4 on Linux with Intel Hyperthreading CPUs?

If the OS can use hyperthreading, fortunately, benchmarks are showing that there's no preformance hits because of overhead created trying to keep resource contention down. This is good! So if your system _can_ support hyperthreading, leaving it on won't hurt, if it doesn't improve your system's

porting MS SQL to mySQL

Hi all- I need to know what the mySQL equivalents are to the following MS SQL datatypes: nvarchar smallint bit int ntext real datetime float money smalldatetime numeric decimal Thanks for your help! Tom - Improve your reimbursement rate and lower your risk for audit. The MMI Coding Hotline

MySQL 3.23.54 is released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 3.23.54, a new version of the world's most popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites.

Re: The Manual on MySQL is not updated...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 11 Dec 2002, Dyego Souza do Carmo wrote: http://www.mysql.com/doc/en/Installing_source_tree.html In the manual , to compile a source tree only type: shell cd mysql-4.0 shell bk -r get -Sq shell aclocal; autoheader; autoconf;

Re: porting MS SQL to mySQL

Here's some info that might help: nvarchar = MS$ variable character string, up to 4000 characters, stored as UNICODE UCS-2. AFAIK, MySQL doesn't (yet) support UNICODE directly. However, M$ SQL often forces the nvarchar/ntext types on by default. So, if you don't need UNICODE, use varchar. If

Re: The Manual on MySQL is not updated...

Hi, About bk -r get -Sq, after a bk pull, is bk -r edit still needed or bk -r get -Sq could replace it ? Thanks and regards, Jocelyn - Original Message - From: Lenz Grimmer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 2:56 PM Subject: Re: The Manual on

MySQL/InnoDB-3.23.54 is released

Hi! InnoDB is a MySQL table type which provides transactions, row level locking, foreign key constraints, and a non-free hot backup tool. InnoDB is included in MySQL-Max-3.23.54 and all downloadable versions of MySQL-4.0. You can download a free GPL version of these from http://www.mysql.com.

Fwd: problem with replication

Any suggestion about this error? Thanks to all. --- Natale Babbo [EMAIL PROTECTED] ha scritto: Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET) Da: Natale Babbo [EMAIL PROTECTED] Oggetto: problem with replication A: [EMAIL PROTECTED] Hi all, I have a problem with replication between two

Re: Am I Violating Any Rules ?

In the last episode (Dec 12), Insanely Great said: Dan Nelson wrote: In the last episode (Dec 11), Karam Chand said: I want to statically link libmysql.dll with my closed source application, which I have not planned to distribute freely or commercial ? If you are not distributing

Re: MySQL4 on Linux with Intel Hyperthreading CPUs?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Keith Sauvant wrote: Hi Group, I have a new dedicated mysql 4.0.5 server running redhat 8.0 that we are testing. The new server is a dual Intel Xeon 2.4GHZ with hyperthreading enabled, so Linux thinks there are 4 cpu's rather than the 2

Re: READ-COMMITTED does not behave as expected

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Horst Scheruga wrote: If I use the transaction isolation level of READ-COMMITTED, I have the problems that I do not see changes to the table made within another connection (and commited) until I call commit in my connection. As of my understanding

RE: problem with replication

hi, try this : mysql SHOW MASTER STATUS; +--++--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--++--+- + | some-file| XX | | |

re: Re: MySQL user privilages

On Thursday 12 December 2002 10:03, Ryan McDougall wrote: Alright I have tried to do the grant like the following: GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@%

re: locking issues

On Thursday 12 December 2002 14:06, Greg_Cope at sandwich dot pfizer dot com wrote: I may be confused here but it would appear that when you issue a LOCK TABLES tbl_name { READ|WRITE }; You cannot read from another unlocked table in the same connection eg: mysql LOCK TABLES users read;

re: RE: RE: UPDATE

On Thursday 12 December 2002 03:32, Cesar Aracena wrote: Exaclty, 0 rows affected, but no password changed... why's that? Thanks, If 0 rows were affected it's normal that password was not changed :) If you do a SELECT with the same condition, does MySQL find the any matched rows? -- For

re: create table ... select ... w/ index

On Thursday 12 December 2002 05:52, Amittai Aviram wrote: When you copy a table using CREATE TABLE ... SELECT ..., the indexes do not get copied automatically. Is there a convenient way to transfer all indexes, other than looking them up with DESCRIBE or SHOW INDEX and then using either

re: Re: INNODB still not working Re: Does mysql support foreign keyon delete cascade and on update cascade?

On Thursday 12 December 2002 01:45, Jing Dai wrote: I tried on delete cascade, it didn't work either. First of all , if you create table as you described in your previous mail, foreign key will not be created. You can check it with SHOW TABLE STATUS. Why? Because you specify .. FOREIGN

RE: Select Where !=

So... Select n.uid, n.name from names_table n LEFT JOIN exclude ON n.uid = exclude.n_uid WHERE exclude.n_uid IS NULL; OK... this works, but I thought I would go a bit further... I have added a field in the exclude-table, cat_id. This shows which catalogue the names have been excluded from. I

RE: Select Where !=

So... Select n.uid, n.name from names_table n LEFT JOIN exclude ON n.uid = exclude.n_uid WHERE exclude.n_uid IS NULL; OK... this works, but I thought I would go a bit further... I have added a field in the exclude-table, cat_id. This shows which catalogue the names have been excluded from. I

Remote Connection, please help

I am using the official type 4 mysql driver from www.mysql.com but unable to make a remote connection with the mysql database running on our companie's remote server. I mailed some mailing mailing lists but didnt find out the right answer yet. I am using the following code for simple remote

More locking issues

Hi, I'm new to MySQL. I see you all talking about locking databases etc... but isn't that the point of having a database server? So you don't have to worry about record locks? I'm designing the backend for a popular site where a user's visit will result in multiple read/write operations on a

Load Data Infile command

HI all, I'm new to the list so I apologize if this subject has been answered already, I couldn't find a mailing list archive. We just upgraded (?) mysql to 3.23.49. We are running it on Linux Redhat 7.3 The load data local command is turned off by default. I have attempted to follow the

Re: Compiling 3.23.54-1

hi, i get the very same problem with: rh 6.2 2.4.17 glibc-2.1.3-28 the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. what could be the problem then? regards, tibyke GP I`m trying to compile 3.23.54-1 from src.rpm with error: GP

RE: Remote Connection, please help

I've never connected your way before. I'm using J/Connector from the MySQL site (http://www.mysql.com/downloads/api-jdbc-stable.html). That way I have no problems connecting. I do it this way: // connect to the database Class.forName(com.mysql.jdbc.Driver); Connection dbConnection =

Group by problem

Hi, The following sql operators caused to incorrect results: CREATE TEMPORARY TABLE temp_list ( CurrID char(42) NOT NULL, OriginalID char(42) NOT NULL , DocRevision int(16) unsigned NOT NULL ) TYPE=InnoDB; insert into temp_list select CurrID, OriginalID, max(DocRevision) from

Re: Remote Connection, please help

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Muhammad Salman wrote: I am using the official type 4 mysql driver from www.mysql.com but unable to make a remote connection with the mysql database running on our companie's remote server. I mailed some mailing mailing lists but didnt find out the

Re: Remote Connection, please help

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 first a note: this is a topic best discussed on [EMAIL PROTECTED] * On Thu, Dec 12, 2002 at 08:35:40AM -0800, Muhammad Salman wrote: I am using the official type 4 mysql driver from www.mysql.com but unable to make a remote connection with the

Re: More locking issues

Hi, If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Regards, Gelu _ G.NET SOFTWARE COMPANY

order results by count of searched expression

Hello mysql, I am trying to figure out sql command for ordering results descending by counts of searched expressions found in result. like this: $search=some; TEXT | COUNTS | - Something has..| 4| Some have..| 3| Some take..| 1|

Re: Compiling 3.23.54-1

tibyke wrote: the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. Did the mysql team change tools versions? automake/autoconf? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock

Re: Migration from Oracle

Dear Satish, Thank you for your help. Your welcome. I used MyODBC 3.51, and successfully migrated to MySQL. Is this a MySQL user stories case, or just a small migration? Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169

Re: Compiling 3.23.54-1

On Thu, 12 Dec 2002 13:15:05 -0500 Michael T. Babcock [EMAIL PROTECTED] wrote: MTB tibyke wrote: MTB MTB the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. MTB MTB MTB MTB Did the mysql team change tools versions?

Re: Remote Connection, please help

Subject: Remote Connection, please help I am using the official type 4 mysql driver from www.mysql.com but unable to make a remote connection with the mysql database running on our companie's remote server. I mailed some mailing mailing lists but didnt find out the right answer yet. I am using

combine data from two tables

Hi, I'm hoping that someone can give me some pointers on this problem. I have two tables that contain similar data (eg, people.employees and people.volunteers). I need to run a select statement to retrieve names from both tables, and then display the data sorted by name so that it doesn't

Re: More locking issues

Gelu Gogancea wrote: If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Can I ask if this is in fact accurate? As I understand it, MySQL does a

MySQL 3.23.54 safe_mysqld fix

The following code is incorrect in safe_mysqld on 3.23.54 at least (that is all I have checked) Line 162: if $NOHUP_NICENESS -gt 0 then $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup This needs to be: if test $NOHUP_NICENESS -gt 0 then NOHUP_NICENESS=nice

load data local infile

Hi: I am using mysql v4_0_5 both clinet and server. I cannot get load data local infile to work after many different tries. Does anyone make it work with this version? It worked for when I used v3.23.52. Thanks for any tips, Yuyi

Re: Compiling 3.23.54-1

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael T. Babcock wrote: tibyke wrote: the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. Did the mysql team change tools versions? automake/autoconf? Yes. You need automake

Query from5tables

Hi I want to get data from 5 tables to a form..the tables are linked in the following way. AppointmentTable 1 to 1 client ClientTable one to many ClientStaffTable SaleStaffTable one to many ClientTable AttendantsTable many to one AppointmentTable AttendantsTable one to one ClientStaffTable And

Re: More locking issues

Hi, Is not the same caseJeff didn't said anything about TRANSACTIONS. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message

Collective Row Concatenation

Hi, I am having a bit of a problem with my MySQL database, and I am hoping someone can help me out. I have a table, that currently contains 350 million rows, all of which basically contain a String (VARCHAR) of size 60 characters or less, and a bunch of other identifiers. These 350

RE: problem with replication

Hi ... i have just tried by nothing's changed! ... i mean ... now in the show slave status i can see the right master_log_filename, log_position etc. but the error persists! What's wrong? help me please! Thanks and bye --- Maxime LEMAIRE [EMAIL PROTECTED] ha scritto: hi, try this : mysql

Re: Remote Connection, please help

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Muhammad Salman wrote: Dear Mark, real thanks , Are you refering to this issues: Issue: When I try to connect to the database with MySQL Connector/J , I get the following exception: Yes. [snip] Thanks Mark for your real quick response.

Re: Load Data Infile command

Try this when your logging into mysql, not when starting mysql. This works for me on Linux. mysql --local-infile=1 -u username-p - Original Message - From: Jon Bertsch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 12:02 PM Subject: Load Data Infile command

Sorting Results

Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet

Re: Sorting Results

Cancel this! :) after reading it again, I realized a simple ORDER BY will do the trick nicely... Happy Holidays, Mike(mickako)Blezien wrote: Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like

RE: Sorting Results

ORDER BY field ASC|DESC --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Mike(mickako)Blezien [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:45 AM To: MySQL List Subject: Sorting Results Hello all, Is there away, within the sql

newbie - linking queries with dynamic where conditions

Hi- I am trying to write a sql query that will output (domain, transport, sum(count), sum(size)) from multiple tables for many records. When the domain field is dynamic based on the adminId passed to the query, how do I execute the second query at the same time? Thanks in advance, Max select

Re: Load Data Infile command

I'm new to the list so I apologize if this subject has been answered already, I couldn't find a mailing list archive. Where did you look? http://www.mysql.com/documentation/searchlists.html PB - Before posting, please

Re: Sorting Results

Mike(mickako)Blezien wrote: Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. Well... you mean other than ... ORDER BY 'fieldname' ?? - Csongor

Problem compiling MySQL-3.23.54 on OpenUNIX 8.0.0

I can not compile the release of MySQL-3.23.54. Below is the errors. make[4]: Entering directory `/home/build/ou8/mysql-3.23.54/sql' source='mysqld.cc' object='mysqld.o' libtool=no \ depfile='.deps/mysqld.Po' tmpdepfile='.deps/mysqld.TPo' \ depmode=none /bin/bash ../depcomp \ CC -Kthread

Re: More locking issues

From MySQL Reference Manual: ... Normally, you don't have to lock tables, as all single UPDATE statements are atomic; no other thread can interfere with any other currently executing SQL statement. There are a few cases when you would like to lock tables anyway: * If you are going to run many

Re: Field type conversion question

On Thu, 12 Dec 2002 08:59:45 -0500, Brad Harriger wrote: like to have a field in Events that will store multiple names with both fields from EmpTable concatenated into one string (i.e. FirstName LastName) What is the most efficient way to do this in MySQL? One approach is an

insert record x 2

Hi, I have a form with two sections on it. The user either completes one or both sections. (The validation is controlled by JavaScript) at the moment no matter how many sections they complete all the information is added to one record(through asp). But what I want to happen, is if

boolean type

Does there exist a boolean column type? I checked the documentation, and it says that there exists a BOOL but it is a tinyint(1). Should I use that as a boolean? thanks in advance, prashant. query to go through filter. - Before

RE: Sorting Results

ORDER BY col [ASC|DESC] http://www.mysql.com/doc/en/SELECT.html -Original Message- From: Mike(mickako)Blezien [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:45 AM To: MySQL List Subject: Sorting Results Hello all, Is there away, within the sql query, to sort the query

Re: Compiling 3.23.54-1 - new tools installed !

Hello, Yes. You need automake 1.5 / libtool 1.4. It appears this made it into the CHANGES for the 4.0.x series, but not the 3.23.x series. I'm BCC'ing this to our build engineer, so he can correct the manual. Thanks! -Mark well, [root@kula-szpiegula /root]# libtool --version

Re: Can't find hosts.frm -- permissions now okay?

I had a similar experience right down to the error message you are getting. Based on that experience, I am inclined to recommend the following: 1) Abandon your current installation which I perceive that your are attempting from a MySQL tarball. 2) Download the webmin-1.030 tarball and execute

Re: Can't find hosts.frm -- permissions now okay?

Lefevre, Steven wrote: I'm still getting the error 'Can't find hosts.frm' when I try to laund the mysql daemon. I've run the mysql_install_db script several times. I've changed the user and group ownership for all the files in the /usr/libexec/mysql directory, and also in /var/lib/mysql to

Sorting UK Postcodes (WAS Sorting Results)

Hi, What about if you want to sort UK Postcodes ? They can be E1,E2,..,E12,E13 Order by name would do: E1,E10,E11,E12,E13,E2,E3,E4,... how can I get with a simple ORDER BY query E1,E2,E3,E4,E5,... ? Cheers, Damien COLA - Before

Re: Group by problem

Dmitry, - Original Message - From: Dmitry Kosoy [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, December 12, 2002 8:02 PM Subject: Group by problem Hi, The following sql operators caused to incorrect results: CREATE TEMPORARY TABLE temp_list ( CurrID

Re: Compiling 3.23.54-1 - new tools installed !

Hi, You should downgrade automake to 1.5 and if it still doesn't work, try with autoconf 2.52. Regards, Jocelyn - Original Message - From: gnu_is_not_unix [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 8:52 PM Subject: Re: Compiling 3.23.54-1 - new tools

Re: newbie - linking queries with dynamic where conditions

So I am trying to accomplish something like this: select a.domain, a.transport, sum(c.recipient_count) sum(c.recipient_size) from transport as a, acl as b, recipientstats as c where a.id=b.transportId and b.adminId='1' and c.recipient_email like '%a.domain'; But I know I am missing something

Re: Can't find hosts.frm -- *directory* permissions now okay?

mysql still doesn't own the mysql directory. OK, I changed that for /usr/libexec [root@server /]# ls -la /usr/libexec/ total 4008 drwxr-xr-x7 root root 4096 Dec 11 15:28 . drwxr-xr-x 16 root root 4096 Nov 27 09:32 .. ... drwxr-xr-x3 mysqlmysql

Re: Mail Abuse

Dear Alistair, dear list, someone with your e-mail address is trying to unsubscribe me from a mailing list. Please make sure this abuse will stop. thanks for the note, I tried to unsubscribe myself earlier today but how that got turned into unsubscribing you beats me, anyway apologies for

Re[2]: Compiling 3.23.54-1

Hello, Yes. You need automake 1.5 / libtool 1.4. It appears this made it into the CHANGES for the 4.0.x series, but not the 3.23.x series. I'm BCC'ing this to our build engineer, so he can correct the manual. Thanks! -Mark well, [root@kula-szpiegula /root]# libtool --version

RE: Sorting UK Postcodes (WAS Sorting Results)

Sorry, I forgot to say that postcode can be one or 2 letters in front of the numbers. -Message d'origine- They can be E1,E2,..,E12,E13 Order by name would do: E1,E10,E11,E12,E13,E2,E3,E4,... how can I get with a simple ORDER BY query E1,E2,E3,E4,E5,... ?

Re: New database doesn't show up in phpMyAdmin

This is a problem I had before with phpMyAdmin... Try closing your browser, flush all cachefiles in the browser and log on to your database again. If this helps, I can help you with a cure for this problem. If it doesn't help, you probably have no permissions reading your database via phpMyAdmin.

Re: Sorting UK Postcodes (WAS Sorting Results)

Damien -- What about: select substring(code, 1, 1) as letter, substring(code, 2, 2) + 0 as number from epost order by 2 +++ | letter | number | +++ | E | 1 | | E | 2 | | E | 3 | | E | 4 | | E | 10 | | E

RE: Sorting UK Postcodes (WAS Sorting Results)

Hi, Could you seperate the letters into one column and the numbers in another... Then you could group by the Alphabetical column, and order by the numerical column... Regards, Chris Stark -Original Message- From: Alliax [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 4:53

mysql-max-3.23.54-pc-linux-i686 doesn't work!

I downloaded the new binary version (3.23.54) mysql-max from the website but the safe_mysqld seems buggy .. Moreover when I try to start it up i got these errors: /usr/local/mysql-max-3.23.54-pc-linux-i686/bin/mysqld: /lib/libpthread.so.0: version `GLIBC_2.2' not found (required by

Re: Compiling 3.23.54-1 - new tools installed !

On Thu, 12 Dec 2002 21:29:40 - Jocelyn Fournier [EMAIL PROTECTED] wrote: JF Hi, JF JF You should downgrade automake to 1.5 and if it still doesn't work, try with JF autoconf 2.52. JF JF Regards, JF Jocelyn hi, MySQL folks! :) it works for me with (redhat 6.2):: -

Re: Mail Abuse

On 12 Dec 2002, at 22:42, Stefan Hinz wrote: Has anyone observed something like this before? I keep getting unsubscribe mails from the list (at least five times this month only). The reason it happened is that you've posted several messages in which you've quoted the unsubscribe text that the

Re: Compiling 3.23.54-1

On Thu, 12 Dec 2002 13:15:05 -0500 Michael T. Babcock [EMAIL PROTECTED] wrote: MTB tibyke wrote: MTB MTB the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. MTB MTB MTB MTB Did the mysql team change tools versions?

RE: Sorting UK Postcodes (WAS Sorting Results)

At 22:53 12/12/2002 +0100, Alliax wrote: Sorry, I forgot to say that postcode can be one or 2 letters in front of the numbers. -Message d'origine- They can be E1,E2,..,E12,E13 Order by name would do: E1,E10,E11,E12,E13,E2,E3,E4,... how can I get with a simple ORDER BY query

Re: MySQL 3.23.54 safe_mysqld fix

what an important piece of information, thanks, Nick! tibyke On Thu, 12 Dec 2002 12:46:10 -0600 Nick [EMAIL PROTECTED] wrote: N The following code is incorrect in safe_mysqld on 3.23.54 at least (that N is all I have checked) N N Line 162: N if $NOHUP_NICENESS -gt 0 N then N

RE: Sorting UK Postcodes (WAS Sorting Results)

Thank you and Yes, separating the postcodes into field letters and numbers may be the only way to be able to order a sequence like that: CV1,CV2,..,CV10,.. It would also work since there could as many letters as needed Anyone has a simple query for odering sequences correctly ? Cheers, Damien

RE: Collective Row Concatenation

Hi, I'm pretty sure that's not possible in MySQL - sounds like the kind of thing that would be way easier to write a bit of script for instead. picky I don't think you'll get away with using 'order' as a column name either - I'm fairly sure it's a reserved name in MySQL. /picky Cheers, Andrew

RE: Sorting UK Postcodes (WAS Sorting Results)

Hi, yes, that would do, except that I don't know how many letters are in front of the numbers. And since they're not the same letters perhaps ORDER by 1,2 would have done it perfectly, if only we could substring() intelligently first. Cheers, Damien COLA -Message d'origine- SQL:

RE: Sorting UK Postcodes (WAS Sorting Results)

Sorting by number is not important, it was more a general question about sequences of variousnameXXX and how to order them correctly with a simple query. Splitting in 2 fields seems the only way then. For the postcode it's just to provide the user with an easy lookup table, but it's not *that*

RE: newbie - linking queries with dynamic where conditions

You´re missing the GROUP BY clause select a.domain, a.transport, sum(c.recipient_count) sum(c.recipient_size) from transport as a, acl as b, recipientstats as c where a.id=b.transportId and b.adminId='1' and c.recipient_email like '%a.domain' GROUP BY a.domain,a.transport; -Original

BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?

The way I've always done it, and I wonder if I am not doing lots of things wrong: i have 2 tables, one person and one address for a one to one relation, the way I do it: table person personID primary int 11 autoincrement addressID int 11 table address addressID primary int 11 autoincrement if

3.23.54 compile error

I've tried to build mysql-3.23.54 from rpm sources. My system is a RedHat 6.2 with glibc-2.1.3-28 and the compiler is gcc-2.95.4-4h. Had no problems at all building mysql until mysql-3.23.53, but now I get this error: [...] Making distclean in . make[1]: Entering directory

  1   2   >