#mysql
11 October 2007
Total 31 pages. You are browsing page 31/31.
First :: Prev :: [...] [27] [28] [29] [30] [31] :: Next :: Last
23:50 <****> i work for nationalnet
23:50 <****> I work for mhillyer
23:50 <****> work downtown
23:50 <****> live in decatur
23:50 <****> now we know your entire life story!
23:50 <****> well unincorporated dekalb
23:50 <****> it goes on alot longer
23:51 <****> and why the heck is everyone hacking me? no phpinfo tricks and NO machetes!
23:51 <****> chadmaynard: I hear you're about to be without water :
23:51 <****> Everyone works for mhillyer seekwill, you just figured it out is all.
23:51 <****> ToeBee: that's what they say
23:51 <****> where?
23:51 <****> no water?
23:51 <****> ToeBee: i hear it's winmutt's fault
23:51 <****> winmutt: like all of Ga
23:51 <****> i am just getting started with mysql and would like to know when I should use an index and when I shouldnt (I know what an index is).
23:52 <****> !man how mysql uses indexes
23:52 <****> (How MySQL Uses Indexes) : http://dev.mysql.com/doc/mysql/en/mysql-indexes.html
23:52 <****> kur1j: Don't create an index unless it can be used --^
23:52 <****> look at seekwill being spiffy with the bot
23:52 <****> i still water my lawn
23:52 <****> lol
23:52 <****> fuck em
23:52 * seekwill flexes
23:52 <****> dekalb doesnt have a ban
23:53 <****> i just spent alot of loot and put in alot of sweat laying new sod
23:53 <****> winmutt: most people ignore it anyway
23:54 <****> winmutt: Did you graduate from GT?
23:54 <****> hellz no
23:54 <****> I gotta resod sometime, for now I just reseed it.
23:54 <****> i dropped out of reality
23:54 <****> I ran out of tuition myself.
23:55 * chadmaynard is riding the HOPE grant
23:55 <****> winmutt is paying for my education
23:55 <****> I only got like 100 on my SAT...
23:55 <****> shiet
23:55 <****> damn free loaders
23:55 <****> hehe
23:55 <****> takin all my monies
23:55 <****> That's why we pay you next to nothing seekwill.
23:55 <****> damn hippies
23:55 <****> mhillyer: lol
23:55 <****> lol @ sat
23:56 <****> seekwill: 100 on the SAT would be impressive
23:56 <****> Maybe 160...
23:56 <****> its impossible
23:56 <****> i think there is a base of like 400
23:56 <****> I'd hire a guy who got 100 on the SAT and boasted it.
23:56 <****> Anything is possible.
23:56 <****> mhillyer: it would take balls
23:56 <****> i did aweful on the sat
23:56 <****> got near perfect on ACT
23:56 <****> Actually you can get below the 400 base if you mis-spell you name on the form.
23:57 <****> ok well I am trying to setup a database that I am using for an e-commerce site (school project and teacher hasnt said one word about it other than go do it). We are going to sell Harley Davidson motorcycles and I initially setup a database with a table named motorcycles. Setup 5 fields, type, model, price, description, stock. It bitched at me for not having an index so I just put in a primary on the type field I tried to add a bike soft
23:57 <****> And it's all downhill from there.
23:57 <****> kur1j: You got cut off "add a bike sof"
23:57 <****> I didn't take the ACT
23:57 <****> You have to put your name on the SAT?
23:57 <****> add a bike softail fat boy. That worked when I went to add another softail it bitched at me :(
23:57 <****> kurl: model will be the primary key
23:58 <****> primary key is unique by definition
23:58 <****> Anyone with the brains to shop online is overqualified to ride a Harley anyway.
23:58 <****> what do you have against harleys?
23:58 <****> Because you put a PK on softtail, you can have only one.
23:58 <****> i dont care for them much but i love me some vtwin
23:58 <****> PK?
23:58 <****> You probably want a composite key on type and model.
23:58 <****> primary key
23:58 <****> i would think model would cover it
23:59 <****> Actually my brother is a Harley mechanic, so by the laws of brotherhood I must mock them at any occasion.
23:59 <****> hummm
23:59 <****> primary key is unique by definition
23:59 <****> unique meaning one of a kind in the table
23:59 <****> ok in a tutorial i did it made me ad a field something_id and make it a unique
23:59 <****> Anyone ever use "innodb_buffer_pool_awe_mem_mb"?
--- Log closed Fri Oct 12 00:00:10 2007
Total 31 pages. You are browsing page 31/31.
First :: Prev :: [...] [27] [28] [29] [30] [31] :: Next :: Last