MySQL ENCODE() question
Posted: Wed Jul 28, 2004 2:27 pm
I'm getting an error in my SQL syntax, can't figure out where it is... can anyone spot it?
insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode(administrator1,'tyler1'))
and I tried
insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode('administrator1','tyler1'))
and
insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode('tyler1','administrator1'))
and
insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode('tyler1',administrator1))
???
edited by : infolock
Moved to databases
insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode(administrator1,'tyler1'))
and I tried
insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode('administrator1','tyler1'))
and
insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode('tyler1','administrator1'))
and
insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`)
values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode('tyler1',administrator1))
???
edited by : infolock
Moved to databases