| |
| |
| |
|
Page: 1 2
Comments:
<0> nite all
<1> why i cant connect phmyadmin to mysql? i followed the instruction! error msg: Cannot load mysql extension. Please check your PHP configuration. - Documentation
<2> dont ask phpmysql questions here, dont use bold or colours
<1> lol
<1> who cares?
<1> just stfu if u dont know
<2> the chanell ops who will ban you care
<1> lol... i dont care
<2> nor do i, bye
<1> mysql is part of phpmyadmin
<1> phpmyadmin is part of mysql
<1> Eldritch = what an Id**t
<1> lol
<1> u r sux
<1> haha
<3> hi
<4> hi guys. my rows in a table have a field containing integers. what's the best way to retrieve the row with the greatest number?
<2> order by
<4> ok, so i have to retrieve the whole table?
<2> LIMIT 0,1
<4> aha
<4> thanks
<2> next time - read the bloody manual :-)
<4> are there problems related to "order by" when it comes to varchar fields? I'm trying to sort a varchar field, but it seems it doesn't search in "natural order", so 10 comes after 1 instead of after 9. What should I do to work around this?
<5> no
<5> it goes
<5> 0,1,2,10
<5> you understand?
<4> are you sure? it really doesn't for me...
<4> http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/SELECT.html these people have the same problem, apparently
<5> show me
<4> this one: select text from articles where priority!='top' order by priority desc limit 3"
<4> produces 10,7,9
<5> SELECT text FROM articles WHERE priority != 'top' ORDER BY DESC LIMIT 3
<5> yeah?
<4> yeah
<5> show me your data
<4> how would i do that? send you html file?
<5> yeah
<5> wellim lookin rightr now
<5> well pastethe file at pastebin.com
<4> nevermind, got it working, using this method:
<4> An easy way to force mySQL to order rows properly when the field type is varchar(etc) but the data is numeric, is to use 'order by field_name + 0'. This forces mySQL to view the data numerically, even if the field type is not numeric. Thus it will order the data into 1,2,10 rather than 1,10,2.
<5> http://80.203.143.126/
<5> yeah
<5> is that your page
<4> no, not that one
<5> show me which on
<4> it's not working right now
<5> :@
<6> hi, I have a table for questions and answers. My answer records make use of a 'parent id' field which refers to an id of another record (a question) in the same table. Is it possible to perform some kind of join that automatically organizes the results so that child records fall below their parent?
<7> is there any way i can replace strings in a MySQL table ?
<7> i want to replace every "X" by "Z" in the column "test"
<8> Can you do "SELECT DISTINCT clients.clientid" --- twice ?
<9> is any command through i can copy specific fields to another table?
<9> noone online?
<10> can you rename a database
<10> ?
<11> hello..
<11> can i make a php function stored procedure in mysql?
<12> I'm trying to cast a varchar column to a float in a select statement so that I can order by the column more effectively. How would I modify this?
<12> select * from item_info order by price
<13> I have this query
<13> $all=mysql_query("select sum(bytes),rule_name from logs where rule_name like '%Incoming%' group by rule_name");
<13> and i wanna sort data by sum(bytes)
<13> can anyone help me?
<12> nope, sorry
<12> I don't suppose you know how to sort by the numeric value of a varchar column?
<12> it's been killing me for an hour
<14> hi. how do i print all the table names with columns named 'LABEL' ?
<15> K_F: You missed a good one earlier
<15> calling one of the regulars an idiot
<16> how unusual
<15> "Mysql = phpmyadmin" "mysql is in phpmyadmin"
<16> hehe
<15> can't remmember exactly who or what
<15> I was just next door at the motel... They gave me 4 something and colas... and I'm not much of a drinker...
<16> hehe
<15> btw switching to the "Now" index results in an 11 minute query being a 3 minute query
<16> sounds like an improvement to me
<15> and switching from constant checks per user to a single check for all users and caching the result in ram brings a 2 hour job down to 14 minutes
<16> nice
<15> can't improve that much tho I'm afraid
<16> yeah, the loop did sound bad :)
<15> yeh... it was logical at the time
<16> have you optimized the mysql parameters?
<15> same code as the rest of the system... consistency over speed
<15> yeh, my mysql.cnf is fairly well optimized
<16> ok
<16> well, at least it got a little better
<15> I've scared them into giving me a new dual opteron with raid 1/0 for the database which will now only hold 4 days worth of data, the cache will get moved into this box and there will be a new box with nothing but 2x300 gig drives in raid 1 for holding data older then 4 days
<15> a little? down from 2.5 hours to quater an hour
<16> hehe
<16> pun intended
<15> we must keep 3 months worth of raw data readily accessable so...
<16> only 3?
<16> 12 or so here
<15> we have to maintain historical data for 7 years - the readily accessable data is just so we can give a whinging customer proof without waiting 3 hours for archives to uncompress
<16> we have a data retention law
<15> if I just have a machine there with no indexes that recives one of every row for this purpose, and the normal admin system (the one I've just spent 3 days working on) only contains 4 days worth... it should be MUCH faster
<15> yes we have here...
<15> I have to keep all logs for 7 years
<15> nothing says I can't repack them as binary bzip to convert 4.5 gigs into 250 megs
<16> good point
<15> a process that takes 4 hours to reverse... probably 1 hour if I re-wrote it in C (c:
<16> :)
<17> you should print them out, take pictures of them, then store the pictures digitally
<16> I like your thinking LanShark
<16> photocopies
<18> can a sqlite database be loaded with mysql?
<17> turn 4.5gb into 50tb
<16> ariqs: get a brain implant
<15> Our original system could tell you what port you connected from and what port you were connected to....
<18> sourcefile ,whatever it's called ;P
<15> but the new routers don't keep ports, only IP's
<16> ariqs: http://www.catb.org/~esr/faqs/smart-questions.html might increase your chance of getting a, in your perspective, positive response.
<15> so I loose some resolution in the data logging
<16> still too much ...
<17> if you have a good camera resolution isnt a problem ;)
<16> hehe
<18> pfft
<15> heheh
<16> Freman: http://www.secure-my-email.com/ <- data retention mentioned :)
<18> i'm tired, what I want can be inferred even if i'm not using the right catchwords. I have a sqlite sourcefile with .db extension, i don't have sqlite. I've messed with mysql and would like to browse the contents of the sqlite sourcefile if I can
<18> that's what I was asking in a much easier way ;)
<15> Original system: 600 tables... IP1_IP2_IP3_IP4 (srcport, dstip, dstport, firstpackettime, lastpackettime, packetcount, bytescount, date)
<16> hehe
<15> install sqlite, dump sqlite file to sql, then maybe mysql will import it
<18> so that's a no. Ok thanks ;)
<15> original system's flaw was everything was stored by IP... frequently people would change IP... so it no good
<15> cos all the customers are connected via pppoe I can account on the interface (being the customers username)
<15> new system raw_table (username, srcip, dstip, packets, bytes, date)
<15> new system summary (username, bytes, date)
<15> of course there's a "free" colum that's largely unused... for now
<15> hehe, I should shut up and go to bed
<16> hehe
<15> oooh examns... I miss those
<15> hehe, probably the only person I know who enjoys them (c:
<16> hehe
<19> How difficult is it to move a mysql database from one machine to another?
<19> Or is it as easy as moving one file?
<16> if you have any idea what you're doing not any problem
<16> how much data?
<19> right now, not much
Return to
#mysql
or
Go to some related
logs:
#linuxhelp
#linuxhelp
#javascript
a bittersweet life downland
SO_RECVTIMEO in linux
snr.gr russian
#MissKitten
#AllNiteCafe
#MissKitten
kif tintreda?
|
|