Re: little bug
asong, Sunday, June 09, 2002, 5:16:00 PM, you wrote: a I change the max_connections to 200, and I am not sure it works, when I a use mysqladmin to check the variables, I find the value is still displayed a as 100, but trough checking the log file, I am sure the max_connections have a changed to 200, so, is it a bug of mysqladmin? How did you changed max_connections value? Did you started mysqld with -O (--set-variable) option or edited my.cnf file? If you edited my.cnf file have you restarted mysqld? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
little bug
Hello, I change the max_connections to 200, and I am not sure it works, when I use mysqladmin to check the variables, I find the value is still displayed as 100, but trough checking the log file, I am sure the max_connections have changed to 200, so, is it a bug of mysqladmin? BTW, Who can help me with the quota problem of every database or every user, thx. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: small little 'bug' in newest source version
Kedryna, Bartosz writes: In mysqldump.c there is // in 2 places, older compilers don't like it, changing to /* */ fixes the problem. Bart Kedryna Software Engineer Online Support [EMAIL PROTECTED] (215) 386 0100 x1470 ISI 3501 Market Street Philadelphia, PA 19104 Thank you, this has been duly noted and already fixed for the future version. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
small little 'bug' in newest source version
In mysqldump.c there is // in 2 places, older compilers don't like it, changing to /* */ fixes the problem. Bart Kedryna Software Engineer Online Support [EMAIL PROTECTED] (215) 386 0100 x1470 ISI 3501 Market Street Philadelphia, PA 19104 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a sort of little bug?
Hi, I work on the big web site of the gouvernative statistical agency of Italy (www.istat.it). Recently, I have built a db to collect data from the web (it's like a census simulation...) with mySQL. Making my querys,I had a little difficult, not so big for me, but that can interest you. On a developpement machine (winNT, apache, mysql 3.23.33) I wrote this query: "SELECT (fra_g+fra_p+sor_g+sor_p), count(*) FROM alunniE GROUP BY (fra_g+fra_p+sor_g+sor_p)", where fra_g, fra_p, sor_p, sor_g are, obviously, columns. That works right. When I tried to run the same query on the site machine (Unix Aix, apache, mysql 3.22.32, see http://www.istat.it:8080/index.php) i discovered that the use of the formula in the GROUP BY clause cannot work (any formula). The situation on the unix machine seems to be in contrast with the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT where it talks about the possibility to write a formula. Did you know it? Greetings Sergio Vaccaro -- Genial Brain Machine Via A. Camerini 50 00139 - Roma tel +39 6 87148219 +39 347 5056045 fax +39 6 87148219 (on demand) mail [EMAIL PROTECTED] icq genial 42632197
A little bug?
Hello, I have just had a little problem with a SELECT query like this: SELECT DATE_FORMAT(Day,"%e.%m.%Y") AS ftag,* from TheTable; this query returns an SQL error: ERROR 1064: You have an error in your SQL syntax near '* from TheTable' at line 1 BUT: SELECT *,DATE_FORMAT(Day,"%e.%m.%Y") AS ftag from TheTable; this query works. Is this a bug in the SQL implamentation of MySQL? Thanks Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php