|mostr||hi everyone, I'm having a problem getting mysql to start. anyone able to give me a hand?|
what permissions should the .err file be?
|tomiN||Im trying to make a simple table (learning mysql) but I keep getting errors and Ive tried to understand them but had no luck.. please have a quick look if you can. Its only 5 rows :) http://pastie.caboo.se/59265|
|seocracy||can someone help me with trying to scrub a dirty word out of my database? I have over 9,000 records and I dont want to do it manually of course...so Im trying this:>> SELECT REPLACE(comments,'swearword','roses') FROM messageboard << I am using heidiSQL to do this all offline....it doesnt seem to be working....any ideas?!?|
I tried this SQL statement within phpmyadmin, but got error, how do I fix this: SELECT * FROM `phpbb_privmsgs`,`phpbb_privmsgs_text` WHERE `phpbb_privmsgs`.``privmsgs_id` = `phpbb_privmsgs_text`.`privmsgs_id`
|seocracy||no one seems to want to help|
|seekwill||mynullvoid: Read the error message|
seocracy: What is that supposed to do?
seocracy: Or, how is that not working?
|AVAKL||how can we verify if 2 fields are in the same row ?|
|seekwill||WHERE col1 = col2?|
LET THE QUESTIONS FLOW!
I just figured it out
update desktops set review = replace(review, 'CNET', '.');
update desktops set review = replace(review, 'http://reviews.cnet.com', '.');
|seocracy||but between us fellas.....I'm just now realizing that I jumped the gun on selling some of these databases...there are cnet urls all over some of them.....shhhhhhhhhhhhhhhhhhh|
got kicked off there...thanks for your help anyways versix :D
|tomiN||can someone please have a quick look at this and tell me why it give me an error? http://pastie.caboo.se/59265|
|mynullvoid||tomiN: what's the error|
|tomiN||my ERROR 1064 (42000): You h|
corresponds to your MySQL
PRIMARY KEY (ip)
) TYPE=MyISAM' at line 3
but thats the error
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds*
|tomiN||was that for me?|
|mynullvoid||please check, hope it help|
|tomiN||so there is no clear error? :)|
hehe I found the error
given_voucher(20) NOT NULL, I forgot varchar :)