RE: optemizer for mySQL!

2006-05-14 Thread Jim
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

problem running mysql_install_db

2006-05-14 Thread don-temp28
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

Inserting ' into database

2006-05-14 Thread Peter Lauri
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 --