Re: Using keys and left()

- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, September 23, 2004 5:27 PM Subject: Re: Using keys and left() "Alexander Newald" <[EMAIL PROTECTED]> wrote on 23/09/2004 15:57:51: Hello, I ha

Using keys and left()

c) mysql> select count(*) from test; +--+ | count(*) | +--+ |80352 | +--+ 1 row in set (0.00 sec) What can I do to get a better result for my query? Thanks, Alexander Newald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Get lines matching a select / group by query

- Original Message - From: "Wesley Furgiuele" <[EMAIL PROTECTED]> To: "Alexander Newald" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, September 21, 2004 1:41 AM Subject: Re: Get lines matching a select / group by query Use COUNT(): S

Get lines matching a select / group by query

(0.02 sec) But I like to simply get 3 As I use mySQL 3.x and can't change it for now I'm not able to use "FOUND_ROWS()" Thanks, Alexander Newald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Spamcease ?

Hello, currently I recive mails from [EMAIL PROTECTED] that say that I have to validate my email at Spamcease. Looking at the mail header mail seems to come from tgpnexus.com? Anybody else getting this type of emails? Alexander Newald -- MySQL General Mailing List For list archives: http

Re: Re[2]: nested sets - Perhaps a solution!

+ | min(node2.a) | min(node2.c) | min(node2.d) | +--+--+--+ |1 |1 |1 | +--+--+--+ Can someone have a look at it? Is it right? If it is right - how much cpu will this type of query cost if I have 1 userids? Thanks, Alexander Newald -- MySQL

Re: Re[2]: nested sets

e the rights to the users. But how to check if the rights of the "parent" user do not are lower? In the exmaple above how to get 0 for c and d for User2 (because User2 is a subuser of User1)? -- snip -- Look's like this is a really big problem!? Alexander Newald -- MySQL Gene

Re: Re[2]: nested sets

| 2 | 3 | 1 | 1 | 1 | +-+-++-+-++++ and using 1 or 0 for the a, c and d col would give the rights to the users. But how to check if the rights of the "parent" user do not are lower? In the exmaple above how to get 0 for c and d for User2 (becaus

nested sets

4 a -- User 5 a --- User 7a --- User 8a -- User 6 a - User 3 a c If I give back full rights to User 2 all should be like at the beginning Any help is welcome! Alexander Newald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: unstable mysql connection

s the right thing to do. Thanks for the idea with a vpn! Clients and server are not in the same room and even not in the same city. One more thing I like to know: Wy are mysql connection are so susceptibly to unstable lan connections? Simply downloading a large file finishes without stopping e

unstable mysql connection

rse the buggy lan) I will be happy! Thanks, Alexander Newald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

query: if exists UPDATE else INSERT?

Hello, I'm looking for a solution to write a sql query that inserts a set of data if the data id is not present and otherwise update the set. I have a table with id (char(8)) and value (int(8)) To make my problem clear: There is no set with id = "20030713" insert into table values ("20030713",

Difficult query

(for example 123.123.123.2) to 123.123.123.0 it can be left as 123.123.123.2 or even can be truncated to 123.123.123 The table is stored on a 3.23.43 mySQL Server. The table type is varchar(15) but this can be changed. Thanks, Alexander Newald

How to enable suffix for database dirs?

to users so if a user do "CREATE DATABASE alex" it will work? Thanks, Alexander Newald btw: - I can't use reiserfs - I use linux kernel 2.4.17 - I use IDE disks - I have a PIII 500 with 256 ram with more 50% f

Re: How to limit database size?

> Thanks for your answer. What happens if a user tries to add more data to a table after the files containing his database reached the hard disk quota limit. Does it make any diffrence which file (.frm .myi .myd) reaches the

How to limit database size?

Hello, I like to limit the size of a database (or if possible all databases of a mysql user) to some value. It should work like the disk quota for disk space. Thanks for any hints, Alexander Newald - Before posting, please