IRC Logs

Network: freenode Channel: #mysql

	Enter your search terms Submit search form
	Web www.irclog.org

[20:14]<lnzjz>snoyes, i've added comments to explain what i would expect
[20:14]<lnzjz>it's the same with order by id, a DESC
[20:18]<aajyzjg>Hello, I'm looking for help with dbdesigner4/Ubuntu (can't find libXft.so.2), anyone knows where I can find some help (beside #ubuntu) ?
[20:20]<irgw1>Hello - I was wondering if you could help with a problem - on a server I am a user on - we have a problem with mysql. Sometimes it seems to crash - but with no apparent signs in the logs
[20:25]<irgw1>crashed again - this time using pma - "#29 - File './phpmyadmin/pma_relation.MYD' not found (Errcode: 9) "
[20:27]<sgjdns>Legor: http://hashmysql.org/paste/2269
[20:27]<z2axyzc>Can i read out the ID where I inserted something?
[20:27]<sgjdns>last_insert_id
[20:27]<tjmjigtx>select last_insert_id();
[20:27]<drgynfn_>Does @@IDENTITY do the same thing?
[20:27]<z2axyzc>thy
[20:29]<tjmjigtx>hrm... it appears to.
[20:29]<lnzjz>thx snoyes, i would have solved the problem the same way ;)
[20:30]<drgynfn_>@@IDENTITY is what I use in MSSQL. I saw that it worked in MySQL, but I wasn't familiar with the last_insert_id() function.
[20:33]<tjmjigtx>DanielE_: description of last_insert_id() is found here: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html
[20:33]<drgynfn_>Still hoping someone can help me with my array question. I've pastebin'ed the query I'm hoping to use this in:
[20:33]<drgynfn_>http://hashmysql.org/paste/viewentry.php?id=2270
[20:35]<z2axyzc>hm with last_isert_id I get always Resource ID7#..but tehre is no ID with 7 ?
[20:36]<z2axyzc> mysql_query("SELECT last_insert_id() ") or die(mysql_error()); << I treid like this
[20:37]<sgjdns>abchirk: You still need a mysql_fetch_assoc or equivalent on the results from that query.
[20:37]<z2axyzc>ah
[20:37]<vfuvxnz_>in php ?
[20:37]<z2axyzc>its php yes
[20:37]<lnzjz>snoyes, can we replace "select @count := 0, @oldId := 0 AS theId, 0 AS theData" by "SET @count := 0" at the beginning of the query ?
[20:39]<vfuvxnz_>http://us2.php.net/manual/en/function.mysqli-insert-id.php
[20:40]<sgjdns>Legor: you can do anything you like. I was just trying to make it work as a single query.
[20:40]<lnzjz>that works great, i just thought it was more elegant that way, thx for all your help :)
[20:43]<z2axyzc>thx
[20:49]<gycc>I am trying to retrieve posts from a specific forum in phpBB and have this SQL-statement, but I only want the topics and not the replies. Can someone help me with this: http://pastebin.ca/110429 ?
[20:50]<lzygv_z>Hi.
[20:50]<gycc>What method can I use to eliminate rows which only exists in one of the tables?
[20:50]<lzygv_z>I'm new to MySQL and I'm a bit curious as to how MySQL stores its data.
[20:50]<lzygv_z>And where.
[20:51]<sgjdns>nikK: Delete using a left join where some field is null
[20:51]<mggmgf>nikk: I don't quite understand. If you just want the posts, then you don't need to eliminate rows, you just won't use the posts and posts_text tables at all.
[20:51]<mggmgf>erm if you just want the topics
[20:51]<mggmgf>or do you mean you want the first post in each thread? or
[20:51]<drgynfn_>print_r: Not a very good question, but maybe this will get you started:
[20:51]<drgynfn_>http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html
[20:52]<mggmgf>i think it's more a question about phpbb than mysql, so just tell me what you're trying to get at :)
[20:53]<gycc>mendel, the post_text for the topics are in posts_text-table
[20:53]<mggmgf>Yeah, I know phpbb. I just don't know what data you want.
[20:53]<lzygv_z>mendel: There is a #phpbb channel here on Freenode.
[20:53]<lzygv_z>I'm sure they know their share of MySQL too :-)
[20:53]<lzygv_z>Thanks DanielE_
[20:53]<mggmgf>print_r: Sure, but it's just one question. No harm in answering it here.
[20:53]<drgynfn_>p.s. by not a very good question, what I actually meant was, "not a very easy question to answer"
[20:54]<drgynfn_>Wasn't trying to come off as flamish
[20:54]<pnzzs>is it possible to run both the data node (ndbd) and sql node (mysqld) on the same physical machine and have a redundant cluster?
[20:54]<lzygv_z>Hehe, don't worry, I suspected that :-)
[20:54]<gycc>mendel, i want the topics with their post_text and NOT the replies to that topic, which is what i am getting with the SQL i mentioned
[20:55]<lzygv_z>mendel: I'm just wondering if the phpbb folks might be more suited to answer this question due to their knowledge of the system.
[20:55]<mggmgf>Could be
[20:55]<gycc>print_r, i allready asked my question there, and got no answer :/
[20:55]<mggmgf>I guess he can go there if he doesn't like my answer!
[20:55]<mggmgf>nikK: topics.topic_first_post_id is there for exactly this :)
[20:56]<lzygv_z>I see.
[20:56]<gycc>mendel, oh, thanks, then i'll look into that :)
[20:56]<zzgggagggd>is it possible to do a select on a table that is in a different database from the current one?
[20:56]<mggmgf>nikk: you can skip posts entirely and just look at topics and posts_text that way, or look at posts if you need the metadata too
[20:57]<rrsjggysgg>database.table.column
[20:57]<sgjdns>greenjenny: Yes, use dbname.tablename
[20:57]<zzgggagggd>wow, as simple as that.
[20:57]<zzgggagggd>thanks!
[20:58]<gycc>mendel, i see! I should have studied the db-layout some more, thanks :)
[20:58]<mggmgf>np :)
[20:59]<pnzzs>nikK what programming language are you using ?
[20:59]<gycc>fears: php 5.x
[20:59]<pnzzs>cool, can't do that with ColdFusion :S
[21:00]<snfmrnc>is it really useful anyway ? (coldfusion)
[21:00]<pnzzs>ugh sorry that was meant for greenjenny
[21:01]<pnzzs>I think PHP is prob more flexable but I find CF usable
[21:01]<pnzzs>lets not go down this road been done many times over :)
[21:01]<snfmrnc>I learned about its existence some weeks ago by accident
[21:01]<snfmrnc>it's weird
[21:02]<gycc>I'm not familiar with CF :p
[21:02]<pnzzs>yes it is
[21:02]<pnzzs>kinda dumbed down
[21:02]<snfmrnc>well I didn't research it in fact, don't care enough
[21:02]<xjzfnv>ColdFusion is evil.
[21:02]<snfmrnc>but if it's some kind of advanced dreamweaver
[21:02]<tjmjigtx>I never understood what made it compelling over anything you can find in FOSS
[21:02]<snfmrnc>may they suffer and die
[21:02]<pnzzs>LOL
[21:03]<pnzzs>very very easy to learn
[21:03]<tjmjigtx>pfh... so is php.
[21:03]<xjzfnv>TodoInTX: It costs something. Companies go, "Well, if it's from our favorite multimedia company and costs tons more than that free PHP stuff, then it must be good!"
[21:03]<pnzzs>that maybe true too
[21:03]<snfmrnc>yup
[21:04]<snfmrnc>sadly that's true Xorlev :)
[21:04]<snfmrnc>people feel like they got stuff for their money when they waste it
[21:05]<rrsjggysgg>its what myspace uses. that's enough for me to stay away from it
[21:05]<snfmrnc>oh really
[21:05]<xjzfnv>Now, I do spend a few extra dollars for some things to get better quality, but that's material items which actually have production costs.
[21:05]<xjzfnv>Seldaek: Yes...Myspace runs IIS6.0 w/ ColdFusion. Can someone say disaster?
[21:06]<xjzfnv>If they migrated to a LAMP they could probably cut their server cluster by a third if not more.
[21:06]<snfmrnc>hah
[21:06]<snfmrnc>so it's really a website made for stupid fucks by stupid fucks :P
[21:06]<pnzzs>it will interesting to see if they switch to something else
[21:07]<xjzfnv>Exactly, which is why I'd never be caught dead on there.

Back to #mysql
Or go to some related logs:
#gentoo
#suse
#gentoo
#gentoo
#gentoo