test - ignore

ignore

revoke all on *.* ??

dear all mysql 5.0.51a, very basic config thus I don't think could be of any relevance here there is a user with following grants: GRANT USAGE ON *.* TO 'ff'@'localhost' IDENTIFIED BY PASSWORD '077042fb4932b5b5' is it possible to: revoke all on *.* from $above_user OR revoke usage on *.*

Problems with simultaneous reads and writes to database

think about DROP TABLE/ALTER TABLE synchronisation? - Is there a different method to synchronise data between DBs that we could use? - Could upgrade of MySQL to 4.1.7 improve DB performance? Any kind of comments or suggestions are most welcome. Sincerely, Pawel Marzec -- MySQL General Mailing

Re: Haw to get specific result?

| 031214 2 | hub | 031215 3 | hub | 031217 4 | hub | 031218 - Original Message - From: Jay Blanchard [EMAIL PROTECTED] To: Pawel Filutowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, December 15, 2003 1:53 PM Subject: RE: Haw to get specific result? [snip] id

Re: Haw to get specific result?

I tried to insert this query: SELECT COUNT(DATE_FORMAT(dat,'%M')), DATE_FORMAT(dat,'%M') FROM table GROUP BY DATE_FORMAT(dat,'%M') order by dat but I`m not sure of proper result. Regards, Pawel - Original Message - From: Pawel Filutowski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

Haw to get specific result?

Hello, I have table like this: id | product 0 | switch 1 | switch 2 | hub 3 | hub 4 | hub 5 | wire 6 | wire 7 | wire 8 | wire 9 | wire . . I`m looking for query which give me result as array: 0 - count of 'switch' 1 - count of 'hub' 2 - count of 'wire' Haw to do it ?? Regards,

Re: Haw to get specific result?

Thanks for Joshua and Jay. The querys is that I expect. Best regards, Pawel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: set column's default to a function

columns, so only the first one would get updated when the record gets modified, but I didn't get a chance to try that. Any thoughts, comments ? Thanks in advance Pawel P.S. just to make the filter happy: database,sql,query

mysqld crashes on FreeBSD 4.2

Every several hours mysqld crashes and it seems to be correlated with heavy load. For example I can repeat the crashes with mysqldump. MySQL is 3.23.31 started with the following options: -O key_buffer=20M \ -O table_cache=512 \ -O sort_buffer=8M \ -O