Thanks to Bernard, Sunmaia, and Ingo! I knew the query wasn't quite
right.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds to work for you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
=1
choice2=1
choice3=2
Does this make sense? The query I've written doesn't seem quite right.
Because of the AND following the LIKE "d" condition, it seems like all
the records will have to have choice2 equaling 2.
Some help clarifying this issue would be appre
e by typing shell> rpm -qa | grep -i my*. That'll give you the exact
names of all the mysql rpms installed on your system.
Check out http://www.linuxhomenetworking.com/linux-hn/rpm.htm for a
great tutorial on using rpm.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and p
54068 11836 ? S13:04 0:00
/usr/local/mysql/
So it would appear that the mysql daemon is running but now I can't
access the databases with the mysql client e.g., mysql -u root -p.
Help would be most graciously appreciated.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
vaniaPA
02098
^
To:
Id Title Address City
State Zip
1 Joe 1313 Mockingbird Lane TransylvaniaPA
02098
^^^
To my untrained eye it looks like the REPLACE, as you wrote it above,
searches the title field for anything e.g., &
quot;field data" to field data.
Here's my stab at the SQL:
UPDATE "02093_xdir_links"
SET title "*"
WHERE title REGEXP"["]*["]";
Will this work?. Is there a better way? Did I get it right? Normally
I'd just experiment but this
ord
id number. I'm a web designer not a programmer. I'm not at all sure how
to accomplish this task. Though I would like to learn.
Any help would be appreciated. Thanks.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds
I don't really know exactly what happened. As luck would have it, I had
a username with all privileges that WOULD connect. Using that, in
combination with shutting down and restarting MySQL, I reorganized the
user database and now things work. Thanks.
Bob Cohen
b.p.e.Creative
the GRANT tables. I know I must be missing
something basic. Help would be appreciated!
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds to work for you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
