Using keys and left()

(*) | +--+ |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: 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 have a db with abount 8 lines in it. I now

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(): SELECT COUNT( id ) FROM test WHERE LEFT( id, 5

Get lines matching a select / group by query

) 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

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: Re[2]: nested sets

| +-+-++-+-++++ 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 (because User2 is a subuser of User1)? Alexander Newald -- MySQL

Re: Re[2]: nested sets

. 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 General Mailing List For list archives: http

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

|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 General Mailing List For list archives: http

Re: unstable mysql connection

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 even with 5% or more paket loss. Alexander Newald hth Dan - Original Message - From

query: if exists UPDATE else INSERT?

;-) Its no solution to simply make the table accept duplicate entries for id and make a sum(value) group by id because I think it will be a performace problem if I have thousends of datasets a day - If I'm wrong let me know. Any hints how to manage this?? Alexander Newald

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?

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% free - I use mySQL 3.23.43

Re: How to limit database size?

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 disk quota limit ? Alexander Newald - Before

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