#mysql
02 November 2007
Total 16 pages. You are browsing page 4/16.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
07:21 <****> and i want to update some dates, $date+1 day,using php
07:22 <****> $query = "UPDATE table SET column = '$date' + INTERVAL 1 DAY"; assuming $date is sanitized
07:22 * chadmaynard strokes thumbs
07:22 <****> ok
07:22 <****> letme try
07:22 <****> no you may not try!
07:23 <****> try it on chadmaynard
07:23 <****> he doesn't mind it
07:23 <****> : (
07:23 * chadmaynard might
07:26 <****> do you guys usually store currency as decimal or integer in the db?
07:32 <****> chadmaynard: is that also OK :" where (number%100)='40'
07:39 <****> CodeOfficer: depends on who you ask
07:39 <****> power: syntax yes
07:39 <****> chadmaynard: true true, but with no responses I'm right where i begun. heh
07:46 <****> thanks for your insight though !
07:47 <****> CodeOfficer: I'd use a decimal
07:47 <****> a (10,2) ?
07:48 <****> sure
07:49 <****> nils_:
07:49 <****> !
07:50 <****> what's up?
07:50 <****> Nothing.
07:50 <****> I'm doing laundry
07:50 <****> boring!
07:50 <****> it's 2:53 AM and I'm doing laundry....
07:50 <****> yea but i have to do it.
07:50 <****> 7:54 PM here and I'm still up
07:50 <****> nils_: wow
07:51 <****> err
07:51 <****> AM
07:51 <****> hehe
07:51 <****> yea i might not sleep tonight
07:51 <****> no sleep tonight
07:51 <****> red bull at hand
07:51 <****> sleep is overrated
07:51 <****> went to the football game earlier and i'm just not in a sleeping mood
07:52 <****> I just got a lot of work to do...
07:52 <****> and I don't want to do it on the weekend
07:54 <****> you know you'll work this weekend nils_
07:54 <****> yeah on my liver ;)
07:55 <****> hah
08:17 <****> hi
08:18 <****> if there are several records of the same field, how can I get one?
08:27 <****> Kartagis: what do you mean?
08:27 <****> chadmaynard: i think the keyword was distinct
08:28 <****> chadmaynard: what I want to do is, get one of the same several records in a field
08:29 <****> if it contains several '1's, call one of them
08:29 <****> do I make myself clear?
08:37 <****> group by field
08:38 <****> right, that worked
08:38 <****> thanks a lot
08:39 <****> wasn't there a keyword distinct or am i mistaken?
08:39 <****> in a table with a DATE column,can i group data month by month ?
08:39 <****> Kartagis: there is but it works on a row basis not field basis
08:39 <****> karsten: select distinct , this is for distinct rows, not column
08:39 <****> power: group by month(dateCol);
08:40 <****> thnaks
08:40 <****> maybe you want the year as well
08:54 <****> Hi.. My databse was crashed and I am trying to recover..
08:54 <****> When I run this command
08:54 <****> myisamchk --silent --force --fast --update-state --key_buffer_size=64M --sort_buffer_size=64M --read_buffer_size=1M --write_buffer_size=1M attachments.MYI
08:55 <****> It gives an error
08:55 <****> myisamchk: warning: Size of indexfile is: 417792 Should be: 1024
08:55 <****> myisamchk: Unknown error 126
08:55 <****> myisamchk: error: Can't read indexpage from filepos: -1
08:55 <****> myisamchk: Error writing file 'attachments.TMD' (Errcode: 5)
08:55 <****> !perror 5
08:55 <****> System error: 5 = Input/output error
08:55 <****> I am sorry I know that I am flooding the channe
08:55 <****> Input=Output ...? Well actually the /var/mysql is an nfs mounted share
08:59 <****> However If I do touch test in the directory.. Its happening fine
09:00 <****> Any way/.. I can tell myismcheck to write anywhere else...
09:00 <****> say /tmp
09:11 <****> Can anyuone help me please..
09:20 <****> having a problem :
09:20 <****> 1265: Data truncated for column 'rem_one_month' at row 1
09:20 <****> (UPDATE data SET rem_one_week = '539', rem_one_month = '2\'156', ...
09:41 <****> hi, is it possible to tunnel gui program to a remote server mysql server thats using socket?
09:41 <****> morning...
09:41 <****> morning...
09:41 <****> vge: I guess sshfs will do that for you
09:42 <****> ill look into it, ty
09:46 <****> NP
09:46 <****> are u suggesting to mount the socket to localhost in short?
09:56 <****> How many people does it take to change an object-oriented light bulb?
09:56 <****> Change it? Aw shucks, I was going to reuse it.
09:57 <****> lol
10:01 <****> pasted that joke in the wrong room lol
10:01 <****> don't try that in ##java ;)
10:02 <****> lmao
10:04 <****> who can help me with extracting year,month and day from date_add ,INTERVAL -1 DAY
10:04 <****> I want to select all users from yesterday but dateadd= datetime
10:08 <****> does anyone know a suitable channel to ask an hsqldb question in?
10:18 <****> Shees, I need some help
10:18 <****> ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len: 1635280189, event_type: 112
10:18 <****> In the binlog of my master
10:20 <****> Weird thing is, one of my slaves has stopped working due to this (as I'd expect), but oddly enough I've also got one slave that's happily replicating
10:22 <****> sensei: hmm max_allowed_packet maybe?
10:24 <****> nils_: Possibly, not sure
Total 16 pages. You are browsing page 4/16.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last