| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> i just thought maybe you guys had heard of a php/mysql compatibility issue with such an archaic version
<1> none i've heard of. if you do something like "sum(virii) as virii,sum(spam_lo) as spam_lo" etc
<1> does it work?
<1> (in php)
<2> how do I ***ign an auto incrementing number to my primary key?
<3> hah, bingo!
<4> evening every1
<0> ah hah, yes that seems to work
<0> thanks much gleam-
<5> how to make unlimited sub-category
<5> so, parent cat <- sub cat <- sub sub cat <- sub sub cat, etc
<5> i don't want limit it
<6> hi
<7> I just updated from mysql4 to mysql5 and I can not log in anymore. how can I reset the root p***word?
<8> 4.0 to 5.0?
<7> yeah
<9> Hi... so... I've got a confusing problem with syntax
<9> i have a long and complicated sql query. basically i've got a table A and a table B, and then a table C which encodes describes relationships between items in table A and items in table B.
<10> have a question...when setting the p***word for root /usr/bin/mysqladmin -u root -h blah.blah.com p***word 'newp***word'
<11> mccbaka: what's the syntax problem
<10> i do all of that bu it never sends me back to prompt
<10> just sits there
<9> the sql query selects items from table A, and then finds the items in table B it is connected to by joining on both B and C. it works. however, i would like to have it so that if A does not have any items in B it is connected to, it still returns.
<9> hey dshadow
<9> anyway the problem is, it seems the way to do this is use LEFT INNER JOIN
<12> can someone help me I'm trying to biuld a php page with html form into it that will post the data to a mysql table
<11> if you want the rows in the left table that don't match the right table, do a left join
<11> an inner join essentially adds a (where right table is not null) condition.
<13> What is stored in .MYD mysql files?
<11> CrazyTux: the data
<13> I have databases with 0 Byte MYD
<13> DShadow, files... is there any way to repair it
<11> it's a little hard to repair tables that have no content
<9> however, when i do this, instead of returning NULL for the B columns on every row where B cannot be joined, as the docs seem to indicate it should, it returns many, many copies of that row, and fills the B column with every single possible entry in the B table.
<9> okay... so use LEFT JOIN not LEFT INNER JOIN?
<9> also: what is the difference between ON and WHERE? I cannot figure this out exactly... it requires me to use an ON when i do a left join, but doesn't seem to care one way or another whether WHERE is present
<11> what's the query you're doing?
<13> DShadow, haha, so basically its screwed?
<11> CrazyTux: yeah
<11> the difference is that the on condition describes how two tables are related
<11> as opposed to a where condition that limits the data
<9> SELECT p.id, j1.id, j2.id, j3.id, f1.id, f2.id, f1.title as t1, f2.title as t2, f1.id as i1, f2.id as i2, p.posted as posted, p.title as title, p.src as url, p.poster as poster FROM posts as p LEFT JOIN joints as j1, joints as j2, joints as j3, faucets as f1, faucets as f2 ON j1.post_id=p.id and j2.post_id=p.id and j3.post_id=p.id and f1.id=j1.faucet_id and f2.id=j2.faucet_id WHERE j1.filter=1 and j2.filter=2 and j3.filter=3 and p.feed_id=1
<9> like i said... it's a bit complicated
<11> ew
<11> the cross joins are the problem
<11> you want ... from posts p LEFT JOIN joints j1 on p.pid=j1.post_id LEFT JOIN joints j2 on p.id=j2.post_id ...
<9> oh, ok
<9> that makes sense
<11> you're getting a crazy number of rows because , is a cross join, which takes all the rows on the right table, and grafts them onto the end of all the rows on the left table
<7> #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client <-- I just updated phpmyadmin and mysql, and I'm getting this message with phpmyadmin... any clue why this is happening?
<11> so A, B results in a table that has numRows(A) * numRows(B) rows.
<11> it's been my experience that a cross join is rarely what you want to do
<8> cross join?
<14> How can I repair a table via command line in mysql?
<11> firewire: A , B is a cross product of A and B. thus, a cross join.
<14> I know it can be done through phpMyAdmin
<11> "repair table tablename"
<9> that worked great. thanks so much for the help
<14> DShadow: Thanks
<11> sure, np
<8> DShadow how deep would you do the joins on j2?
<11> firewire: ?
<8> sorry I haven't really been following this so I'm trying to catch up but it looks like you're trying to join 'joints' for each level in a tree
<10> anyone help me with an error code of 1045 (28000) : access denied for user 'root'@'localhost' (using p***word: no)
<11> I dunno, you'll have to ask mccbaka_ that
<11> sql tables are bad for trees
<8> yes
<9> it's not really a tree no.
<8> the more joins you have the longer it takes to optimize so mccbaka_ is probably better off only joining 'joints' once per query and calling the query multiple times
<11> if I need a tree, I have a parent column that points to another item in the table, and then build the tree out in code
<11> firewire: try telling that to my 10-join + 2 subselect queries. ;-)
<8> you can only join 31 tables in a query on 32bit arch
<11> ahh.. that's why it's 31 tables.
<8> yup
<8> just something to watch out for :)
<11> are subselects counted together with that? or is it a separate set of 31 tables per subsekect?
<8> depends
<8> there are different types of sub selects
<9> it's conceptually kind of straightforward... the joints table just has three columns, "a id", "b id", "kind of connections", and it basically just says "a is connected to b".. it's guaranteed a will never have more than one entry per kind of connection in the table
<11> what about union?
<9> this is the best way i can think of to do it
<8> union doesn't
<11> I felt so dirty when I had to do, essentially, ... left join (select 1 union select 2) ... in a query
<11> totally kills the performance of that query
<13> ERROR 1 (HY000) at line 19: Can't create/write to file './blog/access.MYD' (Errcode: 9) no matter what I do... I get this error
<13> What can I do to fix this, where is the perm issue at?
<8> !SQL perror 9
<8> ew mm
<8> CrazyTux check dmesg
<13> firewire shows nothing relating to sql
<13> firewire this is openbsd system
<8> what does it show?
<15> Hi. I've this output on my upgrade Mysql 5, when restart daemon: "....This is needed if you want to use the new GRANT functions, CREATE AGGREGATE FUNCTION, stored procedures, or more secure p***words in 4.1..." what its? Help. .. Complete Msg: http://paste.ubuntu-nl.org/14327.
<8> Rubencho you didn't upgrade your grant tables
<15> no..
<12> can someone help me. I need to create a form that will post data into mysql
<8> tdd1984 see #php
<15> firewire: .. I drop all dbs...
<12> lol they told me to try here
<15> for cleaned
<8> tdd1984 search for php mysql tutorial
<12> firewire done read them
<12> i know how to create the tables
<13> firewire nothing with mysql
<13> firewire a bunch of system stuff
<12> but need to make a form up that will post the data into the tables
<8> CrazyTux run mysql_fix_privilege_tables
<8> tdd1984 we really can't help you with that
<8> unless someone is feeling a lot more charitable than I am
<12> lol
<14> http://pastebin.com/727691 - any ideas on these errors reported by my blog? I'm trying to fix it. hm
<8> paste the output of dmesg
<14> firewire: Me?
<8> yes
<14> dmesg would help? hm, alright. I'll check that
<8> a simple flush tables might fix it
<14> Hm, flush tables ?
<14> Is that the command?
<14> In mysql, that is
<8> yes
<14> Alright. I'll give that a try.
<14> That can't hurt anything, right?
<14> firewire: Thanks. I'll let you know if it doesn't work.
<7> is there a way to wipe every single table and start over from scratch?
<7> ( the upgrade from mysql 4 to 5 didn't go as smoothly as planned
<8> did you read the upgrade notes?
<7> no, I just hoped that portage would be kind enough to do those things for me
<16> linolium: DROP DATABASE dbname; CREATE DATABASE dbname;
<8> done
<7> Xgc: does DROP DATABASE *; work?
<8> oy
<8> ignorant gentoo fool
<16> linolium: Sorry. No.
<1> rice rice baby
<7> Xgc: how about rm -fr /lib/mysql
<14> nomed: /whois linolium
<14> Whoops
<7> just whois me why don't you..
<14> Hehe
<1> everyone /whois the ricer
<17> howdy
<17> Am I wrong in saying that escaping ' in user input will stop all SQL injections? If so, can you give me an example where it wouldn't stop an injection?
<12> can someone help me. I need to create a form that will post data into mysql
<17> textual data?
<17> form on a website, or in an application?
<8> linolium well, now you're going to be on planetmysql.org :)
<1> hahaa
Return to
#mysql
or
Go to some related
logs:
mysql query browser change user password
Synaptics deviceOFF called gentoo
yum install vnc centos
my_compress gentoo
mplayer FT_GlyphSlot_Embolden
#openzaurus
#perl
perlInterp Perl.pm example
XOrg fbdev virtual size
VT3344 is not supported yet
|
|