As a word of advice, before posting to any list, please RTFM (Read The Fine
Manual).
You have to escape all "special characters", like apostrophes and single
quotes, with the backslash.
INSERT INTO thetable (name) VALUES ('O\'Connell');
http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html
This is my first trigger I'm trying to write.
I have two tables. 'stores' and 'zipcodes'.
I want to automatically set the latitude and longitude of the store using
it's zipcode lookup in the zipcode table.
DELIMITER $$;
DROP TRIGGER `store_coord`$$
create trigger `store_coord` BEFORE INSERT o
Hi all,
Assume that I want to insert "Juanita O'Connell" into my database. How do I
do that? The problem is the ' in her last name. If I just put it in it will
be
INSERT INTO thetable (name) VALUES ('O'Connell');
And that does not work :) How can I solve this?
Best regards,
Peter Lauri
--
My
I start from an up-to-date fedora core 4 (except that I've not
rebooted lately, so I have newer kernels than I'm now running).
This includes
mysql-4.1.16-1.FC4.1.i386.rpm
mysql-devel-4.1.16-1.FC4.1.i386.rpm
mysql-server-4.1.16-1.FC4.1.i386.rpm
mysqlclient10-3.23.58-6.i386.rpm
I'm trying to follow
Thanks Sheeri,
How do you run the profiler and what does it do?
Have recently had to add some indexes to various tables to improve
performance so does not seen to be running automatically.
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Saturday, 13 May 2006 2:
