| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> !man corrupted myisam
<1> (Corrupted MyISAM Tables) : http://dev.mysql.com/doc/mysql/en/Corrupted_MyISAM_tables.html
<2> question which mysql function would you use if you want to search a particular column and remove Any text before char "X"
<2> ie in column abc, I would want to remove any text before the , ~ abc
<3> does anyone here know phpmyadmin?
<2> i do.. alternatively try #Phpmyadmin
<3> i need to know how to p***word protect it so that only i can log in
<2> that's beyond phpmyadmin.. there you needa p***word protect the folder or something
<2> if you have proper hosting you can usually p***word protect folders
<3> im running my own apache server
<3> for testing
<2> htaaccess.. but i found it hard to setup~
<3> ok
<3> thankyou
<2> you could also just find a basic php p***word protect script and include it in the phpmyadmin/index
<2> thats what i did once
<2> so anyone know how to delete data in a column based on a certain Char?
<4> hey friends. im in the body of a procedure. i want to select 3 column from a row in a table. i will do some thing with them. but how am i gonna select them?
<2> geez
<2> some people just don't have patience :/
<2> :S
<2> where the hell is everyone
<2> meh
<5> rofl stormchaser is an ***hole
<5> what you want ot do is substring and strpos
<5> find the location of your string, substring from there to end
<2> hmm well i don't want to edit the echo value i wanna actually change the DB
<2> like remove the values in the DB before the ,
<2> i just can't remember how i did it before.. i think i used concat or something :/
<5> same thing
<5> anything you can do with select you can do with update
<5> mostly
<2> true
<5> like select substr(replace(
<2> ah
<5> or update table set col = substr(replace(
<2> oh yeah i think thats how i did it before
<2> what do you need the substr for? just to change the data?
<6> hello :)
<2> update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
<6> can anyone see why this query makes my database freeze / lockup
<6> SELECT cpu3d_review.*, cpu3d_review_page.*, cpu3d_users.* FROM cpu3d_review LEFT JOIN cpu3d_review_page USING (review_id) LEFT JOIN cpu3d_users USING (user_id) WHERE cpu3d_review.review_published = 0 AND user_id = '1 ORDER BY cpu3d_review_page.review_page_id LIMIT 10;
<2> o_o
<6> ohh wait I see it already
<6> missing '
<7> Pardon my ignorance here, I'm testing mysql 5.x, and I've built up 5.0 and 5.1 in separate dirs. I'm trying to start it, and I've lost my previous startup line... can someone give me a hand here?
<6> dumb me
<7> /usr/local/mysql-5.1.6/bin/mysqld_safe: line 376: /usr/local/mysql-5.1.6/var/angst.err: No such file or directory
<6> ^.^ !
<6> adios
<7> Why is it looking for /var/ inside the mysql path?
<2> alrighty how does this look - update cdl set image = replace(image,'%,',',');
<7> Does someone have an example of a mysql startup line?
<2> i don't need a " " around the , do i?
<2> ah crap that query didn't work -_-
<6> one quick question if I may USING was implimented 3.2 upwards or later ?
<7> Anyone know/
<5> only questions, no answers
<5> :(
<2> too many indians
<7> Yep
<2> bah anyone see anything wrong with this update cdl set image = replace(image,'%,','');
<5> akumanz, try to make sure you can do % in a replace
<2> hmm
<2> can't you?
<2> all the manuals and tutorials i'm finding when searching for mysql replace are lame
<8> Try \%
<7> sigh
<9> hrm, I am doing a multiple table join. the explain showed ALL type(the worst) and no key used for two of the tables so I added an index of the column being joined on to both, and one is now "ref"instead of "ALL", btu the other remains and only lists the new index as a possible key
<9> I analyze'd the tables involved
<2> hm k
<9> but still listed as possible key, it seems pretty clear to em it shoudl be used, though
<2> still no luck -_-' update cdl set image = replace (image, "\%,", "");
<9> select distinct content.* from content, ads, unitcampaigns, campaigns where uc_campaign=cm_campaign and uc_campaign=ad_campaign and cn_content=ad_filename and cm_active=1 and ad_active=1 and uc_uid='ALPHA10001';
<9> I added an index for cn_content and ad_filename
<10> where can i see mysql remote connection error logs?
<9> same place as regular error log, I think
<11> Hi guys, I've got a question for you. I'm updating two fields in a table of 2 million rows using user functions, like this: UPDATE mytable SET field1=fn_myfunc1(id,param1), field2=fn_myfunc2(id,param2). I've tested those functions on smaller tables and worked like a charm. However, when using them on the bigger table, memory usage goes to infinity, crashing mysql server. By the way, I'm using my-medium.ini settings on a Win2000 with 1Gb RAM.
<11> Is there a sort of cleanup or setting that I'm missing when creating functions ? (sorry for long post)
<9> rabt: not prefacing with silly statements like "i have a question" hels to shorten things. :)
<11> got it :)
<2> yeah always start with "question" or "got a question"
<9> I haven't even tried 5.x yet, so no experience with functions liek that, yet
<9> akumanz: or just end with a question mark
<2> i just set up a function in MIRC so that if I ever login to #php / #mysql it auto says "question"
<2> saves me 2 seconds
<2> increases efficiency too
<12> i have 200 items each with thousands of records ***ociated in a table. each item has a different start date and i need to count the records in the large table from each item's individual startdate. theres no efficient way to do this is there
<13> akumanz: nice to hear you only log in when you want help from others ;-)
<2> yeah man.
<2> thats how i roll. but sometimes i end up helping people
<9> any ideas on why my new index isn't being used, o rhwo to get mysql to see it as more than a possible key?
<2> crazy world...
<5> rofl got banned from #php for helping someone
<5> what a world
<2> who
<5> same guy, stormefgt
<2> yeah man. this is IRC. take it or leave it
<2> oh Storm
<2> yeah he's just sad.. he got cancer
<5> well, you know i hang out int hat channel all the time
<2> lost one of his testicles
<5> pwnt
<2> yeah
<5> is that a joke?
<2> nah
<5> are you serious?
<2> nah
<5> k
<5> woulda been funny
<2> sorta
<2> he is sad though
<11> bored, aren't you?
<2> his mum berates him
<5> well no ****, but so is most ops
<2> nah
<5> stop disagreeing n00b
<2> i'm just trying to find this dam SQL query.
<2> and so i've given up for time being
<5> anyway, i spend a lot of time helping people in #php,
<5> to be banned, well, the ops are just ruining the channel
<2> ah well
<5> more free time
<2> you'll get over it
<9> albo: jost join on the tables on whatever ***ociates the items *and* record date > the startd date
<5> maybe..
<5> last time i was banned, it took 2 icecream boxes to get over it
<2> ..
<2> i get banned all the time
<5> pwnt
<9> well #mysql certainly isn't the lpace to discuss #php drama
<5> know what else happened in php?
<5> let me tell you...
<2> nah
<2> k
<5> afk
<2> k
<7> This doesn't make sense
<2> reckon
<2> so whats up with you setuid
<7> I have max_allowed_packet set to 256M, and my .sql dump file is 55M, and it tells me line 58 exceeds max_allowed_packet
<7> wtf?
<2> 55mb
<2> have you considered doing a CSV dump?
<7> Nope
<7> Let me try that
<2> yeah do csv
<2> it'll be smaller
<7> What's the syntax?
<2> SQL is lame. it says INSERT INTO #%#@% VALUE #@%@# #$% #@% @#% @# like 5 million times
<2> not sure really.. I usually just use Phpmyadmin to export import
Return to
#mysql
or
Go to some related
logs:
conrad gentoo c compiler cannot create executables
#ubuntu
airsnort error fetching interface
#linux
striping quotes from a string perl
configure terratec vmplayer
if3 ignores redirects
unknown-block(0,0) on usb-hdd boot
ubuntu cedil
#suse
|
|