Thanks Rob & Team,
Installer mysql-essential-5.0.45-win32 worked for me.
Rob Wultsch <[EMAIL PROTECTED]> wrote: On Dec 19, 2007 5:26 AM, Amit Nair
wrote:
> Hi Team
>
> Sorry for replying late,
>
> I have downloaded & tried installation with 3 installers. I am getting the
> below messsage whi
hi joe...
thanks, and what you provided works... but you changed the tbl def...
you're using an int, and you're passing the value to the tbl.
in my situation, i'm using an auto_increment, and i can't seem to use the
"create before..." as the auto_increment wouldn't be set prior to the
row b
create table foo
(aa varchar(20),
id integer,
cc varchar(20));
delimiter |
create trigger foo_ins before insert on foo
for each row
begin
set new.aa = concat(new.cc,'-',new.id);
end; |
delimiter ;
insert into foo (cc,id) values ('www',1);
select * from foo;
-Original Message
hi.
using mysql 5.0.27 and playing with triggers.
a simple db:
create table foo{
aa varchar (10),
bb int auto_increment,
cc varchar (10),
} innondb
i'm trying to figure out how to create a trigger, such that if the user does
an insert into foo (cc) value ("www");
the table will concat the ww
Hi Jerry!
The very last sentence on:
http://dev.mysql.com/doc/refman/5.0/en/delete.html
is "Currently, you cannot delete from a table and select from the same
table in a subquery."
But, to bypass that, you can create a temp table and join to that:
CREATE TEMPORARY TABLE to_delete
SELECT prod
Hy , i´ve done some search regarding your issue and i think you may
find this interesting :
http://forums.devshed.com/mysql-help-4/got-error-134-from-storage-engine-error-number-1030t-446448.html
http://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html
2007/12/19, Jerry Schw
What I want to accomplish is expressed best as
DELETE FROM prod_price
WHERE prod_price.prod_price_chg_flag = "O"
AND prod_price.prod_id IN
(SELECT prod_price.prod_id FROM prod_price
WHERE prod_price.prod_price_chg_flag = "X")
;
This is clear, concise, and completely illegal. I want to de
Alas, that is an issue you will have to take up with your local
network admin.. Depending on how they have the proxy implemented,
they might be able to put in the respositiry URL as exceptional and
allow it to pass through transparently.
- michael dykman
On Dec 18, 2007 9:53 PM, Xuekun Hu <[EMA
On Dec 19, 2007 5:26 AM, Amit Nair <[EMAIL PROTECTED]> wrote:
> Hi Team
>
> Sorry for replying late,
>
> I have downloaded & tried installation with 3 installers. I am getting the
> below messsage while trying the various installers.
>
> 1. mysql-essential-5.0.45-winx64 [28641KB] ==> This install
Hi Team
Sorry for replying late,
I have downloaded & tried installation with 3 installers. I am getting the
below messsage while trying the various installers.
1. mysql-essential-5.0.45-winx64 [28641KB] ==> This installation package is not
supported by this processor type. Contact your produc
10 matches
Mail list logo
