From: Reindl Harald
Date: July 10 2011 9:12am
Subject: Re: Mysql Trigger
List-Archive: http://lists.mysql.com/mysql/225350
Message-Id: <4E196D12.7040900@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig722FF9439A70AC9C6B6E3D0D"

--------------enig722FF9439A70AC9C6B6E3D0D
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 10.07.2011 10:32, schrieb vishesh kumar:
> Hi Members
>=20
> Whats wrong i am doing in following create trigger statement
>=20
>   Create trigger test before insert on user
>    for each row
>    begin
>       set New.host=3Dupper(new.host)
>    end
>=20
> Above statement giving error check sql syntax , please  guide me. I wan=
t to
> put host field value in uppercase in user table

a) why "before insert"
b) why "for each row" when a single update can do this
c) update table_name set fieldname=3Dupper(fieldname)


--------------enig722FF9439A70AC9C6B6E3D0D
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk4ZbRIACgkQhmBjz394Anm08ACfWB0vu2ZpS9SrjS5qkgHgIZRs
2nsAnjt099RAsfEklVQ6Bjx2SAdqsbti
=/WZ+
-----END PGP SIGNATURE-----

--------------enig722FF9439A70AC9C6B6E3D0D--