#mysql
08 October 2007
Total 24 pages. You are browsing page 5/24.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
05:59 <****> duh
05:59 <****> A child of five could understand this! Fetch me a child of five
05:59 <****> loser
05:59 <****> chadmaynard
05:59 <****> a noob
05:59 * ToeBee is one of 5 children
05:59 <****> kill will
05:59 <****> die die die die die die DIE DIE DIE DIE DIE DIE DIE
06:00 <****> I wonder if I'm the only kill factoid...
06:00 <****> So much != love
06:06 <****> golf
06:07 <****> tennis
06:07 <****> FOOT BALL
06:07 <****> football is one word
06:08 <****> Not if you emphasize each word
06:12 <****> any gentoo users here? what package do I have to emerge to access mysql from perl?
06:12 <****> WE HATE GENTOO
06:12 <****> Leave
06:12 <****> Now
06:12 * ToeBee smacks seekwill
06:13 <****> Before someone kicks you
06:13 <****> Like that Chad guy
06:13 <****> thanks ToeBee ...at least I was entertained :-)
06:13 <****> His brother is in the NFL you know.
06:13 <****> DBD
06:13 <****> http://www.nfl.com/players/bradleymaynard/profile?id=MAY568387
06:13 <****> dev-perl/DBD-mysql is the package in portage
06:13 <****> can you use left join on and regular joins like select a.id from a, b LEFT JOIN c ON a.id = c.id WHERE ...
06:14 <****> pidgen: Yes
06:14 <****> im getting and error
06:14 <****> pidgen: FROM a INNER JOIN b ON a=b LEFT JOIN c ON b=c
06:14 <****> You may change the join conditions as you see fit
06:15 <****> How would one state the candidate key (letting A and B being relvars) A TIMES B?
06:16 <****> is inner join the same thing as a regular WHERE a.id = b.id ?
06:16 <****> No
06:17 <****> seems like they function the same
06:17 <****> i cant see the diff
06:18 <****> ugg this is a mess
06:18 <****> ugg
06:19 <****> I also have some many to many relations ships with a look up table
06:19 <****> http://rafb.net/p/guQzBK21.html
06:20 <****> the g, gs, c, cs tables are kinda only used if needed (dynamic sql statement)
06:21 <****> it was all working fine until I tried to left join on results
06:24 <****> hey if i had question about using text box to query keywords in db for product search, would i ask in the #php or here?
06:24 <****> pidgen: Well, when you change to an outer join that position of the criteria makes a *big* difference.
06:24 <****> football, in some usages, is one word.
06:25 <****> Xgc: any help on that query?
06:25 <****> pidgen: You lose the outer join behavior when you test for equality in the WHERE clause.
06:26 <****> pidgen: Move the criteria into the ON clause.
06:26 <****> Fiveohthree: depends on if your question is about how to handle the html/http/php part or if your question is about how to issue the query to mysql based on the data you have in php
06:26 <****> ok Ive alwasy done it like this only using left joins when needed im gonna read up on outer and inner joins
06:27 <****> pidgen: Are there any fields from the result table in your WHERE clause?
06:27 <****> pidgen: s/result/results/
06:28 <****> pidgen: Also, you probably want to place ()'s around the comma list of tables.
06:28 <****> yes Xgc
06:28 <****> blah
06:28 <****> pidgen: The missing ()'s will break the SQL in MySQL 5.0+.
06:28 <****> ok
06:29 <****> pidgen: What version of MySQl are you using?
06:29 <****> blah
06:30 <****> 5.0.27
06:30 <****> i know
06:30 <****> it will be optional
06:30 <****> pidgen: Ok. So you have an error at the moment, correct?
06:30 <****> yes
06:30 <****> pidgen: The missing ()'s cause that.
06:31 <****> brb
06:31 <****> pidgen: FROM (t1, t2, t3) LEFT JOIN t4 ON ...
06:32 <****> pidgen: Any criteria involving t4 needs to be in the ON clause, not WHERE clause, for that outer join.
06:32 <****> pidgen: .. other than IS -and- IS NOT NULL tests.
06:33 <****> ok removed it from the where clause its looking good one sec its not return all results let me check this out
06:35 <****> pidgen: Well, you have other problems in the posted SQL, like using table aliases that don't exist.
06:36 <****> So could anyone help me fix my mysql permissions? When I imported a backup it removed my root password (which I forget the old one) and it imported a few other users but it gave them root permissions I'd like to wipe all users and remake them but dunno how
06:36 <****> pidgen: Otherwise, you should be fine.
06:36 <****> pidgen: Avoid restoring the mysql tables, unless you really really wanted that.
06:37 <****> Ooops... cmanns, that was for you.
06:37 <****> Well I imported the mysql table from the backup =X
06:37 <****> cmanns: Then you should be fine. Why would the backup be that far out of date?
06:38 <****> Xgc how do you add criteria to the on clause?
06:38 <****> the backup was from another server... same mysql versions if i remember right but the permissions are all outta wack, I'm going to host this php site for a friend but I don't want him to have access to the other databases
06:40 <****> Hi all. If I do CREATE VIEW v AS SELECT * FROM t; Is there a way I can check if table v already exist before I prefrom further query ?
06:40 <****> cmanns: As I said, if you didn't want the mysql tables updated, you probably should have avoided restoring that db. Often, I will backup everything but the mysql database, just for that reason and backup the mysql tables separately.
06:41 <****> t4.field ...
06:41 <****> I know, I forgot about that :) so I'm asking for a way to fix it
06:41 <****> cmanns: Don't you have a backup of this server's mysql tables?
06:42 <****> no I just imported the database right after setting up the server
06:42 <****> cmanns: If so, restore it.
06:42 <****> cmanns: You can run the init script by hand.
06:43 <****> cmanns: or install another server and backup the initial mysql database from that.
06:43 <****> So what if I dump all db's cept mysql table run the init script then restore the tables?
06:45 <****> cmanns: That'll work. You'll just need to add the necessary users for all those databases.
06:45 <****> mkay
06:45 <****> is there any good guide for mysql users and permissions?
06:46 <****> On the old server I tried to make one user allowed to make db's but not view others in phpmyadmin yet I couldnt figure it out the user had access to all db's =/
06:46 <****> cmanns: http://dev.mysql.com/doc/refman/5.0/en/user-account-management.html
06:46 <****> and also: http://dev.mysql.com/doc/refman/5.0/en/database-administration.html
06:46 <****> is doing a join faster than simply using where clauses?
06:47 <****> I guess I could just change the root password (since it became the old one which i dont have anymore) delete all users and remake them?
06:47 <****> prakriti: Both are effectively joins. It depends on the engine whether they are handled similarly.
06:48 <****> prakriti: I prefer using JOIN ON syntax and moving the proper join criteria into the ON clause.
Total 24 pages. You are browsing page 5/24.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last