| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> unless someone else has some ideas offhand, I kind of need to see the relevant table structure
<0> and relationships
<0> I think I ran across a solution for this a few years ago, but it was on an oracle implementation :)
<1> http://tomsalmon.com/database.png it's big system
<0> and I don't recall what the solution was :)
<1> take CKIndividual, for example
<0> wow, you weren't kidding
<1> yeah, if ever i need a headache i try and study it :)
<0> how's mysql's performance for this app?
<0> and do you work for Calvin Klein, perchance? :]
<1> it's still in development, so who knows
<1> no, afraid not
<0> what's CK
<1> contact keeper
<0> aha
<0> so you didn't build that part, it was canned for that app?
<1> i'm just a freelancer, this is intended for asian/english market
<0> or is contact keeper your app?
<2> hi
<1> i'm contracted to work on a team, but could get database design changed if necessary
<2> need some quick help (a clueless biologist here) - how do i extend an existing table to maximum row size ?
<0> ok, well, anyway, where are the relevant tables? I see the Translation link table, but not the Person table
<1> Person = CKIndividual
<0> did you just mean CKIndividual?
<0> bingo
<2> anyone out there who can help me?
<0> hmm, the relationship line colour schemes overlap :|
<1> aye, it's not the clearist of diagrams
<0> so your target for this is just to extrapolate the name from the Translation table, be it in english or japanese, given the id number for either the name of familyName fields in CKIndividual?
<1> extract the name, familyName, address etc
<0> in one query?
<1> actually, it would be a cross-table select with CKIndividualEmployment
<1> in one query would be good
<1> i also need to be able to order the results, by user specified column
<0> select name, family from (select Translation.en from Translation as name, CKIndividual where Translation.ID = CKIndividual.name) as name, (select Translation.en from Translation as family, CKIndividual where Translation.ID = CKIndividual.familyName) as familyname;
<0> I have no idea on that one
<0> mysql docs say the syntax should be valid
<1> thanks, i will give it a go
<0> I might need an extra FROM in there
<0> and one less comma
<1> cheers
<0> let me know if it works :)
<1> it's almost time to disappear for lunch, will have fun this afternoon :)
<0> I see you're probably getting to use the utf8 storage features of mysql quite a bit
<0> alrighty, peace
<3> ello
<3> why would i get this error when trying to import a mysqldump to an empty db:
<3> ERROR 1005 (HY000) at line 21: Can't create table './chris_affiliates/addresses.frm' (errno: 121)
<3> seems to be related to the innodb-ness of that table
<4> !perror 121
<5> System error: 121 = Remote I/O error
<5> MySQL error: 121 = Duplicate key on write or update
<6> yes, gbut there are no keys
<6> no tables, nothing
<6> just a primary key, this is the first table being created from the dump
<6> http://rafb.net/paste/results/EkoKBg76.html (13 lines)
<6> this is where it breaks
<4> apperantly there is a line 21?
<6> yes, the last line there is line 21
<6> the stuff before it is commented out mysqldump stuff
<4> ic
<4> is that the entire file then?
<6> http://rafb.net/paste/toofast.html (32 lines)
<6> those are the first lines. the attempt to create the accounts table fails
<6> that happens if i do it manually too
<4> uhh
<4> you were too fast :)
<6> eh?
<4> click the link
<6> ah ****
<6> http://rafb.net/paste/results/xgCNut34.html (32 lines)
<4> dunno man, it's strange
<6> yep
<6> maybe i can copy the db from another
<6> but my innodb file is a single file
<6> i remember reading somewhere that you can split them up
<7> Can I use MAX or COUNT in a WHERE clause ?
<7> If I can how would I do it
<0> it just follows normal syntax
<0> select count(*) from foo where bar = "baz";
<0> oh, IN a where clause :)
<0> probably, they're standard functions
<7> What would I use to get say highest frequency of an item in a table
<8> ello all
<8> Anyone here got any experience building a c++ app in visual studio 2005 against the MySQL 5.0 C API interface?
<8> specifically, the compiler is barfing when trying to compile mysql_com.h (which is pulled in by mysql.h)
<8> it's barfing lon line 175 of that file; can't find an identifier called my_socket
<6> on freebsd, how do i specify the my.cnf file i want to use?
<9> you don't
<9> you put it in the appropriate place
<6> okay
<6> where is that place?
<6> i tried datadir/my.cnf, /usr/local/etc/my.cnf
<9> mysqld --verbose --help | grep "my.cnf"
<0> come now, he could write a wrapper that switched between various configuration files on a per-load basis
<9> he could!
<9> --defaults-file=...
<0> chances are, it's not going to happen though ;)
<6> ah, thats it
<10> cosa c'e'?
<6> --defaults-file - unkonwn parameter
<11> is there a function that allows me to see how many of a specific field that are affected when doing a mysql query which contains more than one field? like if I do SELECT Field_From_Table1,Field_From_Table2 FROM Table1,Table2 and I only want to know how many of Field_From_Table1 are selected?
<8> uhh
<8> how about 'select Field_from_Table1 from Table1' ?
<8> :p
<9> mysqld --verbose --help | grep "my.cnf"
<12> !m luu count
<5> luu: (GROUP BY (Aggregate) Functions) : http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
<9> if you have a question, feel free to *ask* it
<9> otherwise, how is anyone supposed to help you?
<8> you're completely right. I just realised I was doing something silly. Best not to ask, no?
<9> no skin off my teeth
<8> ok it seems that mysqlclient.lib is trying to link to a (different|incompatible|something) version of winsock....
<9> are you on windows?
<8> I have 4 unresolved externals: _ioctlsocket@12, _ntohs@4, _WSAGetLastError@0
<8> yes
<8> Visual Studio 2005 (beta 2)
<9> ****s
<8> I have a feeling I shouldn't be linking <winsock.h> ... should that be <wsock32.h> instead? or ...?
<8> well yeah but I'm not going to get into the whole *nix vs doze debate right now ... :p ... i'm at work, this is what we use...
<0> do you have an ldd equivalent in your IDE, to see what objects it is trying to link to?
<0> and by the way, includes are not linked libraries ;)
<8> yes, i know that much :p
<8> I have specified only one lib explicitly to link .... mysqlclient.lib
<8> um
<8> but that's not what you're asking
<13> Ive installed mysql on the pc im on how do i find the p***wd and username
<14> Is there a way of doing an if/else type decision in a query?
<15> !m Thedonn control flow functions
<5> Thedonn: (Control Flow Functions) : http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html
<13> Any 1 help
<15> dexion: just login as root with no p*** and set one
<16> Darien, where did CPUnerd go? :(
<9> Daveman: brasil
<17> hey guys whats up
<17> anyone here?
<9> MySQL's market share
<4> dexion: on a clean install username ir root with no p***word
<4> !m dexion securing
<5> dexion: (Securing the Initial MySQL Accounts) : http://dev.mysql.com/doc/mysql/en/Default_privileges.html
<18> :)
<17> Anyone one here know how I can have a stored procedure that can use a variable in the LIMIT clause?
<19> Ivan_Von_Girderb: use dynamic sql? :)
<20> !man sql syntax prepared
<5> (SQL Syntax for Prepared Statements) : http://dev.mysql.com/doc/mysql/en/SQLPS.html
<20> IvanGirderboot: read that
Return to
#mysql
or
Go to some related
logs:
crashdummymch
rules_save iptables
vde_switch gentoo
#linux
ubuntu crashes burn dvd
#gentoo
playboy deborahgibson
#perl
#suse
fedora dial-in server
|
|
