> DECLARE divide_by_zero CONDITION FOR SQLSTATE '22012';
> IF divisor = 0 THEN
> SIGNAL divide_by_zero;
> END IF;
> END
>
> Methinks someone forgot to include this feature in the release!
>
>
> -Original Message-
> From: Alex Katebi [mailto:alex.
l Message-
From: Alex Katebi [mailto:alex.kat...@gmail.com]
Sent: Wednesday, May 20, 2009 10:58 AM
To: mysql
Subject: SOS mysql signal syntax error
Hi Folks,
I am getting syntax error with the mysql signal. I have a trigger
that needs a signal for raising an error condition if a row with
s
Hi Folks,
I am getting syntax error with the mysql signal. I have a trigger
that needs a signal for raising an error condition if a row with
specific value is removed.
CREATE TRIGGER my_trig BEFORE DELETE ON my_tbl
FOR EACH ROW BEGIN
DECLARE mysig CONDITION FOR SQLSTATE '45000';
Did you try :
mysql -u root -h localhost (Without the -p)
Root is passwordless after installation unless you changed it.
On Tuesday 29 August 2006 11:28, 李彦 wrote:
> Dear Sir:
> I have some problems with mysql 5.0 binary source in Linux(RedHat).I'm
> able to startup the mysql process. But w
ns because, while one can type either "-u root" or "-uroot" in case
of password it must be "-pyourpwd" no spaces between the switch "-p" and your
password.
Regards,
Mikhail Berman
-Original Message-
From: 李彦 [mailto:[EMAIL PROTECTED]
Sent: Tuesd
李彦 wrote:
Dear Sir:
I have some problems with mysql 5.0 binary source in Linux(RedHat).I'm
able to startup the mysql process.
But when i type in :mysql -u root -h localhost -p, and then put the
correct password, I can not enter the database.
I took almost one week to dea
Dear Sir:
I have some problems with mysql 5.0 binary source in Linux(RedHat).I'm
able to startup the mysql process.
But when i type in :mysql -u root -h localhost -p, and then put the
correct password, I can not enter the database.
I took almost one week to deal with this
Hi,
I am using MySQL 3.23.41 and JDBC to support some servers. When I stress the servers I
get several errors like
java.sql.SQLException: General error: Table testtab was not locked with LOCK TABLES
I get this error on some of the insert attempts, and on half of the update attempts.
I also tr
Hello again !
Sorry I made some mistakes.
The the wrong command was - DELETE FROM user WHERE Host LIKE "%";
and got this:
mysql> select * from user;
Empty set (0.00 sec)
Can I recover the user table in such a situation ???
Thanks agin.
> It seems that with a wrong command:
>
> mysql> delet
> I would like to unsubscribe of this list!!! Help me please !
>
> My address : [EMAIL PROTECTED]
>
> --
> Alain Siani
> (query,mysql)
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>
did you read the bottom of your own eMail? there's a link to unsubscribe appended
to every mail on this list!
-kg
alain siani wrote:
> I would like to unsubscribe of this list!!! Help me please !
>
> My address : [EMAIL PROTECTED]
>
> --
> Alain Siani
> (query,mysql)
>
> --
I would like to unsubscribe of this list!!! Help me please !
My address : [EMAIL PROTECTED]
--
Alain Siani
(query,mysql)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
12 matches
Mail list logo