| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> sesstreets: You're confusing mysql with drugs I think
<1> w32, Do you know of a programming language?
<2> Or the ***...
<3> and maybe have something useful
<2> w32 you know php?
<3> will a little html and alittle php
<1> That will work.
<0> Not necessarily advising "not learning MySQL", but with Rails and such you really don't need to know much, if you're just trying to get something done
<1> Ruby on Rails...
<3> rails?
<0> will: You keep not doing it, shaddup
<2> Php+mysql=infinity
<1> No way
<0> PHP is crap
<4> Therion: interestingly, rails actually does query-building fairly well. no select * and all
<2> What do you use?
<0> I need to join #php and say that
<2> I cant
<2> Got banned
<1> PHP is a tool... but not the end all.
<3> I'm really intrested in perl too
<2> Somebody faked my name
<1> We mirror bans from #php :)
<0> arjenAU: Yeah, it's okay... Django is not always horrible, either (vaguely similar python framework)
<4> I'm interested in chocolate
<4> Therion: aye
<0> w32: You poor dear
<2> I guess I was only temp banned...
<0> w32: If there is anything I can do to help cure you of this horrible perl affliction, please just let me know
<2> aye
<2> Whats wrong with perl though?
<0> Perl coders
<1> heh
<2> Mysql coders sounds cooler anyway
<0> The one thing I can't stand about Ruby is it wants to be a better perl
<1> I want to learn Ruby....
<2> me to
<0> If you don't mind the perl roots it's a great langauge
<1> My roommate is named Ruby... ;)
<0> and also language
<2> She hot?
<0> will: Kill him/her/it
<1> Nope
<2> aww...v_v
<1> Na
<0> I have a dead great aunt named Ruby
<0> And one named Pearl
<1> heh
<3> Well if I wanted to start with a real simple database I would just create a database called wtfe and then ?
<2> I have a dog named php
<2> Yes
<0> sesstreets: That's sad and pathetic on a deeply disturbing level.
<3> Sesstreets: my cats name is HP
<2> Nice
<0> !tell w32 about tutorial
<0> !tell w32 about tutorials
<5> Alrighty.
<1> w32, wtfe?
<2> w32
<0> !tell w32 about normalization
<5> Alrighty.
<0> w32: Have fun. ;)
<1> !tell us about tutorial
<5> will asked me to tell you this: MySQL Tutorial: http://www.mysql.com/doc/en/Tutorial.html SQL Tutorial: http://www.sqlcourse.com
<2> Thats not the nicest way but it definityly works
<1> !tell us about tutorials
<5> will asked me to tell you this: Some tutorials: http://sqlcourse.com and http://www.webdevelopersnotes.com/tutorials/sql/index.php3
<3> thanks therion
<1> Shouldn't that be merged?
<0> Nah
<0> The bot should just be thrown away
<3> will: wtfe=database name for example
<1> Should get some tutorials on the Wiki
<1> w32, Wouldn't that be dnfe?
<2> w32 your one the right track
<0> will: When you were at the gas station of love, did you have to use the self-service pump?
<3> it's the defaults and such that are confusing me
<1> Therion, All the time. There for quite some time seeing that I have a large tank to fill.
<6> is there any way to automagically insert a row and a field is given the sequestial number based on the highest number in the column? (no... i don't need auto-increment)
<1> w32, What defaults?
<1> bashusr, YOU KNOW ME??
<3> I have the concept down and a general idea of what the structure should look like...
<0> bashusr: "No"
<6> will: why do you always ask.
<6> Therion: 2 queries... huh?
<3> will like for example
<1> Because I like the attention.
<7> lol
<6> i love you too will
<6> :-/
<1> awww
<0> bashusr: Unless you want to use 5.0 and use a trigger or procedure or somethign to fake it
<1> [RainMkr], Howdy!
<7> !kick will Attended too!
<3> field type etc
<1> :(
<1> ahh! saved
<1> w32, It's ra ther quite simple.
<1> But complicated at the same time! That's why you should use Quickbooks.
<1> Quickbooks uses MySQL...
<7> will: eh?
<3> quickbooks won't help me understand mysql
<6> how does mysql decide which item is ordered first/second if they have the same value?
<1> [RainMkr], ltns
<7> Yea, how are things?
<1> Good good. And you?
<8> http://hashmysql.org/paste/1649
<9> bashusr: How can you tell? :)
<8> will could you take a look?
<1> Why me? :(
<7> bashusr: depends upon how the optimizer decides to join the tables.
<9> bashusr: If you need a specific order, then ORDER BY it. Otherwise, ***ume nothing.
<1> You got like the smartest people talking right now (not me)
<6> mendel: i am ORDER BY... but the values are 5 and 5
<6> ORDER BY 'order'
<7> well obviously 5 comes before 5.
<6> obviously [RainMkr]
<1> BucWheat, lol
<1> So... is this a good thing?
<9> bashusr: Well, order by more than one column if you require it ordered by more than one column. Otherwise, ***ume nothing.
<6> you can order by 2 columns?
<1> Oh that query does not work
<1> bashusr, Only in the Enterprise version.
<9> bashusr: No, I'm just leading you on.
<0> bashusr: You can order by many columns... or expressions... or justa bout anything you like
<9> bashusr: Of course you can!
<3> Therion:Normalization, good information very clear thanks again
<4> will: you really deserve some beating
<1> :)
<4> bashusr: you can just do it. asking here gets a bit silly
<1> arjenAU, But he knows me!
<3> I wouldn't have found that until after i'd made alot of mistakes
<4> others don't
<8> will yea it is a good thing that i thought to use pastebin to show you what i'm trying to do :)
<7> BucWheat: Where's Spanky?
<1> BucWheat, So the query should take the last two entries in tbl1 and retrieve all in tbl2
<1> w32, Coke
<0> w32: If that link it gave you was Mike Hillyer's tutorial, it should get you started as far as what you need to do, conceptually
<7> w32: But it needs to be *good* root beer, Barq's doesn't cut it.
<1> #mysql is officially sponsered in part by Coca COla
<0> w32: The tutorial in the manual will get you started with the commands to do those things, etc
<8> [RainMkr] across the street horsing around with alfalfa
Return to
#mysql
or
Go to some related
logs:
#debian
#gentoo
loses network connection ubuntu
#linux
#css
#osdev
#debian
linux autoclicker
#dns
hibernate-ram + writer error operation not permitted
|
|