#mysql
28 October 2007
Total 17 pages. You are browsing page 4/17.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
02:15 <****> Shrews: http://www.flupps.org/pics/timestamp_benchmark.015.jpg
02:15 <****> hey flupps!
02:15 <****> :)
02:15 <****> how's it going?
02:15 <****> what's the diff between datetime and timestamp
02:16 <****> flupps: damn flupps, where do you find the time? was this for your UC talk?
02:16 <****> section31: 8vs4 bytes storage, timezone sensitivity y10k vs. 2037 range, auto-update abilities
02:16 <****> Shrews: yep
02:16 <****> Shrews: just submitted the same style for this years' (0% re-used benchmarks, of course) - so, maybe I'll have more fun numbers soon
02:17 <****> neat
02:17 <****> flupps, that'll work then
02:17 <****> i'll use datetime
02:17 <****> flupps: going well. how about you? where are you at currently?
02:18 <****> thanks
02:19 <****> Shrews: at home, going to stockholm tomorrow, then the carribean, then US for a few weeks, then I don't know
02:19 <****> at home? that's unusual :-)
02:20 <****> hola
02:22 <****> Shrews: I know :)
02:22 <****> flupps: irc on a cell phone? you're nuts :-P
02:22 <****> hehe
02:22 <****> you do what you can
02:25 <****> I do IRC on the phone too. : |
02:29 <****> on a mysql 5 install, the following works correctly: (SELECT .... ORDER BY first_sort LIMIT 5) ORDER BY secondary_sort
02:29 <****> it does not, however, on mysql 4 - can I assume that this is a v5 feature?
02:30 <****> Hello. Is it easy to pick a peice of data from a specific row. like can i get a peice of data that is in a row 'where fied1=1 and field2=2 and field3=3' ?
02:32 <****> Electrosys: yes
02:32 <****> chadmaynard: that's what champions do!
02:32 <****> anyways, bedtime
02:32 * flupps . o O ( ZZzzzzz )
02:33 <****> ki77a77: Thanks a lot.
02:33 <****> i have irc on my phone
02:33 <****> but i cant stand using it :-)
02:33 <****> because well..... its a phone.
02:41 <****> does this erase the contents of a field? update tblname set fieldname=null where trim(fieldname)="
02:45 <****> crackintosh: that would replace the field value with null. you shouldn't have to trim a column identifier, though.
02:46 <****> crackintosh: and I assume you are putting some value after the second =
02:46 <****> this is what my error log was telling me
02:46 <****> that it didnt work :-)
02:46 <****> crackintosh: remove the trim()
02:46 <****> and i think it just truncated after that. i just wanted to know wht it did exactly.
02:47 <****> what does trim() do?
02:47 <****> removes leading and trailing blank spaces in text fields.
02:48 <****> 'foo ' becomes 'foo'
02:49 <****> !man string functions
02:49 <****> (String Functions) : http://dev.mysql.com/doc/mysql/en/string-functions.html
02:49 <****> crackintosh: ^^
02:51 <****> hello
02:51 <****> anyone around today?
02:51 <****> almost always
02:51 <****> nice
02:52 <****> I'm trying to pull the row, where `date` is closest to a value
02:52 <****> something like this
02:53 <****> WHERE `date` = '2007-10-15'
02:53 <****> but if there's an entry for the 16th, but not the 15th, I want to pull that one
02:53 <****> any ideas?
02:54 <****> timinator: whats your acceptable range? +- 1 day?
02:54 <****> whats the function to get the last id assigned to an auto increment column?
02:54 <****> +- 30 days
02:55 <****> but I was going to add a LIMIT 1, so that it simply grabbed the closest entry
02:56 <****> does this still stand ' ) TYPE=innodb;' ?
02:56 <****> timinator: do a 'where date between yadda and yadda' using interval. see here http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
02:56 <****> perfect, thx
02:56 <****> Electrosys: newer versions use ENGINE
02:57 <****> How do I find my version.. I think i have 5 something.
02:57 <****> if one of the items in a record will be used to keep track of a set of ID numbers, is there a proper way to do that ? (not just sticking them in a text field like "5 9 14 91 145")
02:57 <****> select version();
02:58 <****> or: mysql --version
02:58 <****> so with 5.0.8 i would want to create my tables using the ENGINE type?
02:59 <****> my bad. its 5.0.38
02:59 <****> Electrosys: if you don't choose an engine, the default will be used.
02:59 <****> Which is what?
02:59 <****> Electrosys: depends on what you set it to at install. ;^)
02:00 <****> ki77a77: but type=engine ; is a good practice?
02:00 <****> ki77a77: won't that simply pull all the rows within that date range? rather that pulling the one row closest to the "date" supplied?
02:00 <****> Samus_Aran: look in the manual for auto_increment.
02:01 <****> Electrosys: you don't normally want to use deprecated terms. ENGINE has replaced TYPE.
02:01 <****> timinator: yes it will.
02:01 <****> ki77a77: one record auto-incriments, another record needs to store that value. in this case, it is keeping track of changes by storing each of the previous IDs
02:02 <****> ki77a77: so the list of IDs will grow over time
02:02 <****> Samus_Aran: then I am unclear as to what you are doing.
02:02 <****> ki77a77: so I'm wondering if there's a proper way to store a set of integers that will grow over time, or if I'm stuck using a text field and splitting on spaces
02:03 <****> k77a77: so i would want to use ENGINE=innodb ?
02:03 <****> is there a way to pull only the row closest to the supplied date? or will I have to pull many rows, and use something other than SQL to get the one row I need?
02:03 <****> Electrosys: yes, if you want to use innodb for your table.
02:04 <****> timinator: I can think of a way to do it for those before or after a date (order by and limit 1), but not before AND after.
02:04 <****> ki77a77: ya, I couldn't either
02:05 <****> ok, here's another question.....
02:05 <****> is innodb the best for a basic table?
02:06 <****> is there a way to LIMIT by 1, per `store` (an int(6) column in the table)
02:06 <****> Samus_Aran: I think you'd be better off using a child table, rather than some list stored in a field.
02:07 <****> s/LIMIT by 1/LIIMIT 1/
02:07 <****> oops... no bot
02:07 <****> timinator: you can get a max() or min() within a GROUP BY
02:07 <****> and I misspelled my change anyway.... LOL
02:08 <****> Does anyone know how to add to the MySQL "access hosts"? All the instructions I've found on Google are for cPanel, which I don't have.
02:08 <****> ah, ok
02:09 <****> (I just want to add an IP address to MySQL on one server so MySQL on another server can access it.)
02:10 <****> mysticron: my.cnf uses 'bind-address' to limit to 1 the allowed remote hosts.
02:10 <****> mysticron: comment out 'bind-address', and grant users access rights for the different hosts, or use 'user'@'%' to wildcard it.
02:11 <****> !man grant syntax
Total 17 pages. You are browsing page 4/17.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last