| |
| |
| |
|
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> you mean post the results I'm getting from that query at the moment?
<1> Moses: Post sample data that will show the results when the query is run against it.
<1> Moses: If there are any key/relation problems, the data will reflect that.
<0> I'm not sure how you want me to post the data to be honest
<0> you want me to show you what data already exists in the tables for example
<0> ?
<1> Moses: Post the data as INSERT statements, so that I can populate the database and run your query, so that I can see the results you're talking about.
<1> Was that clear?
<0> ok hang on
<0> think so
<2> Would someone like to help me please? I'm trying to create a user, but every time I try I get a syntax error.
<2> I'm using the sql insert tool in phpmyadmin, because I'm lazy, the error I'm getting is...
<2> #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER 'kiirani' IDENTIFIED BY P***WORD 'REMOVED'' at line 1
<3> Kii: GRANT
<3> Kii: use phpmyadmin...
<3> they have a session to add/remove users
<2> I can't find it :'(
<3> front page
<2> I feel like such a n00b.. I know that I found it once before
<3> Privilegs
<3> Privileges
<0> xgc.. sorry, you want insert statements for every table I'm using you mean?
<0> I dont quite get you
<2> ... Ugh
<1> Moses: Whatever is needed to run your query and see results as you described.
<2> Thank you so much XD
<2> I see the button now..
<0> k
<2> Mysql management frustrates me :\
<1> Moses: If it's easier for you to post the full database, that's fine.
<3> Kii: remember... GRANT
<3> Kii: i recommend you ditch the phpmyadmin and learn it from mysql command line client
<2> Tried that
<2> I always get syntax errors.
<3> once you get familiar and understand it all, go back to phpmyadmin and be lazy :)
<3> i spent time memorizing the mysql commands like bash commands... helped lots
<2> Bah. I can barely get SELECT right.. Let alone managing it myself.
<2> Memorising, eh?
<2> I just installed gentoo 3 times for my commands :P
<0> so you just want the empty INSERT statements though, or do you want me to actually put data into the database as I'm doing it?
<3> Kii: check the cheat sheets...
<2> :O cheat sheets?
<3> helped me memorize it 100 times faster
<1> Moses: empty insert statements?
<3> http://nparikh.freeshell.org/unix/mysql.php
<0> I'm not sure what you're asking me to do
<1> Moses: Is that going to show the behavior you described?
<0> are you wanting me to create new data into the database?
<0> and to keep the insert statements I used
<2> Heh, I only got a server of my own set up recently :\
<2> ooohh cheat sheet
<3> Kii: print it out and put it on your monitor... after using it 10-20 times... you start memorizing and learning
<2> I can't print..
<1> Moses: Listen. I only want to be able to see the bad behavior you want to fix. If you can do that with 1 INSERT statement that I can run the query against, that's perfect.
<2> I mean, I got the printer to work fine, but we have no ink ^_^
<0> I'm using a gui xgc.. it might be easier for me to just paste the information I already have in the database then run the query against that
<0> to show you what I get
<2> Thanks, for today, however, I'm going to use phpmyadmin.. I only want to get myself a user account so I can install kaya
<1> Moses: No. That won't do. Most people who have problems don't tell the truth, usually by accident.
<1> Moses: I don't like to guess.
<1> Moses: I have to go shortly.
<0> k xgc.. I'll have to leave it for now I think
<3> Kii: remember to FLUSH PRIVILEGES
<3> for the changes to take affect :)
<4> so - (please forgive me for being slow on this) - a natural language search would be better for searching a document body, and a boolean for searching the keywords meta data from a html doc?
<1> Moses: The solution is trivial. Did you know that? I probably only needed 1 minute or less to look at your data and the result.
<4> I'll have to experiment with this a little and see what works best - but it looks like just what I need, thanks guys :)
<0> yes xgc, but you're asking me to go through the entire program I've written to pull out all the insert statements that are relevant, and that would take me quite a while to do
<2> The user 'kiirani'@'localhost' already exists!
<2> :'( no it doesn't..
<1> Instead of "try this", "try that", I prefer to just show the correct solution and spend the time explaining why this solves your problem.
<0> well have you got 10 mins or so left?
<0> it'll take me about that long to find all the statements
<1> Moses: You can't just dump the database?
<0> how do I do that?
<0> sorry, I'm new
<0> :(
<1> mysqldump?
<0> to mysql I mean
<0> never used that befor
<0> before
<5> Dang it. Where's that bot. I needed to look up a perror.
<2> So, anyone want to tell me why root can't drop this user? Oh no wait I know..
<2> No, I don't :'(
<0> what would dumping the database enable me to do?
<0> to just give you the data or something?
<3> Kii: maybe it does still exist
<1> Ok. No problem. Here's a quick suggestion... SELECT ... FROM (t1 JOIN t2 ON (criteria)) LEFT JOIN t3 ON (criteria) LEFT JOIN t4 ON (criteria) ...;
<2> Why can't everything be easyy.. like css..
<1> Moses: If you have problems with that form, your data is likely the problem, not the query.
<0> ok let me have a quick test
<3> Kii: css is NOT easy
<2> See, this is the big problem
<2> is too >_>
<2> just keep it simple
<2> I can't modify the existing user
<2> and I can't remove it :|
<3> Kii: try doing recursive <div> tags and trying to figure out which id/cl*** is making the effect in the content :-P
<1> Moses: Be sure to move the INNER JOIN criteria into the ON clause for the inner join.
<3> Kii: you _sure_ you're root?
<1> Moses: That'll reduce the likelihood of mistakes.
<0> sorry xgc, I dont know what that means
<2> Positive.
<0> I feel so lame right now lol
<6> UPDATE times SET endTime = now() WHERE jobID NOT IN ($JOBLIST) AND endTime IS NULL; that's fine if i'm given a list of job id's: "1, 2, 5". but what if i'm given a list of job titles: "clean, cut, chop"? how could i join the job table here?
<2> And that sentence just made my head hurt :p
<1> Moses: JOIN criteria normally goes in the ON clause.
<2> However, css is easier than this. So.
<0> but they are all left joins arent they?
<0> where's the inner join?
<1> Moses: All that junk you have in the WHERE clause should probably be moved to the appropriate ON clause.
<1> Moses: No. You start with an INNER JOIN.
<0> sorry, I'm totally stuck
<3> lol
<1> Moses: You have an INNER JOIN between teams and leagues.
<0> so how do I change that?
<2> I do!
<2> I was up late last night playing with css >_<
<1> Moses: I showed you the general form above.
<6> yeah, it's difficult. i've been trying to figure it out for a few days
<2> So this cheat sheet doesn't explain how to drop users o.o
<1> Moses: Copy my comments and put them under your pillow. You'll understand in the morning.
<1> Moses: Save them for another time. Eventually, they should mean something to you.
<0> k
<0> I dont get you right now
<0> that's for sure
<7> * Starting mysqld (/etc/mysql/my.cnf) ...
<7> ..... * MySQL NOT started, proceding anyway [ ok ]
<1> Moses: JOINs and all this relational stuff can be tough to understand.
<7> any idea?
<0> yeah I know
<0> especially multiple joins
<3> Kii: DELETE FROM `user` WHERE CONVERT( User USING utf8 ) = CONVERT( 'client' USING utf8 ) AND CONVERT( Host USING utf8 ) = CONVERT( 'localhost' USING utf8 ) ;
<0> I kinda get it when it's two tables
<0> but when it goes to three or more, I just dont know what's going on
<2> ...
<0> all I want to know in this query is why the 'league_rankings' data gets set to null in my results
<0> everything else seems to be working fine
<1> Moses: If you understand single joins, multiple joins shouldn't be a problem, apart from the ordering/grouping issues.
<2> how about DROP USER 'kiirani'@'localhost' ?
<1> Moses: and I'm not referring to ORDER BY / GROUP BY. Those are different issues.
<0> why should all my data in the league ranking table have set to null then?
<0> I cant understand it
<1> Moses: Without the data I can't answer that. It's probably all in the data.
Return to
#mysql
or
Go to some related
logs:
#perl
#perl
#gentoo
#css
trayracer
compiz mouse cursor corrupted
PHP curl throw exception
ubuntu mount cdrom as root
asrock sounddrivers
#osdev
|
|