On Wed, May 9, 2007 04:06, Stephen Cook wrote:
> I think that offering some sort of feedback other than result sets would
> be nice for debugging.
And it makes perfect sence to get this debug information in
postscript format :D
>
> Peter Brawley wrote:
>> >I hope this isn't a silly question, or
Hi,
Hank wrote:
Hello All,
I have a 4.1.14 mysql database master and slave set up.
For this slave #1, I have the IO thread running constantly, and the SQL
thread running once a day to update all pending updates from the master
(then I shut it off). So for most of the day, this database is sta
I think that offering some sort of feedback other than result sets would
be nice for debugging.
Peter Brawley wrote:
>I hope this isn't a silly question, or something covered in a FAQ. . .
>but is there any reason to not have at least some primitive print
>formatting commands in MySQL? Or a
I am fairly newbie at MySQL in general, not to mention
MySQL on Windows which I've never used, but I'll trow
my 2 cents here.
Instead of installing a whole new set of files,
wouldn't that be easier just to start a 2nd instance
of the MySQL server using a different configuration
file? indicating a
At 6:09 PM -0400 5/8/07, John Kebbel wrote:
When I try using the --xml or --html option with a batch file using INTO
OUTFILE 'dirpath', the --xml or --html option seems to be ignored in
favor of the tab-delimited default. (If I get rid of the INTO OUTFILE,
xml or html displays fine in the termina
Hi John -
using --xml or --html as an argument and redirecting to a file seems to work
here. As in,
mysql -u me -psecret -D database --html -e "select * from that_table" >
~/test_file.html
HTH,
Dan
On 5/8/07, John Kebbel <[EMAIL PROTECTED]> wrote:
When I try using the --xml or --html opti
It should be possible to do a manual install from the non-installer
download. Moreover, it should also be possible to run 2 instances
on 2 different ip-adresses on one computer.
It's been a while sincei ran MySQL on Windows, so my memory is
not clear on this, but scan the docs, and your questions
When I try using the --xml or --html option with a batch file using INTO
OUTFILE 'dirpath', the --xml or --html option seems to be ignored in
favor of the tab-delimited default. (If I get rid of the INTO OUTFILE,
xml or html displays fine in the terminal.)
I tried using the pager to write to a fil
Dear friends,
thank you for your response.
but the problem is that when I try to install MySQL 5.0 from windows .msi
installer on windows XP with MySQL 5.0 already installed, the
installer does not shows any option regarding new installation. I can
just rapair/remove the installation. Why?
As I k
Hello All,
I have a 4.1.14 mysql database master and slave set up.
For this slave #1, I have the IO thread running constantly, and the SQL
thread running once a day to update all pending updates from the master
(then I shut it off). So for most of the day, this database is static
(except for th
>I hope this isn't a silly question, or something covered in a FAQ. . .
>but is there any reason to not have at least some primitive print
>formatting commands in MySQL? Or am I missing something
>blindingly obvious?
I think the idea is that RDBMS ought to stick to what is necessary for
RDBMS m
I hope this isn't a silly question, or something covered in a FAQ. .
.but is there any reason to not have at least some primitive print
formatting commands in MySQL? Or am I missing something blindingly obvious?
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
On Tue, May 8, 2007 14:58, sunisundar wrote:
>
> no getting an error now like " check the manual that corresponds to your
> mysql version."
> mine is mysql 5 version
And what does that error say?
Try quoteing [EMAIL PROTECTED] ala. 'poul'@'localhost'
>From the manual:
To create the account
Hello Paul,
Thank you for the fast answer.
I tried your method, but the result is the same.
What is very interesting, the same sql with just the same parameters works
perfectly OUTSIDE of the function (I mean in an Sql window).
So the same code works in sql window but not in the function.
Anoth
no getting an error now like " check the manual that corresponds to your
mysql version."
mine is mysql 5 version
Mogens Melander wrote:
>
> GRANT CREATE,INSERT,DELETE,UPDATE,SELECT PRIVILEGES ON pauldb.*
> TO [EMAIL PROTECTED] IDENTIFIED BY 'mysecretpassword';
>
> On Tue, May 8, 2007 13:5
Hi Zsolt,
The problem probably has something to do with an exception that is
not handled.
Try using a cursor (for example):
BEGIN
DECLARE done INT DEFAULT 0;
declare Akt_keszlet float(5,2) ;
DECLARE cur CURSOR FOR SELECT IFNULL(
(Select tr_aktualis_keszlet
From `termek_raktarhel
GRANT CREATE,INSERT,DELETE,UPDATE,SELECT PRIVILEGES ON pauldb.*
TO [EMAIL PROTECTED] IDENTIFIED BY 'mysecretpassword';
On Tue, May 8, 2007 13:57, sunisundar wrote:
>
> how to create new username n password in mysql using commands.
>
> followed these steps::
> mysql> create database pauldb;
> Query
Hello,
I have the following function in Mysql:
CREATE FUNCTION `GetTermekAktualisKeszlet`(termek_azon INTEGER(11),
raktar_azon INTEGER(11), hosszban_tarolt_termek CHAR)
RETURNS float(5,2)
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
Begin
Declare Akt_keszlet float(5,2) ;
SELECT IFNULL(
(
how to create new username n password in mysql using commands.
followed these steps::
mysql> create database pauldb;
Query OK, 1 row affected (0.00 sec)
#
# Now we create the user paul and give him full
# permissions on the new database
mysql> grant CREATE,INSERT,DELETE,UPDATE,SELECT on pauldb.
RELEASE is a reserved word, and if used as column-name, it
must be quoted (back-tick) `release` char(255) .
On Tue, May 8, 2007 12:09, Shahbaz Khan wrote:
> This is the exact error that mySQL reported:
>
> ERROR 1064 (42000): You have an error in you sql syntax; check the
> manual that corres
This is the exact error that mySQL reported:
ERROR 1064 (42000): You have an error in you sql syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'release char(255) bunary not null,
primary key (fileid,relea' at line 3
MySQL server versi
21 matches
Mail list logo
