#mysql - Sun 6 May 2007 between 00:08 and 00:56

NY Lost Funds



mostrhi everyone, I'm having a problem getting mysql to start. anyone able to give me a hand?
what permissions should the .err file be?
tomiNIm 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
seocracycan 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?!?
mynullvoidhi all
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`
seocracyno one seems to want to help
seekwillmynullvoid: Read the error message
seocracy: What is that supposed to do?
seocracy: Or, how is that not working?
AVAKLhow can we verify if 2 fields are in the same row ?
seekwillWHERE col1 = col2?
LET THE QUESTIONS FLOW!
seocracysorry dude
I just figured it out
update desktops set review = replace(review, 'CNET', '.');
update desktops set review = replace(review, 'http://reviews.cnet.com', '.');
seekwill:)
seocracybut 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
seekwillhuh?
seocracyoh nothing...nothing
lol
got kicked off there...thanks for your help anyways versix :D
tomiNcan someone please have a quick look at this and tell me why it give me an error? http://pastie.caboo.se/59265
mynullvoidtomiN: what's the error
tomiNmy ERROR 1064 (42000): You h
corresponds to your MySQL
NOT NULL,
PRIMARY KEY (ip)
) TYPE=MyISAM' at line 3
opps sorry
but thats the error
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds*
mynullvoidhttp://sql-info.de/mysql/gotchas.html
tomiNwas that for me?
mynullvoidplease check, hope it help
tomiNso there is no clear error? :)
thanks anyway
hehe I found the error
given_voucher(20) NOT NULL, I forgot varchar :)

Page: 2 9 16 23 30 37 

IrcArchive

NY Lost Funds