| |
| |
| |
|
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> In your dynamic $queryw building, you only have to add "AND state = $state" instead of checking to see if WHERE is already set.
<0> integral_, WHERE appointment_date BETWEEN '2006-01-01' AND '2006-01-31'
<1> can anyone breakdown this logic for me, it is using mod_auth_mysql "AuthMySQLGroupTable "Users u inner join CachedGroupMembers m on (u.id=m.MemberID) inner join Groups g on (m.GroupID=g.id)"
<0> It's a table join?
<2> !man numeric types
<3> (Numeric Types) : http://dev.mysql.com/doc/mysql/en/Numeric_types.html
<0> So you only use us for our bot?
<4> will: http://rafb.net/paste/results/cPoD6n48.html
<1> thanks
<2> :)
<5> will[werk]: Oh that's simple enough. So you're advocating a single table with a date/time column, description, etc?
<0> mizleading, Well, I could eliminate 3 lines
<0> mizleading, Also, CHECK YOUR USER DATA!
<4> those are dropdowns
<0> Which can be faked :)
<0> mysql_real_escape_string( $_REQUEST['subcat'] )
<2> ...easily
<4> 10-4
<4> ill do that now
<0> It's just good habit to not allow people to cause errors on your site...
<4> thats sounds reasonable =]
<6> :)
<4> will: so when selecting DISTINCT, i have to name all the column names, i cannot use wildcard?
<0> No
<0> You want to select all the columns anyways.
<0> !tell us about evil
<3> will[werk] asked me to tell you this: Evil is clearly defined at http://www.parseerror.com/sql/select*isevil.html
<4> ah ha
<4> when i put all the col names after distinct, i get "Column: 'name' in field list is ambiguous", which 'name' is the second field in the DB
<4> it does ok with one
<4> but obviously doesnt retrieve all the data i need
<7> change it to table.field
<4> ok
<0> Yay! We're coding properly now! :)
<4> hey i like to learn
<4> this is all good stuff
<0> I just hope it's not misleading...
<4> muahaa
<4> much appreciation
<4> oops it didnt like that either "Unknown table 'reps' in field list"
<4> LIAR!
<0> Paste the query
<4> k
<0> Here.
<4> SELECT DISTINCT nickname,reps.name,biz_name,address1,address2,address3,address4,phone,intl_phone,fax,email FROM reps_coverage r INNER JOIN country_list c ON r.country_id = c.id ".
<4> "INNER JOIN reps u on r.rep_id = u.rep_id " . $queryw ." ORDER BY u.nickname,u.name ASC
<0> mizery, SELECT DISTINCT nickname,reps.name == SELECT DISTINCT nickname, u.name
<4> i could probly make uy rich
<0> You made the alias, so use it.
<0> $2 tip?
<4> wow i didnt know u could use the alias b4 u created it
<8> tough to type while grinding sjrussel up
<0> mizery, FROM is done first.
<0> mizleading, FROM is done first.
<0> hansbrix, lol
<4> thats good to know
<0> I still make errors...
<8> will[werk]: well, i speak from experience.
<0> sjrussel, You slut.
<8> he tipped me $3 =/
<0> :(
<0> I don't have much experience. I'm a virgin...
<8> let's take this into PM.
<8> big boy.
<0> haha
<8> :P
<0> Where did he go?
<8> scared him off (:
<4> hey thanks a lot you guys
<4> ya leaned me
<4> :)
<4> learned
<9> hi. I was wondering if there's a recent online comparison of MySQL to PG?
<0> We uh... taught you.
<9> (trying to decide the proper db for a new Ruby on Rails project)
<10> sqlite
<0> tirkal, Which one do you know better?
<9> will[werk]: no question about it: MySQL
<9> that's what I used, I never tried PG.
<11> Is there a way to convert all MyISAM tables from a database into InnoDB without losing data?
<0> tirkal, Probably better to use MySQL then.
<12> tirkal: http://just****inggoogleit.com/?q=online+comparison+of+MySQL+to+PG
<0> lol
<0> inono, Yes.
<11> how could I do that
<0> !m inono alter table
<3> inono: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<10> tirkal: so learn one thing at a time..
<11> man
<11> I need to alter all tables at once tho
<9> Duesentrieb: I didn't google it, but the most recent comparison was over a year old
<0> Ok
<9> s/didn't/did/
<11> it doesnt seem like it supports ALTER TABLE dbname.*
<0> No
<0> Don't be lazy :)
<10> no..hence alter table...
<11> well I have like 15 tables man, ffs
<10> alter TABLE
<0> Start typing. It's only 15.
<10> AlTeR TaBle
<0> Not going to kill yo.
<0> u
<0> mizleading, SELECT a.MajorCat FROM distinctionInfo AS a INNER JOIN distinctionInfo AS b ON a.MajorCat = b.MajorCat WHERE a.Code = '$set' <-- how's that for aliasing...
<10> inono: mysql dbname -e 'show tables' > tables.sql ;
<12> inono: if typing is too much, write a script...
<11> excellent
<0> It's only 15!!!!
<11> its 12
<11> and screw you
<0> It's only 12!!!!
<10> vim tables.sql %s/^/ALTER TABLE/g ; %s/$/ ENGINE=innodb;/g
<11> i aint a ****ing monkey
<10> mysql dbname < tables.sql
<0> haha
<11> hmm
<10> i just wrote you your script in the time it took you to say you're not a monkey
<12> will[werk]: http://darkwing.uoregon.edu/~tgrandy/Humor/Monkey%20****ing%20a%20Football.jpg
<11> vluther, will that work on 3.23
<0> Duesentrieb, I don't get it...
<11> thanks, I had to type in those commands manually in vim, but thanks
<11> ERROR 1064 at line 1: You have an error in your SQL syntax near 'ENGINE=innodb' at line 1
<10> yes.. i wrote you a script to write a script..
<11> There's a different way to do that in 3.23, isnt it
<12> will[werk]: "****ing monkey". oh well :P (btw... never do a image search on that... ugh.)
<10> inono: the engine= probably needs work
<0> Duesentrieb, heh.
<0> Duesentrieb, Well, this monkey does other monkeys
<12> :)
<12> funny enough that the image search did *not* turn up an image of that
<0> At all?
<0> Google ****s.
<12> (unless you count homo sapience as a monkey)
<12> well, i didn't go past page 3
<10> i am not a monkey
<0> homo erectus
<0> vluther, Ape?
<10> no, i am a creation of $Deity
<0> heh
<12> "homo erectus"... no, i'm not going to goolge that either :)
<0> heh
<0> (lol, I hate actually laughing at the office and having everyone wondering why I'm laughing...)
Return to
#mysql
or
Go to some related
logs:
phpbb3 LDAP
Agere Systems AC'97 Modem v2136D linux
#math
r8169 disagrees about version of symbol struct_module
No module named Tkinter gentoo
Slaxpopcorn
#debian
pptp netscreen 5x
concatenate pdf ubuntu
#css
|
|
