SQL_CALC_FOUND_ROWS

4.0.18-standard-log Having some performance issues, and I can not see why: SELECT SQL_CALC_FOUND_ROWS l.id, u.b_first_name FROM logbook AS l LEFT JOIN users AS u ON l.user_id = u.id ORDER BY id DESC LIMIT 0, 20; 20 rows in set (1.21 sec) If I take out the SQL_CALC_FOUND_ROWS, of course, it is i

R: setup permission for stored procedure on mysql 5

I solve the problem, and I report it in case this should be usefull to someone else. Simply the manual reported a wrong sintax. To grant on privilege on a tored procedure or a function the command should be: mysql> grant execute on function test_function to '%'@localhost; mysql> grant execute on pr

Re: Database IDs

Gleb Paharenko wrote: > Really, in my opinion, it contradicts with the manual. Please, send me > the bug id in case you'll report the bug. It turns out that it was reported nearly a year ago: http://bugs.mysql.com/bug.php?id=6880 Björn Persson -- MySQL General Mailing List For list archives: htt

Re: Country codes

I'm not saying it was an inappropriate way to present the data but it certainly was unexpected and, in my opinion, counter-intuitive. I didn't want the original poster to see page 3, see that his own country, Brazil, was missing, and dismiss the PDF as garbage. Rhino P.S. Sorry for top-postin

Re: Country codes

Rhino wrote: > Be careful when reading those lists! When I looked at page 3 in the English > PDF, it said it was in numeric order and the list showed all the countries > that use country code 1, then country 20 (Egypt), then country 210 (spare) > *without* showing 55 (Brazil). Page 6 shows countrie

Re: case insensitive search

[EMAIL PROTECTED] wrote: > This is what I thought: I have three entries: > 12. afan, pasalic, afan_at_afan_dot_net, 2003-12-18 > 13. Afan, Pasalic, Pasalic_at_yaoo_dot_com, 2001-01-01 > 14. AFAN, PASALIC, ammtar_at_gamil_dot_com, 2003-12-18 > > If I search for *afan* only entry no. 12 will be shown

Re: character sets.....(missing info)

Hi all, there is no conversion done, and mysql will stil be happy to export utf8 (if asked to do so with a set names). So what is the role of the character set and collation at the database level?From what I understand the collation is used when you want to order results for example, case sen

Re: SSH tunnel for Mysql

Well, off the top of my head, to achieve a local-forwarding, you'd do something like: ssh [EMAIL PROTECTED] -L :localhost:3306 -N & Remember, "localhost" is resolved after the tunnel is established, so refers, actually, to the remote machine :) (The -N option simply obviates the need to pe

Re: Mysql 4.1 full table (nearly) - best practice to alter?

sheeri kritzer wrote: On 11/18/05, Michael Stassen <[EMAIL PROTECTED]> wrote: Sheeri, I think you've missed the point. The 4Gb limit is in mysql, not the filesystem. Mysql effectively doesn't limit tablesize, but the *default* pointer size limits you to a max of about 4Gb in a MyISAM table.

Re: SSH tunnel for Mysql

I use PuTTY (and WinSCP3) to attach my Windows machine to the Linux server holding my MySQL database. PuTTY is used to get the command line and WinSCP3 is the GUI I can use to do file transfers between the two machines. In PuTTY, there is a place where you can create SSH tunnels; it is located

Re: how to installing mysql5 on fc3?

ali asghar torabi parizy wrote: hi all i want to install mysql5 on fc3 but i cant when i trying to implement it by rpm. i remove mysql3 with rpm -e directive. So, now when you do: rpm -qa |grep -i mysql You see nothing, right? who cabn help me?:( thanks ***

Re: SSH tunnel for Mysql

Are you connecting from a Windows based machine? Are you using a graphical interface? I just helped a coworker do this with Navicat. You just set it up to log into the computer hosting mysql via ssh, this creates the tunnel. Then, you configure navicat to use localhost port 3306 to connect to

Re: using dinamic table name inside stored procedure

I'd really suggest looking at the data model that requies you to dynamically select which table to read from, and find another way. If there are several tables that have the same column that differ only by name, why not make the name a column? -Jason Martin On Sat, Nov 19, 2005 at 02:28:41PM +020

Re: Country codes

- Original Message - From: "bruno b b magalhães" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Sunday, November 20, 2005 10:15 AM Subject: Country codes Hi guys, I know it's a little bit off-topic, but does some one have a list with all countries of the world and their respective I

Re: case insensitive search

Sorry. :) This is what I thought: I have three entries: 12. afan, pasalic, afan_at_afan_dot_net, 2003-12-18 13. Afan, Pasalic, Pasalic_at_yaoo_dot_com, 2001-01-01 14. AFAN, PASALIC, ammtar_at_gamil_dot_com, 2003-12-18 If I search for *afan* only entry no. 12 will be shown. If I search for *Afan*

Country codes

Hi guys, I know it's a little bit off-topic, but does some one have a list with all countries of the world and their respective ISO codes (Like BRA, US, UK, etc.) and also their international calling codes (Like +55, +1, +32)? Thanks a lot, Bruno B B Magalhaes -- MySQL General Mailing Li

SSH tunnel for Mysql

How to create ssh tunnel for Mysql? TH

Re: How to list priviledges

Yes, see: http://dev.mysql.com/doc/refman/5.0/en/show-grants.html -Sheeri On 11/18/05, Jesse Castleberry <[EMAIL PROTECTED]> wrote: > Is there a way to list the privilidges that a user has in MySQL? > > Thanks, > Jesse > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.c

Re: Mysql 4.1 full table (nearly) - best practice to alter?

On 11/18/05, Michael Stassen <[EMAIL PROTECTED]> wrote: > Sheeri, > > I think you've missed the point. The 4Gb limit is in mysql, not the > filesystem. > Mysql effectively doesn't limit tablesize, but the *default* pointer size > limits you to a max of about 4Gb in a MyISAM table. To have a la

Re: Mysql Finding the country name from country prefix

Jasper Bryant-Greene wrote: > Michael's solution will not produce reliable results as it will return > at least two results for many different phone numbers, with no way to > tell which is the correct result. As long as the database contains Abhishek's bogus "XYZ" and "ZXF" records, yes. If the d

Re: "Function Does Not Exist"

Does it work if you use a standard command type, and use "call sp_InserNewCamper();" as the command string ? Pyt. On 11/18/05, Jesse Castleberry - [EMAIL PROTECTED]<+mysql+pyt+c1ac2e3ccd.JesseC#msdlg.com@ spamgourmet.com > wrote: > > I'm using the following code in my ASP