#mysql - Tue 24 Apr 2007 between 00:00 and 00:19

NY Lost Funds



actionToeBee looks at chadmaynard
ToeBeelooks at chadmaynard
actionchadmaynard looks around innocently
chadmaynardlooks around innocently
ToeBeenow silence. Heroes is back on
chadmaynardHeroes?
ToeBeeon teh teevee
emilylovequestion: if I have a record, and I back it up -- is there a way to import it back? I know about mysqldump and all that, but suppose my table has an autonum field. Is there a way to restore a record and make sure I get the same number for it?
majikmanis doing a select * from row where id = 1 or id =2 or id =3 or id =5 .... or id = 999 slower/faster than doing select * from row where id in (1, 2, 3, ...999)?
JoelSshould be the same majikman
majikmanok, thanks
JoelSthough you could benchmark it yourself
majikmanhow?
emilylovemajikman: couldn't you do a regex on that?
majikmanEmilyLove, on what?
the query?
emilylovemajikman: I'm terrible at regexes, but, yeah...from where where id=regex(<insert regex here>);
majikmanthat particular query could probably be optimized by just doing where id >=1 and id <= 999 but thats just an example and not the real situation
JoelSif he had the direct ids, regex = teh suck
emilyloveseems like it would be easier
oh I se
gnufiedToeBee, is it possible to add comments to a column using alter table statement?
emilyloveanyone any any ideas on my question?
gnufiedis it possible to add comments to a column using alter table statement?
emilylovequestion: if I have a record, and I back it up -- is there a way to import it back? I know about mysqldump and all that, but suppose my table has an autonum field. Is there a way to restore a record and make sure I get the same number for it?
AVAKL$sql = "INSERT INTO tbl_auth_user (user_id, user_password, email, name, phone) VALUES ('$username', PASSWORD('$password'), '$email', '$name', '$phone')";
what's my error
ToeBeeAVAKL: you tell us
emilyloveAVAKL: what language? php?
ferguscanCan anyone point me to a doc on indices? I'm interested to know the typical space usage of them, and their typical write-performance penalty.
AVAKLyes
ToeBeewhat is the error message?
AVAKLDuplicate entry '' for key 1
emilyloveu sure u don't have a duplicate entry for userid?
gnufiedlong live hacks.
ToeBeeone of your variables appears to not have a value
emilylove$sql = "INSERT INTO tbl_auth_user (user_id, user_password, email, name, phone) VALUES ('".$username."', PASSWORD('".$password."), '".$email."', '".$name."', '".$phone."')";
I normally seperate out my variables like that -- could make a difference.
obviously I have a typo next to $password there, where I forgot the close '
JoelSAVAKL, and uh, youre trying to use $username for a user_id field... is that correct?
AVAKLyes
JoelSThats some shitty naming then

Page: 2 9 16 23 30 37 44 51 58 65 72 79 

IrcArchive

NY Lost Funds