| |
| |
| |
|
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> no kiddin'
<1> will: ;)
<2> hmm. is there a better way to lock certain rows with share mode than a select?
<0> m: no.
<1> will: Most of these people do not party quite to the extent that I did when I partied, so perhaps it is just not crazy enough for me. ;)
<3> heh
<1> will: Or perhaps I got out of a particular phase of stupidity and no longer wish to return? ;)
<0> m: of cuorse you could use some kind of aggregate (like count) to not actually retrieve much of a result set. it's just so that the system knows where to set locks
<2> (I don't want to have any results returned from that select)
<2> ah
<3> Therion, Just wait till we have our own party..
<1> M: WHy lock them at all?
<0> M: I just made that up ;-) use brain. it's allowed ;-)
<0> and there's therion's q too. answer that. if you can't, there's no need
<1> yay
<0> will: what's that with managers at work??
<1> It's his latest excuse for declining to meet me when I'm in Cali
<2> I'm locking them because in the statement right after the lock, I need to insert some rows based on the existance of the row I'd be locking
<0> M: and INSERT ... SELECT doesn't do?
<4> HI!
<1> BYE!
<0> boo!
<4> :(
<4> What is up.
<2> and unless you can say "select from table where ...", my brain is out of ways to... do that thing.
<4> I'm looking for someone to give me about 5 minutes of their time.
<0> M: you can. INSERT INTO table2 SELECT ... FROM table WHERE ....
<2> I'm using insert select, but no, I don't think that it'd work
<0> sesstreets: that's a bit demanding.
<4> Well
<1> sesstreets: Sorry, I only have 4 minutes of time to spare.
<4> Then can I just ask my question?
<1> Now there's a novel concept.
<4> Ahh much better I see.
<4> Im currently working on a project, called wp-stats
<4> Its a visitor recorder for wordpress
<4> Currently the script is setup to write to a html file
<1> M: Why not?
<4> http://sesstreets.maryemicari.com/logfile.html
<4> However, since wordpress is so nice, I thought I would try to do it mysql style. I just dont know where to start.
<2> because one of the values being set up in the new row is based on the existance of the row I'm locking
<1> M: Right, but why doesn't an INSERT .. SELECT do this for you?
<4> Its not like Im building a busniess market structure in mysql, I just want a table to write to and to read from.
<3> arjenAU, I'm one of two managers at work. The other one is leaving that week of the UC to TX for a conference. Who would run the company if I were to go to the UC?
<1> M: FOr that matter, why not an INSERT .. SELECT ... FOR UPDATE, if you need to hold that lock even more
<5> hey....i cant figure out how to make a new mysql database with a user / p***word for serendipity web log
<1> or lock in share mode, etc
<0> will: competent employees?
<3> arjenAU, hahahahah
<2> Therion: I don't think that it's set up to do this. I'll explain further:
<3> tuxxman, Make database. Make user. Not in any particular order.
<3> !m tuxxman create database
<6> tuxxman: (CREATE DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
<4> Wow...everybody skipped me
<3> !m tuxxman adding new user
<6> tuxxman: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<0> tuxxman: following the installatin insturctions for that app might be handy.
<2> if I don't set a lock, and a delete of the (locked) row occurs before the statement commits
<5> im at that URL but i dont understand it
<0> M: you're confused.
<3> tuxxman, Which one?
<2> then the delete will not be able to properly update the row affected by the insert
<0> M: locks can also be implicit. a single statement is always atomic.
<1> sesstreets: create table wpstats ( int not null auto_increment primary key, ip varchar(15), hostname varchar(100), browser varchar(50), protocol varchar(20), viewtime datetime, referer text, so on )
<2> I don't think that I am, but I may be : )
<5> will, the one that the bot printed
<3> tuxxman, Which one?
<5> SQL tuxxman: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<4> wordpress offers a dashboard of sorts to read data and such, how would i read it? a simple query
<4> ?
<3> tuxxman, What part do you not understand?
<1> M: What is your transaction doing after the INSERT?
<5> all of it
<3> tuxxman, Do you know English?
<2> arjenAU: ahh. hmm. you may be right!
<1> sesstreets: I don't know enough about WP to say. I just use it, have not done any extension work
<5> will, i dont understand what to do!!!!
<0> M: where you based?
<5> it doesnt tell me
<3> tuxxman, Have you ever tried PostgreSQL?
<4> Well how would I output the data stored in a table?
<0> tuxxman: you basically want someone to hold your hand...
<5> im a complete mysql newbie and it just says to do "CREATE USER" but to where?
<3> I heard that was a really good app...
<0> will: you really have to stop that
<2> arjenAU: what do you mean by based? my physical location?
<3> ok...
<0> M: yes
<5> arjenAU, i want someone to show me what to do
<5> ***hole
<2> arjenAU: Calgary, AB, Canada
<3> tuxxman, Name calling is not ice.
<4> Thats how you DONT get respect in #mysql
<3> Nor nice.
<0> tuxxman: may I inquire why you are calling names now?
<4> seriously
<3> sesstreets, Replace "#mysql" with "life"
<1> You're all ***holes
<1> Bite me
<5> because you're accusing me of asking for someone to hold my hand
<4> :P
<5> when im asking for help
<4> But you are
<1> tuxxman: But, you are.
<3> I gave you help.
<4> :)
<7> tuxxman: careful, while being arrogant and stuck-up may be tolerated, name-calling is not.
<5> will, and i dont understand it
<4> How to create a user...
<1> tuxxman: You don't like the cl***ification, but it is accurate even if it is rude.
<4> phpmyadmin?
<0> tuxxman: you can take it any way you like. what I'm saying is that you're asking for a fish, rather than a fishing rod.
<1> Jive: You're a real knee-biter!
<5> ...
<4> ...I gotta write that down.
<3> !m tuxxman tutorial
<7> Therion: haha
<6> tuxxman: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<3> Read that first...
<5> i ask for help
<3> Then go to the adding users part.
<1> tuxxman: from within the mysql command-line client... or use a GUI tool...
<5> and you just bitch at me for asking
<5> bye, ***holes
<4> Wow...
<1> Too busy whining to see the help
<2> phew
<2> ok
<4> At least hes gone
<3> He should use Oracle..
<2> so... my reasoning for the lock may be sound after all
<0> tuxxman: the fact that something is new to you, does not necessarily mean you can't understand it. but if you approach it with that attitude and immediately bite ppl saying stuff, then it's pretty much a guarantee that you will A) not get it and B) won't ge tany help. people, oddly enough, tend to be fairly hesitant helping people who bitch at them. weird, that.
<4> He left dude.
<7> he already left.
<3> Too late :(
<4> =P
<1> TYPE FASTER!!!
<4> lol
<0> whatever
<4> So
<0> nothing lost there.
<4> But theres some to gain with me
<1> o/` You want it all but you can't have it o/`
<2> I use only a single (atomic) statement to do the insert
<4> If you guys help me ill help others
<1> M: ARe there or are there not other statements in this transaction?
<8> hi I'm trying to learn mysql- and I tend to learn things better hands on than just reading about them-I have a problem that I think I can use mysql to solve-but my logic isn't so great I guess or I'm confusing myself, I'd like to use mysql to help me keep track of money clients owe me for computer repairs- can anyone help a little ?
<3> sesstreets, Didn't Therion help you?
<2> no, no others
Return to
#mysql
or
Go to some related
logs:
#web
#centos
ubuntu video4linux
wine was unable to initialize any audio drivers amarok
gentoo-sources+reiserfs4+patch
linux hybrid sleep -vista
#web
/bin/sh: cmp: command not found Try setting CONFIG_KALLSYMS_EXTRA_PASS
#physics
gnomebaker burn free what is
|
|