| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> so the question is... if you wont be helping another one of the stupid ****s, what are you then doing in this channel ?
<1> My statement holds true.
<0> so again
<0> if you wont be helping another one of the stupid ****s, what are you then doing in this channel ?
<1> Apachez, to talk to elite people like Therion, Darien, ....
<0> you seem a bit retarded yourself since you obviously doesnt know the meaning of the above question
<2> here's an idea, let's all not be ****s for a while and see how that works out
<2> you guys have your thing on #mysql on efnet, that's fine, but don't drag it onto this network and into this channel
<2> if you want to fight about it, do it in /msg
<3> a lot of slk's joining...
<1> Ya it's cool Darien. I'm not gonna bother mentioning it again.
<2> could be just a bum connection
<2> alright, cool beans
<2> let's focus on what really matters
<2> being sarcastic and abusive towards the end users
<1> yeah, RBR :)
<4> yea, mysql backups and mysqlcc ;)
<4> that is what we need focus on :)
<1> eww mysql cc ?
<2> apparently we all have different priorities
<2> mysqlcc--
<2> grab MySQL Administrator
<5> How is UNIQUE KEY and CONSTRAINT UNIQUE different?
<4> nevah :D
<4> Darien: its broken for linux ;)
<2> fraggeln: it's broken for OS X too
<2> fraggeln: they're working on breaking it for Windows
<4> or rather, broken for those that doesnt use gnome ;)
<1> RBR or Workbench for sure.
<2> !man constraints
<6> (How MySQL Deals with Constraints) : http://dev.mysql.com/doc/mysql/en/Constraints.html
<2> hmm
<2> !man foreign key constraints
<6> (FOREIGN KEY Constraints) : http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
<5> Thanks i've been to those pages
<5> Ok. I need to do an Index constraint
<5> i guess i'll keep toying with it.
<2> index constraint?
<2> those pages are for me, not you
<2> 'constraint unique' makes a constraint *called* 'unique'
<4> or maybe its debian thats broken.
<2> Debian is never broken, you heretic
<4> anyway, i downloaded mysql-admin from source and build it. ./configure and make doesnt complain
<2> Debian is pure and above reproach
<5> I want to add an index constraint
<5> for unique entries
<2> what do you mean by 'index constraint' ?
<2> you want to create a unique index?
<4> (mysql-admin:1834): libglade-WARNING **: Could not load support for `gnome': libgnome.so: <- i still get this :D
<2> fraggeln: do you have libgnome.so ?
<5> I think I want to do something like
<5> add constraint unique (username, partid);
<4> Darien: well, i dont think so, but, should the ./configure or the make give me an error if i didnt have it?
<4> ie the compiling works.
<5> Darien, what I mean to say is
<2> yeah, but you might not be compiling against libgnome
<5> usernames, partid need to be together in a unique index
<4> i used used ./configure with no options.
<5> Basically I dont want two entries that are the same
<5> I have two fields userid, partid
<2> UncleD: create unique index on tablename(userid,partid)
<5> I don't want a case of (1,1), (1,1)
<2> yeah, that's a unique composite key
<2> what I just gave you will do that
<5> How is that different from: add constraint unique (username, partid);
<2> constraints are for foreign key constraints
<5> these items
<5> are foreign keys
<5> The actual fields I mean, are primary keys from two different tables: users & parts
<2> that's great, but it doesnt' matter
<5> they are both in a user_parts table
<2> right
<2> so create a unique index on them
<5> so it shouldn't matter?
<2> you don't need foreign key constraints for that
<2> you want uniqueness in a certain table in and of itself
<5> I already have this:
<5> CONSTRAINT FOREIGN KEY fk_users_id (`users_id`) REFERENCES users (id),
<2> ok, look
<2> I don't care about your foreign key constraints
<2> they don't matter
<2> you want a unique index, you use the SQL I gave you
<2> period
<5> k
<5> where does that go
<5> inside of my create table ?
<2> you're just creating the table now?
<5> ya
<5> http://rafb.net/paste/results/3Z4is862.html
<5> ignore the line # 6
<2> hang on
<2> dude
<2> the primary key is unique
<2> you don't need to add another index
<2> your primary key does what you want
<5> when I add a duplicate entry though it doesn't seem to prevent it.
<2> hang on
<7> zxf
<2> http://rafb.net/paste/results/s8SsKG99.html
<2> UncleD: works for me
<5> hm
<5> Darien, do you have a good program you could recommend for modeling
<5> your database tables and relationships
<2> try Navicat
<2> http://rafb.net/paste/results/t8Mmee77.html
<5> Ah. Ill try it out
<2> there's the CREATE TABLE that you want to use
<5> is that different from the one i showed you?
<2> I took out the 'create index' which shouldn't have been there
<5> ok thank you
<4> (mysql-admin:7089): libglade-WARNING **: could not find `gnome' init function: `glade_module_register_widgets': /usr/lib/libgnome.so: undefined symbol: glade_module_register_widgets <-- have said that i like gnome? :)
<5> I guess it was just uncertainty on my part.
<5> So, if those two had not been primary keys
<5> then creating an index that was unique would have been useful?
<2> yes
<5> Ok, that's the lesson learned here then.
<2> :)
<2> does anyone know anything about DB2?
<8> Stoopid question. How do I see what index exists on a table?
<5> Darien, using navicat, how do you actually model the relationships
<5> Ill just read their site, nm
<2> I haven't progressed that far into the program yet, tobe hoenst
<5> I will admit navicat is pretty slick
<5> for creating queries
<7> is dba ing = lots of $$
<2> yes
<5> Is that your fulltime job Darien?
<2> no
<2> not at all
<5> ah
<5> You find better $ doing something else?
<9> where does mysql store metadata?
<9> in versions lower than 5.0
<7> why is that?
<7> how much?
<2> no
<2> _strike_: data dir
<2> UncleD: no, worse money doing something else
<2> UncleD: thinking about getting my DB2 certification
<2> snorkel1: because it's complex work and it's not for everyone
<2> snorkel1: database admin in Montreal, for example, is $78-94k
<10> Darien: right you live in montreal
<11> being a DBA always seemed kind of monotonous to me, too.
<2> it can be
<2> you have to like that kind of work
<11> indeed.
<11> like accounting :)
<2> exactly
<10> Darien: I admin a DB at work
<2> DBAing is its own bag of tricks
Return to
#mysql
or
Go to some related
logs:
ar2no
#oe
#linux
Invalid field count in CSV input on line 1
#perl
bzip2smp
#perl
#perl
emerge crashes
maildroprc
|
|