| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13
Comments:
<0> heh
<1> so ive been told
<2> $string = implode('', $array); implodes an array into a string
<1> so that would work for $result
<1> let me ask you this...
<1> in this query mysql_query("select * from test_attendees WHERE ATTENDEE_ID like
<1> '".$var."' AND SHOW_ID = 14");
<1> sorry
<1> thats supposed to be one line :-)
<2> the result from that is a sql resource, not an array
<1> ah
<2> but this is a ##php question
<1> i know
<1> i don't like those guys
<1> say ATTENDEE_ID is a number "777556655"... and $var returns 234234234|234234234|234234234234|2372726262| mysql_query("select * from test_attendees WHERE ATTENDEE_ID like
<1> '".$var."' AND SHOW_ID = 14");
<1> ****
<1> so sorry
<1> scratch that last part
<1> how would i match 777 to 444|555|666|777| ($var) in that query?
<1> would it be ATTENDEE_ID like '%".$var."%|' ?
<3> wtf
<3> why use like with id fields
<1> explain..
<4> Anyone know how to get a count on how many records are in a database?
<2> $array = explode('|', $var); $var = 'ATTENDEE_ID = '.implode ( ' OR ATTENDEE_ID = ', $array); mysql_query("select [...] WHERE ".$var." AND SHOW_ID = 14");
<2> something like that
<2> FatherTyme, SELECT COUNT()
<2> read up about that
<4> there's no SHOW statement that can provide that information?
<2> not afaik
<4> So sad.
<4> Was trying to find a way of doing it without doing a SELECT statement.
<2> why?
<1> kestas... http://pastebin.com/566792
<1> fathertyme... you can find a sample row count in the script im working on here: http://pastebin.com/566792
<2> no-dx, you need to set up a sub query to do that
<1> but thats PHP nevermind...
<3> id's are exact; where id=1234; not where id like %1234%; but then i've not followed your talks
<1> bah
<1> im so confused
<1> yet so close
<2> WHERE ATTENDEE_ID IN (select attendee ids here) AND SHOW = 14
<1> what does that statement do?
<2> no-dx, read up about sub queries
<1> g thanks
<1> can't use subqueries... im to outdated
<1> and i can't change that
<1> don't wanna use concat... cause theres 60,000 records
<1> i thought i was soooo close
<2> meh, showed you how to do it without subqueries too, but whatever
<2> sleep time
<1> wait!
<1> how would i do it without subqueries?
<1> where attendee_id in (select attendee_records from test_orders) and SHOW = 14 ?
<1> bah
<5> anyone here from NYC by any chance ?
<6> only if you have a lucrative job offer
<5> actually it's for help for this weekend.
<4> what's the gig?
<5> FatalRemedy: you are from NYC ? :) If so, can I pvt ?
<4> sure.
<1> anyone alive?
<1> i need help desperately
<7> I was wondering if anyone could help with some recommended ways to insert very large files? (~200-700mb)
<8> Use a file system, that's what they're designed for :-p
<7> I couldnt agree more - But, I'm not really the one to decide this
<8> Heh, one of "those" jobs eh
<8> LongBlob can store up to 4Gb apparently
<8> So, go nuts :s
<1> bah
<1> mysql_query("select * from test_attendees WHERE ATTENDEE_ID like
<1> '%".$all_attendee_records."%' AND SHOW_ID = 14");
<7> now, is there a way to do that without increasing the packet size though?
<7> ie, have it append, somehow
<1> that wonn't work cause $all_attendee_records is = 444|555|666|777|
<1> how could i restructure that so it looks within the $all_attendee_records
<1> ?
<1> i take it theres not a can be found in...
<8> Hm, donaldco: Well, if you want to avoid the max-packet issue, you could generate an ID to represt the file, then split it into 1MB chunks and store it row-by-row
<8> (***uming the max_packet_size is set to 1MB)
<7> thats not a bad idea =)
<1> anyone?
<7> thanks Detonator316, I think i'll be using that =)
<8> Oh, remember to flag the rows with a number or something so you can recreate the file in the right order
<8> No worries
<1> plz!
<1> bah
<9> I have about 300 db tables, how can I select the table names of just the tables which contain "_DD" in their name?
<10> if you have 5.0/5.1, select from the appropraite information_schema view with that pattern in your where clause
<10> or use SHOW TABLES with a similar where clause
<10> Before 5.0? ....grep it :)
<9> damn, thats a hefty answer
<9> hmmm
<9> SHOW TABLES is the way I was expecting to go
<10> Unless you have 5.0 that also does not do what you want
<10> But with 5.0, uh, SHOW TABLES WHERE Tables_in_[your_database_name_here] LIKE '%\_DD'
<10> Or, as above, use the I-S view
<10> Earlier versions have no equivalent
<9> thank you
<11> is there a way to make a default value calculated each time? like 30 days past today?
<10> Only with triggers, currently
<11> gr
<12> Therion, woot you got someone analyzing my bug already.. nice
<12> i'm lakez/xlx .. one is laptop, other desktop heh
<10> I didn't do it :P
<12> oh you didn't?
<10> ........or did i
<10> hehe
<10> what was the bug # :P
<12> I hope they can replicate it, cause I did it easily on 4.6 freebsd and 6.0 freebsd, so it should be good
<10> I forgot all my gmail logins, damn
<12> http://bugs.mysql.com/bug.php?id=17620
<10> Ah they are trying to verify it now
<13> I Can't install mysql-workbench http://pastebin.com/566814
<12> Therion, is it usually like sameday verified?
<10> xlx: depends on the bug...
<10> xlx: Depends on the provided test case ;)
<12> i guess i should have given a full test case eh? :)
<10> sid: So fix your library dependencies.
<12> step 1... 10
<10> sid: The message is perfectly clear.
<0> sid: install libxml2
<10> xlx: That helps immensely
<13> Jy, Therion , that is already installed
<10> sure it is
<0> well what version is installed
<0> cause the error message is pretty specific
<10> "#
<10> Package libxml-2.0 was not found in the pkg-config search path. Perhaps you should add the directory containing `libxml-2.0.pc' to the PKG_CONFIG_PATH environment variable No package 'libxml-2.0' found
<10> #
<10> configure: error: Library requirements (glib-2.0 libxml-2.0 >= 2.6.2) not met; consider adjusting the PKG_CONFIG_PATH environment variable if your libraries are in a nonstandard prefix so pkg-config can find them."
<10> Not very ambiguous at all
<13> Therion, Jy that is already installed
<10> ...
<0> which VERSION of it
<14> Is there a mechanism in mysql to dump every database to a text file?
<10> xbeanx: mysqldump --help
<14> Therion: :)
<15> !m xbeanx mysqldump
<16> xbeanx: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<14> Therion: SHoulda tried that first
<17> Hi, I have an already created table with lots of information on it, however, I did not notice it's default charset was latin1 and I don't need that... How can I change the default charset value to utf-8 ?
<12> !man alter table
<16> (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<18> back to basics: where this "!man" works? if i write it after mysql prompt does not work neither with that "!" nor without it. where is the f*ing manual?
<17> xlx: Thanks for the link!
Return to
#mysql
or
Go to some related
logs:
ubuntu+wireless-auth
proftpd.include suse anonymous
header file slow compile
mscorefonts on debian
prism3 ubuntu
qemu append nographic freebsd
pysqlite SELECT placeholder
xorg.conf viewsonic vp201b hsync
fail to initialize ASIC in the kernel
perl quantifier follows nothing
|
|