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 http://spamgourmet.com wrote:
I'm using the following code in my ASP.NET
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
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 larger
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.com/mysql
How to create ssh tunnel for Mysql?
TH
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
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*
- Original Message -
From: bruno b b magalhães [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
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
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
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
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
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
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.
Well, off the top of my head, to achieve a local-forwarding, you'd do
something like:
ssh [EMAIL PROTECTED] -L arbitrary high port no:localhost:3306 -N
Remember, localhost is resolved after the tunnel is established, so
refers, actually, to the remote machine :) (The -N option simply
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
[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.
If
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 countries
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
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:
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
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
21 matches
Mail list logo
