#mysql
04 October 2007
Total 23 pages. You are browsing page 5/23.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
04:34 <****> why would mysql restart check the debian user though?
04:35 <****> vluther: the init script for ubuntu/debian checks all the tables on every start using that user
04:35 <****> oh
04:35 <****> chadmaynard: ok i have restart everything seems to be fine in the syslog
04:35 <****> why?
04:35 <****> vluther: because it is retarded
04:36 <****> WooD: then you are fixed
04:36 <****> chadmaynard: o k i check that now!
04:36 <****> chadmaynard: ill be back in a min
04:36 <****> alright
04:36 <****> ok, just checking
04:37 <****> chadmaynard: WoW you are very a good man !! Do you have any website ?
04:37 <****> WooD: not an active one : )
04:37 <****> chadmaynard: you are the MAN in THE PLACE HERE !!
04:38 <****> WooD: that's what i keep telling everyone
04:38 <****> chadmaynard: really I appreciate your help ..
04:38 <****> no he's actually a tranny. seekwill is the man
04:38 <****> WooD: np
04:38 <****> haha
04:38 <****> chadmaynard: are you always here to help people ?
04:39 <****> WooD: I spend a good bit of time here
04:39 <****> cuz no one will hire him to do real work
04:39 <****> chadmaynard: why dont you get a job into that project 'Mysql' ?
04:39 <****> WooD: I'm a college student
04:40 <****> see
04:40 <****> hehe
04:40 <****> he's just a really smart college student
04:41 <****> just a nerd
04:41 <****> chadmaynard: what do you study at school ?
04:41 <****> poetry
04:41 <****> if I delete the last row in a table and I want the next row I add to use the next auto_increment based on whats in the row before it, not based on whats the actuall next is there a way to do that? say my pk_id is 6, I del row 6 and I add it again, it adds as 7, but I really want it to add back as 6? does that make sense?
04:41 <****> history, spanish
04:42 <****> cid2: 1. it makes sense but it's not what you want to do, but if you really want to do it.. don't use auto increment
04:42 <****> vluther: ok thanks. im sure there are good reasons why I dont want to do it so Ill just leave it at that.
04:42 <****> yep, they start with the word auto :)
04:43 <****> vluther: I want to do it less then I want to change everything upto this point to create its own id.
04:43 <****> thanks.
04:43 <****> WooD: electrical engineering and computer science
04:43 <****> chadmaynard: really thank you a lot !! you saved so much time ... I would been reinstall all the Ubuntu again because of that problem ... I don't know to much on repairing Mysql
04:44 <****> chadmaynard: WoW !! I see.... your gonna go far in your life ! Don't stop what you are doing !! Your really brilliant
04:44 <****> chadmaynard: I'M a french man .. sorry about my accent and the english
04:45 <****> I can't hear your accent.
04:45 * chadmaynard smiles
04:45 <****> if I have 2 values im inserting and only 2 fields in the table do I need to use VALUES ( 'foo' , 'bar' ) in my INSERT?
04:45 <****> chadmaynard: yeah lol
04:46 <****> chadmaynard: but probably you knew that it was not my primary language ?
04:46 <****> WooD: I wasn't sure. I expect mostly americans because of the time.
04:47 <****> and americans can't write usually
04:47 <****> hehe
04:47 <****> chadmaynard: ok i'm from Canada, Quebec....I work in computer all time here .. i'm a technician and a rep at the same time but I do not sell any linux yet
04:48 <****> vluther: where are you located?
04:48 <****> chad: san antonio, tx
04:48 <****> vluther: ahhh
04:48 <****> you?
04:48 <****> chadmaynard: you
04:48 <****> atlanta, ga
04:48 * chadmaynard messes with texas
04:49 <****> I'll have to go sleep ...
04:49 <****> bye
04:49 <****> see ya
04:49 <****> I really appreciate your help chadmaynard
04:50 <****> chadmaynard: this is so cool when you get help .
04:51 <****> i know
04:51 <****> chadmaynard: but a lot of people dont appreciate to much
04:52 <****> some people get angry when you help them
04:52 <****> WooD: you receive help, it is time to give it back when you can provide help as the appreciation
04:52 <****> chadmaynard: oh yeah ?
04:52 <****> is truncate the command that drops all the data and reset the auto_increment counters?
04:52 <****> kimseong: yeah I know but I'm so newbie on Mysql
04:53 <****> cld2: yes
04:53 <****> WooD: one day you will be good enough to help others, everyone starts as newbie
04:53 <****> kimseong: your right ! :)
04:53 <****> WooD: im about the biggest suck at mysql but everynow and then I can answer a stupid question
04:54 <****> chadmaynard: thanks. does truncate effect indexes? does it destroy the old one and let a new on be made? or does the old on exist?
04:54 <****> I'll try guys to hang it here for a while guys.. but I have a very busy life over here :S
04:54 <****> chadmaynard: lol
04:54 <****> sorry just switched back to irc
04:55 <****> after truncate, no more data, index will be empty too
04:55 <****> cld2: the index is truncated as well since the data is gone.
04:55 <****> thanks
04:55 <****> by the way is there any way to index a database to make it faster after 6 months of running ?
04:56 <****> optimize table ?
04:56 <****> kimseong: yes
04:57 <****> sorry guys .. i have to go ... my eyes are closing itself lol
04:58 <****> see you later and again THANKS SO MUCH chadmaynard !!!!
05:01 * vluther chuckles at the mini 'who's on first' dialogue
05:01 <****> If I have a column of type int and I did a "select (sum(column)/60) group by val", will it round because the type is int? Is there a way to make it convert to float?
05:02 <****> give it a floatie
05:02 <****> the division will make it a float
05:02 <****> it might not
05:02 <****> why not?
05:02 <****> would it help if I did /60.0
05:02 <****> that might convert to double
05:02 <****> or sum(float(column))/60
05:03 <****> double or float should be fine though, right?
05:03 <****> I just need it to not round to an int
05:04 <****> maybe not float/double since 60.0 is fixed decimal in mysql 5, 60e0 is float/double
05:04 <****> If I did put just 60... would it consider it an int and preserve column as an int?
06:01 <****> hi
06:02 <****> hola
Total 23 pages. You are browsing page 5/23.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last