#mysql
29 October 2007
Total 28 pages. You are browsing page 1/28.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Mon Oct 29 00:00:40 2007
--- Day changed Mon Oct 29 2007
00:00 <****> thanks for the pastebin
00:03 <****> how do you copy a table?
00:03 <****> create new_table LIKE old_table; insert into new_table (select * from old_table);
00:03 <****> MicMac: schema or data or both?
00:03 <****> nevermind
00:03 <****> http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html
00:03 <****> both
00:03 <****> sorry
00:03 * chadmaynard smacks ToeBee
00:03 <****> schema
00:03 <****> MicMac: do what toebee said then
00:04 <****> now and forever
00:04 <****> i think my concepts of divisibility were off, this number seems to be evenly divisible by lots of thigns
00:05 <****> 362880?
00:05 <****> (2*3*4*5*6*7*8*9)
00:06 <****> 1191801600, timestamp
00:06 <****> YOu are factoring a timestamp?
00:06 <****> anyone know how to execute a quey in control center
00:07 <****> F5 prolly
00:07 <****> what is control center? A gui tool?
00:07 <****> chadmaynard: yes
00:07 <****> SQL Developer is F9
00:07 <****> mysql cc
00:09 * chadmaynard use sqlyog
00:10 * ToeBee uses his bare hands
00:10 <****> like chuck norris
00:10 <****> to masterbate?
00:10 <****> that was uncalled for.
00:11 <****> and spelled poorly
00:11 <****> err
00:12 <****> hello..
00:12 <****> hi
00:12 <****> do i need a conector for mysql+php + apache in windows ?
00:12 <****> cuz.. i cant mysql in php..
00:12 <****> protoloco: how'd you install PHP??
00:13 <****> alone
00:13 <****> protoloco: did you get the MSI installer or the zip?
00:13 <****> by hand..
00:13 <****> msi installer..
00:13 <****> from php.net
00:13 <****> protoloco: download the zip, and extract it into your install directory
00:13 <****> just say no to overwriting files, then edit php.ini and comment out mysql.so or .dll or whatever it is
00:14 <****> restart apache and you'll be fine
00:14 <****> the MSI doesn't some with extensions.
00:14 <****> the .zip has an ext folder
00:14 <****> tricky
00:14 <****> s/some/come
00:15 <****> fortunately just extracting the zip archive over the install works wonderfully
00:15 <****> you know too much about windows
00:15 <****> yea.....
00:15 <****> apachefriends.org
00:15 * chadmaynard hangs his head in shame
00:16 <****> delete whatever you did and downlaad xampp
00:16 <****> what is that? one of those all in one thingies?
00:16 <****> yes
00:16 <****> i don't like those
00:16 <****> apache, mysql, php, perl/python
00:17 <****> eh, I used one once back when I still actually USED windows :)
00:17 <****> unless you're going to try for IIS integration, bare installs are more trouble than they're worth
00:17 <****> In my experience when those don't work they REALLY don't work.
00:18 <****> so, i have an int column, holding unix timestamp... is there a quick way to get just the day portion or the timestamp and not the am/pm hours? like rewind to midnight of that day
00:19 <****> hardcorelamer: oooo. sounds messy
00:19 <****> hardcorelamer: date(from_unixtime(col)) ?
00:19 <****> that'll work if you never want to use indexes again. If you need indexing you might want to add a date[time] column a
00:19 <****> nd convert
00:20 <****> yeah, i was wondering if there was a leet trick or something, i can do date(unix_ts(from_unix())) or some combo like that
00:20 <****> working with legacy stuff here, some date and times are 2 cols, some are 1
00:20 <****> 2 is much easier
00:21 <****> hardcorelamer: any time you use a function you kill indexes
00:21 <****> even with a where on the straight col ?
00:21 <****> XX ?
00:22 <****> that'll work if you never want to use indexes again."
00:22 <****> ki77a77: well i mean forever in the life of that schema
00:22 <****> sometimes it helps to be dramatic
00:22 <****> what's the deal with functions killing indexes?
00:23 <****> chadmaynard: you sounded like Don Corleone in The Godfather.
00:23 <****> chadmaynard, i dont see any mysql.so or .dll ...
00:23 <****> :S
00:23 <****> that php.ini should be the new one ??
00:23 <****> hardcorelamer: well since the function changes what output you don't acutally have an index on the data.
00:23 <****> or the old one ?
00:23 <****> protoloco: new one
00:23 <****> chadmaynard: "I'll write you a trigger you can't refuse."
00:24 <****> ki77a77: heh
00:24 <****> protoloco: should be a list of "extensions"
00:25 <****> but, it should have found the data already to perform the function... with indexes
00:25 <****> which should i edit ?
00:25 <****> or should i use the php.ini-recommended that comes with the zip
00:25 <****> protoloco: do you have special needs ? : )
00:26 <****> that didn't come out elegantly... but mysql isn't running the function on every single row in a table.... ?
00:26 <****> is there month(from_unix(col)) ?
00:26 <****> or only year?
00:26 <****> hardcorelamer: lets say i indexed an integer col with ten rows 1-10
00:26 <****> rimad: month, year, minute...etc
00:26 <****> chadmaynard
00:27 <****> niiiiiiice :D
00:27 <****> hardcorelamer: then i sorted (order by function(intCol)) <- function might return 6 for everything 1-10, so the indexes are useless
00:27 <****> rimad: dayormonth, monthname, dayname...etc
Total 28 pages. You are browsing page 1/28.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last