#mysql
12 October 2007
Total 26 pages. You are browsing page 4/26.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
02:29 <****> seems this table stores time records for employess
02:29 <****> but not just the total time per day
02:29 <****> but time per project per day
02:29 <****> I'm needing to get a titla of time per day (I have that part)
02:30 <****> but then I need to know how many days each per has time recorded for
02:30 <****> I did a COUNT on 'date'
02:30 <****> but some USERS has 32 entries for a 6 day range!
02:31 <****> not what I thought was in here
02:31 <****> so now I have to rethink it and I'm stumped
02:31 <****> I don't think DISTINCT is waht I wnat to use, is it?
02:32 <****> anyone have any ideas?
02:33 <****> mysql has TEXT instead of CLOB, is that right?
02:33 <****> you could do a group by date
02:33 <****> OK, but will that tell me how many dates there are for a given USER?
02:34 <****> hm
02:35 <****> no
02:35 <****> well not just that
02:36 <****> you can groupby userid distinct date count date
02:36 <****> maby
02:37 <****> select distinct date count(date) from table group by userid
02:37 <****> thats my best guess
02:40 <****> I have setup replication and it is not working - anyone have any experience with this
02:40 <****> does mysql support subqueries to arbitrary depth?
02:40 <****> fowlduck, I doubt it. If you run into whatever the limit is, though, it seems likely you're doing something that's not ideal.
02:40 * Simetrical tries
02:41 <****> hehe
02:41 <****> I'm doing maybe two or three deep, or will be, rather
02:41 <****> noah: correct.
02:42 <****> i figured, and i suppose incorrectly, that if it supports many it must support arbitrary depth
02:42 <****> bad assumption now that i actually speak it
02:42 <****> It seems to support subqueries at least . . . 71 deep.
02:42 <****> Surprisingly.
02:44 <****> with bin-address, how can i set it to 2 ips i don't want to set it to 0.0.0.0 and allow everyone access
02:44 <****> Make that at least 355 deep.
02:44 <****> Interesting.
02:45 <****> Possibly there really is no limit.
02:45 <****> bin-address = bind-address
02:46 <****> I need help
02:46 <****> Okay, if you use too many you get a thread stack overrun.
02:47 <****> I hit that when I tried, uh, 1420 deep.
02:47 <****> So . . . probably not a big issue.
02:47 <****> . . . if it is, and I shudder to say it, you can apparently increase the stack size.
02:48 <****> TodoInTX: thx
02:49 <****> guys, when I would like to know what values for a particular atribute are the same in both table and these attributes are not primary key nor foreign key
02:49 <****> how can I do? I tried but mysql shows me a huge number absolutely wrong
02:50 <****> if I do a.id=b.id is fine but if I do a.other=b.other mysqls gest lost
02:50 <****> gets
02:50 <****> windows should support redirection
02:51 <****> I need help I am having trouble setting up replication and I cant get the master talking to the slave
02:52 <****> is that possible?
02:52 <****> hello
02:54 <****> hello, Say I do SELECT * FROM users and it returns 100 users
02:54 <****> But I would like to UPDATE users SET key=rowid; so it will rename key to 1 to 100
02:55 <****> any ideas how to do this? without scripting in a dynamic language?
02:55 <****> `m0, why do you want to do that?
02:55 <****> Because that field should have CCDSAGER1
02:55 <****> where 1 is the thing I have to enter
02:56 <****> since mysql 5 password() function hashes to 41 bytes, is it ok to define my own password columns as 64 varchar?
02:56 <****> or must it be "type and length identical"?
02:56 <****> I don't want to update each row separately
02:57 <****> any ideas how?
02:58 <****> Isn't there any reserved variable in MySQL that does that
03:02 <****> how do you change the name of a columb
03:02 <****> alter table colum modify something something?
03:02 <****> eg
03:02 <****> did you check the manuall?
03:02 <****> google MySQL update
03:04 <****> you use update to change the name of the a table columb?
03:06 <****> illsci, 1. its column 2. no you dont, you use alter
03:06 <****> start reading, stop asking
03:07 <****> anyone wanna help me do a totally insane join and subsequent insert!? don't all hop on the opportunity?
03:07 <****> i already found it
03:08 <****> the whole point of this chat room is asking
03:08 <****> i think its pretty safe to assume anything asked in here is written somewhere...
03:08 <****> anyway.. thanks!
03:09 <****> hello
03:09 <****> lo
03:09 <****> jello
03:09 <****> Is there a way to use LOAD DATA INFILE to insert into several tables? I need to split incoming data from a CSV with 148 columns into logical tables.
03:09 <****> i need to brush up on my sql-fu
03:10 <****> if i have a field which has dates stored in it in the format 14th sept 2007 10:14am, how can i convert this date to its timestamp equivalent?
03:12 <****> wanderingii: have you looked at str_to_date() ?
03:12 <****> no
03:13 <****> str_to_date(table.fieldname) ?
03:13 <****> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_str-to-date
03:13 <****> pleaze someone can give me an exemple how to work with variable
03:14 <****> why this dosen't work
03:14 <****> Declare x int ;
03:14 <****> set x=10;
03:14 <****> select x as nombre;
03:15 <****> wanderingii: you supply it with a format string as well, something like '%D %b %Y %r'
03:15 <****> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format
03:16 <****> werdnativ help me please
03:16 <****> how can I declare and set a variable?
03:16 <****> yea im looking at that page now, but i dont know what the format would be
03:16 <****> try something like the string I sent...
03:17 <****> Mon 25th Jun,2007 01:35 pm thats one of the dates in the table if it helps
03:17 <****> you can test the format string in the console by doing date_format( NOW(), '%D %b %Y %r' )
03:18 <****> Mon would be %a
03:19 <****> can anyone help
Total 26 pages. You are browsing page 4/26.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last