Hello,
If you use "printf" or some similar function inside a UDF function,
where does the output goes? Or, how can I make such an output go somewhere?
Thanks,
Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PR
I need to create a cursor using dynamic sql. Below is a short example of
what I am trying to use in order to get the correct resultset... ignore
the rest of the proc, I just need to know how to make the cursor
declaration from @vsql
Thanks
DELIMITER $$
DROP PROCEDURE IF EXISTS `firescope`.`trigg
In this case, the command for the second suggestion is
gzip -d < slavesetup.sql.gz | mysql -u --password=
-Original Message-
From: Eramo, Mark [mailto:[EMAIL PROTECTED]
Sent: Monday, May 05, 2008 3:40 PM
To: Mysql
Cc: Kieran Kelleher
Subject: RE: Import of a mysldump file fails
Hi Kier
Hi Kieran,
Try the following 2 things...
1) Add this to your my.cnf / my.ini in the [mysqld] section
max_allowed_packet=32M
(you might have to set this value higher based on your existing database).
2) If the import still does not work, try it like this as well.
mysql -u --password=
Hi,
I have a weird one going on here. I have done this many times before
with MySQL 4.1, but now that I am trying to accomplish same task with
a MySQL 5.0.x setup, mysql is just not succeeding in importing the
mysqldump file.
I am doing a full mysql dump from a mysql master running 5.0.51
Hi!
SQL Maestro Group announces the release of Data Wizard for MySQL 8.4, a
powerful Windows GUI solution for MySQL data management.
Data Wizard for MySQL provides you with a number of easy-to-use wizards to
generate PHP and ASP.NET scripts for the selected tables, views and queries,
convert
If you are getting more results, I would guess that your users table
is not a list of unique users, but a list of user logins. If that is
the case, then it's your LEFT JOIN and the count(*) that is causing
you to get more results.
If a user logs in 5 times, but only has 1 post, you will get 5 recor
