Web client

Hi to all, I'm fed up with Access as a wysiwyg editor for mysql. Generaly, i'm fed up with client that i have to install on each comp. Actualy, i'm looking for an opensource wysiwyg web software. Something like the very good phpMyAdmin but with 'visual' request editor for simple users. If anyo

Re: ORDER BY DESC order different when using LIMIT

Martin Gillström wrote: I think it is. But I understand your point. But as you can see the key ImgId with value 1 is never returned when I use limit. The line SELECT ImgId,CreatedDate FROM dogge ORDER BY CreatedDate DESC LIMIT 2,1 return ImgId 4 And the line SELECT ImgId,CreatedDate FROM dogge O

UDF

Hi, Has anybody created UDF's in MySQL? Is there a way to create UDF without compiling MySQL with -with-ldflags=-rdynamic? Maybe they must be simple expresion based without using somewhat wrom mysqld (as said in documentation)? Thanks for advice, Arunas -- MySQL General Mailing Li

MySQL build from SOURCE

Hi, I've tried to compile MySQL 4.1 from src.rpm, but with no success. Can anybody help me to compile MySQL 4.1 from Source rpm? I tried to do everything as said in documentation. First I tried to compile it without making any changes to SPECS file. But Everytime it exists with erro

Re: secure automated access (was "Re: Backing up all databases")

Randall Perry wrote: Mysterious. I assume `mysql -p` prompts you for root's password and works as expected, since without -p it says you're not using a password, rather than saying there's something wrong with the password. Yes, that works. When you tried the defaults-file option, did you use t

Access denied error

I have recently installed MySQL my mac running OS X 10.3 and can connect to MySQL using the command: /Library/MySQL/bin/mysql However, once connected, I have tried to create a database and received the error message: ERROR 1044: Access denied for user: '@localhost' to database 'new_database' I

Re: ORDER BY DESC order different when using LIMIT

I think it is. But I understand your point. But as you can see the key ImgId with value 1 is never returned when I use limit. The line SELECT ImgId,CreatedDate FROM dogge ORDER BY CreatedDate DESC LIMIT 2,1 return ImgId 4 And the line SELECT ImgId,CreatedDate FROM dogge ORDER BY CreatedDate DESC

<    1   2